Note: The job is a remote job and is open to candidates in USA. Revolutional delivers advanced technology solutions and mission support to federal agencies across various sectors. They are seeking an ETL Data Migration Validation Engineer to independently validate large-scale data migrations, ensuring the accuracy and integrity of data moved 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
Skills
- 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
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-- and so much more!
Company Overview