Data Migration Engineer

Title: Data Migration Engineer

 Location: Austin ,TX

 Job Summary

• We are seeking an experienced Data Migration Engineer to support large-scale data transformation and migration initiatives. This role involves defining data mapping and transformation requirements, developing migration solutions, executing migration activities, and ensuring data quality and validation throughout the migration lifecycle.

Job Description

• We're looking for a Data Migration Engineer to help design, develop, and execute end-to-end data migration solutions. In this role, you'll work closely with project, integration, and validation teams to deliver data transformation specifications, migration strategies, SQL-based migration scripts, and migration execution reports.

What You'll Do

• Define data transformation requirements, mappings, and migration specifications.
• Develop migration plans supporting full-load and incremental migration strategies.
• Create SQL-based migration, validation, and reconciliation scripts.
• Perform data analysis, conflict detection, and data quality assessments.
• Execute migration activities across staging and production environments.
• Validate migrated data and reconcile source-to-target results.
• Monitor migration performance and resolve data inconsistencies.
• Produce migration reports, execution documentation, and validation results.
• Collaborate with project, integration, and validation teams to ensure successful migration outcomes.

Required Qualifications

• 5+ years of experience in data migration, data conversion, or ETL development.
• Strong proficiency in SQL, T-SQL, PL/SQL, or equivalent database technologies.
• Experience with source-to-target data mapping and transformation design.
• Experience developing migration, validation, and reconciliation scripts.
• Knowledge of data quality, data validation, and conflict resolution methodologies.
• Experience executing migrations in staging and production environments.
• Strong analytical, troubleshooting, and problem-solving skills.
• Ability to document processes and communicate effectively with technical and business stakeholders.

Preferred Qualifications

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

How We Work

• Collaborative environment with close partnership across project, integration, and validation teams.
• Structured migration lifecycle with detailed planning, testing, and execution phases.
• Emphasis on data accuracy, quality, and successful production deployment.
• Focus on documentation, continuous improvement, and knowledge sharing.

Skills
• Data Migration; SQL; T-SQL; PL/SQL; ETL; Data Transformation; Data Mapping; Data Validation; Data Reconciliation; CDC; Data Quality; AWS; Migration Planning; Database
Development; Production Support

SKILLS AND EXPERTISE

Data Migration, SQL (T-SQL / PL-SQL), ETL, Data Transformation, Data Validation