ETL Data Migration Validation Engineer (IV&V)

Revolutional delivers advanced technology solutions and mission support to federal agencies across various environments. They are seeking an ETL Data Migration Validation Engineer to validate large-scale data migrations and ensure data integrity during the migration process from legacy systems to a modernized platform.

Responsibilities:

• 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
• 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
• 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

Requirements:

• 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)
• 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