
Data Migration Engineer
Prime Hiring Solutions
Job description
Job Title: Data Migration Engineer
Location: Austin, TX
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.