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
Cloud • Information Technology • Productivity • Security • Software • App development • Automation
Responsible for designing data solutions, enhancing quality, and building scalable datasets while collaborating with stakeholders to meet business needs.
Top Skills:
AirflowAWSDatabricksPythonSparkSparksqlSQL
Insurance • Software • Energy • Financial Services
Design and scale data infrastructure, build data pipelines, collaborate across teams, manage data quality and governance, support analytics and reporting.
Top Skills:
AirflowAWSBigQueryComposerDbtGCPGoogle AdsGoogle AnalyticsKafkaLookerMetaOutbrainPythonSparkSQLTableauTaboola
Software
As a Senior Data Engineer, you will leverage advanced data technologies to improve analytics solutions for clients, ensuring data-driven decisions.
Top Skills:
AirflowAthenaAWSAws KinesisAzure SynapseBigQueryEc2EmrGlue EtlHadoopHiveIamLambdaMap ReduceNumpyPandasPythonRdsRedshiftS3SnowflakeSparkSQL
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.
