Data Migration ETL Engineer
Integral Federal1 day ago
Tysons, VA, USAMid Level / Senior
Base Salary
$130k - $140k/yr
Responsibilities
- Build repeatable SQL, Python, and ETL/ELT pipelines, staging schemas, data-cleansing rules, transformation jobs, and automated reconciliation reports.
- Review AI-generated extraction, migration, rollback, and transformation scripts for accuracy, performance, idempotency, security, and repeatability.
- Execute migration rehearsals, measure throughput and data quality, diagnose exceptions, and support final cutover plans.
- Implement row-level and business-rule reconciliation across source and target systems with evidence and audit logs.
- Coordinate with data analysts, data architects, QA leads, and VA stakeholders to resolve schema mismatches and mapping defects.
Requirements
- Bachelor’s degree in computer science or an IT-related field, or additional experience may substitute for the degree.
- 3–6 years of experience in data engineering, ETL/ELT, and large-volume database migration.
- Hands-on SQL and data engineering experience with relational data modeling and migration pipelines.
- Ability to code and debug Python and SQL scripts and critically review AI-generated transformation logic.
- Practical understanding of source-to-target reconciliation, exception management, migration testing, repeatable version-controlled pipelines, and cutovers.
- Preferred experience includes SQL Server, Oracle, Salesforce extracts, AWS GovCloud/VAEC services, DevSecOps automation, federal benefits or cemetery systems, PII protections, historical conversion, GIS data migration, synthetic data, reconciliation automation, and VA-authorized AI coding tools.
- Public Trust eligibility is preferred.
Benefits
- Medical, dental, and vision insurance.
- Flexible spending accounts.
- Short-term and long-term disability insurance.
- Life insurance.
- Paid time off and holidays.
- Paid parental leave.
- Immediate vesting in the 401(k).
- Earned bonuses and awards.
- Professional training reimbursement.
- Employee assistance program.
About Integral Federal
Integral Federal provides IT and mission support services to U.S. defense, intelligence, and civilian agencies, with offerings in cybersecurity, identity intelligence/biometrics, cloud, and systems engineering. Headquartered in McLean, Virginia and privately held, it operates on government contracts and task orders, including work supporting U.S. Army biometric systems and fielding activities.