ETL Data Migration Validation Engineer

Role Description

The ETL Data Migration Validation Engineer will be responsible for independently validating large-scale data migrations across platforms (e.g., Oracle, PostgreSQL, CSV-based sources) involving high-volume datasets (100K–250K+ records). This role requires strong, hands-on SQL expertise and the ability to work directly from mapping documentation—often without direct access to the source database. The ideal candidate must be comfortable designing reconciliation strategies, performing set-based comparisons, validating composite keys, and identifying discrepancies across systems. Approximately 70–80% of this role is dedicated to data migration validation and reconciliation.

Responsibilities

• Data Migration Validation & Reconciliation
  • Independently validate data migrated from legacy systems to the GMM platform using complex SQL queries.
  • Perform set-based comparisons (e.g., EXCEPT/MINUS logic, full outer joins) to identify missing, extra, or mismatched records.
  • Reconcile high-volume datasets (100K+ records) across source and target environments.
  • Validate composite key integrity and multi-table joins based on mapping documentation.
  • Detect and resolve data multiplication caused by improper join logic.
  • Validate incremental loads versus full data loads.
  • Identify and analyze discrepancies related to null handling, outer joins, and transformation logic.
  • Validate cross-platform migrations (e.g., Oracle to PostgreSQL, CSV to database).
  • Perform validation when direct source database access is unavailable, leveraging staged data, flat files, and documentation.
• Schema & Data Integrity Validation
  • Validate schema alignment, data types, constraints, and field-level transformations.
  • Identify truncated values, formatting discrepancies, whitespace anomalies, and encoding issues.
  • Support checksum/hash total validation techniques where applicable.
  • Reverse engineer transformation logic when documentation is incomplete.
• Independent IV&V Execution
  • Operate independently from development teams to provide objective validation findings.
  • Document defects and reconciliation findings clearly and concisely.
  • Participate in Agile ceremonies to align validation efforts with migration releases.
  • Provide risk-based recommendations to federal stakeholders regarding data accuracy and integrity.

Qualifications

• U.S. Citizen eligible to obtain and maintain a Public Trust clearance.
• 5+ years of hands-on SQL experience, including complex joins, subqueries, aggregates, and set-based comparisons.
• Demonstrated experience validating large-scale data migrations (100K+ records).
• Direct experience performing source-to-target data reconciliation.
• Experience working from mapping documents to validate field-level transformations.
• Experience validating composite keys and multi-table relationships.
• Experience identifying null-related discrepancies in outer joins.
• Experience validating cross-platform migrations (e.g., Oracle, PostgreSQL, SQL Server, CSV).

Desired

• Experience supporting federal modernization programs.
• Experience validating financial or grant-based transactional systems.
• Familiarity with ETL processes and data staging environments.
• Experience working in an Independent Verification & Validation (IV&V) capacity.
• Exposure to hash/checksum validation techniques.
• Familiarity with Agile methodologies.

Benefits

• Traditional and HSA-eligible medical insurance plans.
• 100% employer-paid dental and vision insurance options.
• 100% employer-sponsored STD, LTD, and life insurance.
• 5% 401(k) company matching.
• Flexible schedules and teleworking options.
• Paid holidays and PTO Accrual Plans.
• Paid Parental Leave.
• Professional development and career growth opportunities.
• Team and company-wide events, recognition, and appreciation.