The Senior Data Engineer will lead data migration initiatives, particularly from Oracle to PostgreSQL, utilizing AWS DMS, Python, and PySpark, while ensuring data integrity and quality throughout the process.
ProArch is seeking a highly skilled Data Engineer with 6+ years of experience in the IT industry, specializing in Data Engineering and Data Migration. The ideal candidate will have strong expertise in Oracle to PostgreSQL migration and be well-versed in AWS DMS (Database Migration Service). The role requires proficiency in Python and PySpark to work on various data migration projects and ensure seamless data transformations.
Key Responsibilities:
- Lead and execute data migration initiatives, specifically from Oracle to PostgreSQL.
- Design, develop, and implement AWS DMS solutions to migrate databases.
- Collaborate with cross-functional teams to understand data requirements and ensure smooth migration processes.
- Develop and optimize data pipelines using Python and PySpark.
- Troubleshoot migration issues and implement corrective actions to ensure minimal disruptions during data transfer.
- Ensure data integrity, accuracy, and quality throughout the migration process.
- Create and maintain detailed documentation for migration processes, workflows, and data transformations.
- Stay up to date with the latest technologies, best practices, and tools in data engineering and migration.
Requirements
- 5+ years of experience in the IT Industry, with a focus on Data Engineering.
- Strong hands-on experience with Oracle to PostgreSQL migrations.
- Expertise in using AWS DMS (Database Migration Service) for seamless data migration.
- Proficient in Python and PySpark, with a strong understanding of data engineering concepts and data pipeline development.
- Solid understanding of database architecture, SQL, and data modeling.
- Experience in troubleshooting, optimizing, and scaling data migration workflows.
- Ability to work independently and in a team environment with strong problem-solving skills.
- Excellent written and verbal communication skills.
Preferred Qualifications:
- Experience with other AWS services such as AWS Lambda, S3, and Redshift is a plus.
- Familiarity with other database migration tools and technologies.
- Certifications in AWS or other relevant data engineering domains.
Top Skills
Aws Dms
Aws Lambda
Oracle
Postgres
Pyspark
Python
Redshift
S3
Similar Jobs
Software
As a Senior Data Engineer, you'll lead data pipeline design, manage AWS infrastructure, provide architectural guidance, and mentor team members while ensuring optimal performance and scalability.
Top Skills:
AWSEc2EmrLuigiPythonRdsS3SnowflakeSQL
Information Technology
The Senior Data Engineer will develop end-to-end data solutions, ensuring performance and scalability, while integrating data from multiple sources.
Top Skills:
AWSAzureDatabricksGCPJavaPythonScalaSnowflakeSQL
Analytics • Business Intelligence • Consulting
The Senior Data Engineer will develop and maintain data engineering solutions, lead projects, and collaborate with clients on data governance and analytics.
Top Skills:
Python,Pyspark,Databricks,Aws,Azure,Gcp,Sql Server,Oracle
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.
