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
Healthtech
The role involves developing AI models, maintaining data pipelines, optimizing architectures, and collaborating with teams to meet data needs.
Top Skills:
AIAWSAzureJavaMachine LearningOperations ResearchPower AppsPower AutomatePower BIPythonScalaSnowflake
Artificial Intelligence • Information Technology
As a Senior Data Engineer, you will design data pipelines, optimize performance, and work on innovative projects with top-tier teams.
Top Skills:
AirflowAWSAzureDatabricksGitJenkinsPysparkPythonSnowflakeSQLUnity Catalog
Financial Services
As a Senior Data Engineer, you will develop and maintain scalable data pipelines, ensuring reliable data availability, mentoring junior engineers, and improving data infrastructure.
Top Skills:
AirflowAmundsenAWSAzureBeamBigQueryCollibraDatahubDbtGitGitlab CiGoogle Cloud PlatformHubspotJavaJenkinsKafkaMySQLPythonScalaSegmentSparkSQLZendesk
What you need to know about the Kolkata Tech Scene
When considering the industries shaping India's tech scene, gaming might not immediately come to mind. However, in the last decade, increased internet usage and greater access to mobile devices have catapulted the industry to new heights, with Kolkata-based companies like Virtualinfocom, Red Apple Technologies and Digitoonz, at the forefront, driving the design and animation of new gaming titles for players.
