Data Migration Engineer: End-to-End SQL & Validation

Intellectt Inc; Austin (TX); On-site; USD 55,000 - 62,000; Full time

Job summary

Intellectt Inc is seeking an experienced Data Migration Engineer to design, develop, and execute large-scale data migration initiatives. You will define data mappings, transformation rules, and migration strategies, working closely with project, integration, and validation teams to ensure data quality.

The role emphasizes SQL-based migration scripts, validation, reconciliation, and thorough reporting across staging and production environments, with a focus on delivering accurate, auditable

Qualifications

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

Responsibilities

• Define data transformation requirements, mappings, and migration specifications.
• Develop migration plans for 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 for success.

Skills

SQL

T-SQL

PL/SQL

Data mapping

ETL development

Data quality

Analytical skills

Documentation

Stakeholder comms

Job description

Intellectt Inc is seeking an experienced Data Migration Engineer to design, develop, and execute large-scale data migration initiatives. You will define data mappings, transformation rules, and migration strategies, working closely with project, integration, and validation teams to ensure data quality.

The role emphasizes SQL-based migration scripts, validation, reconciliation, and thorough reporting across staging and production environments, with a focus on delivering accurate, auditable