Data Migration Engineer

Job Summary

We are seeking an experienced Data Migration Engineer to support large-scale data transformation, conversion, and migration initiatives. The ideal candidate will have strong SQL and database development experience, along with hands-on expertise in data mapping, ETL, migration execution, validation, and reconciliation.

Key Responsibilities

• Define data mapping, transformation, and migration requirements.
• Develop end-to-end migration plans for full-load and incremental migrations.
• Create and maintain SQL/T-SQL/PL-SQL migration, validation, and reconciliation scripts.
• Analyze source and target data to identify conflicts, inconsistencies, and data-quality issues.
• Execute data migrations across staging and production environments.
• Perform source-to-target validation and data reconciliation.
• Troubleshoot data inconsistencies and migration failures.
• Monitor migration performance and optimize migration processes.
• Prepare migration execution reports, validation results, and technical documentation.
• Collaborate with project, integration, validation, and business teams to ensure successful migration outcomes.

Required Qualifications

• 5+ years of experience in data migration, data conversion, ETL, or related database development.
• Strong proficiency in SQL, T-SQL, PL/SQL, or equivalent database technologies.
• Hands-on experience with source-to-target data mapping and transformation.
• Experience developing migration, validation, and reconciliation scripts.
• Strong understanding of data quality, data validation, and conflict resolution.
• Experience executing migrations in staging and production environments.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent documentation and communication skills.

Preferred Qualifications

• Experience with ETL and large-scale data migration projects.
• Knowledge of Change Data Capture (CDC) and incremental migration strategies.
• Experience with AWS or other cloud environments.
• Understanding of data integration and system migration best practices.
• Experience with migration performance tuning and optimization.
• Familiarity with data governance and data quality frameworks.