Prime Hiring Solutions logo

Data Migration Engineer

Prime Hiring Solutions

On-siteAustin, TXseniorPosted 1h ago

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.