Data Migration ETL Engineer — AI-Validated Pipelines

Integral; Tysons (VA); Hybrid; USD 130,000 - 140,000; Full time

Benefits offered by this job

Medical Insurance

Dental Insurance

Vision Insurance

401(k) vesting

Parental leave

Paid time off

Bonuses

Training reimbursement

Employee assistance

Disability insurance

Life insurance

Job summary

Integral Federal is seeking a Data Migration ETL Engineer to design and implement auditable migration pipelines from VA legacy sources into VA-EISS. You will review AI-generated ETL scripts for accuracy, performance, and data integrity to support modernization efforts.

The role involves building SQL/Python pipelines, data cleansing rules, and automated reconciliation reports, plus coordinating with VA stakeholders for schema alignment and cutover readiness.

Qualifications

• Bachelor’s Degree in computer science or IT related degree with 3-6 years’ experience. Additional years of experience can substitute for a degree for the right candidate.
• Hands-on SQL and data engineering experience with ETL/ELT, relational data modeling and large-volume database migration.
• Ability to code and debug Python/SQL scripts and review AI-generated transformation logic critically.
• Practical understanding of source-to-target reconciliation, exception management and migration testing.
• Experience building repeatable, version-controlled pipelines and supporting cutovers.
• Public Trust

Responsibilities

• Build SQL/Python/ETL pipelines, staging schemas, data cleansing rules, transformation jobs and automated reconciliation reports.
• Review AI-generated extraction, migration and rollback scripts for accuracy, performance, idempotency, security and repeatability.
• Execute migration rehearsals, measure throughput and data quality, diagnose exceptions and support final cutover plans.
• Implement automated row-level and business-rule reconciliation across source/target systems with appropriate evidence and audit logs.
• Coordinate with Data Analyst, Data Architect, QA Lead and VA stakeholders to resolve schema mismatches and mapping defects.

Skills

SQL

Python

ETL/ELT

Data modeling

Data cleansing

Education

Bachelor's Degree in computer science or IT related degree

Tools

SQL Server

Oracle

Salesforce extracts

AWS GovCloud/VAEC

Job description

Integral Federal is seeking a Data Migration ETL Engineer to design and implement auditable migration pipelines from VA legacy sources into VA-EISS. You will review AI-generated ETL scripts for accuracy, performance, and data integrity to support modernization efforts.

The role involves building SQL/Python pipelines, data cleansing rules, and automated reconciliation reports, plus coordinating with VA stakeholders for schema alignment and cutover readiness.