ETL QA Test Engineer (Data Migration & Transformation Validation)

Nexwave; Chicago (IL); On-site; USD 62,000 - 79,000; Full time

Job summary

Nexwave is seeking an experienced Data Migration & Transformation Validation specialist to lead testing for large-scale migrations in Chicago, IL. You will validate data across source and target systems, develop SQL queries and automation scripts, and test ETL/ELT processes and transformation rules to ensure data quality and readiness.

Ideal candidates have 12+ years in data migration/validation, strong SQL skills, and the ability to troubleshoot defects while collaborating with data engineers,

Qualifications

• 12+ years of data migration or validation experience.
• Strong SQL and scripting for data reconciliation.
• Experience validating data accuracy, completeness, and integrity across source and target systems.
• Ability to test ETL/ELT processes, data mappings, and business logic.

Responsibilities

• Lead testing for large-scale data migration and transformation projects.
• Validate data accuracy, completeness, consistency, and integrity across systems.
• Develop SQL queries and automation scripts for reconciliation and validation.
• Test ETL/ELT processes, mappings, and transformation rules.

Skills

SQL queries

Data reconciliation

Automation scripting

ETL testing

Data quality

Job description

- Data Migration & Transformation Validation

Location: Chicago, IL - Onsite (Only Locals)

Rate: $57/hr C2C/1099 (OR) $45/hr on W2 (Max Rates)

Exp : 12+

• Lead testing for large-scale data migration and transformation projects.
• Validate data accuracy, completeness, consistency, and integrity across source and target systems.
• Develop SQL queries and automation scripts for data reconciliation and validation.
• Test ETL/ELT processes, data mappings, transformation rules, and business logic.
• Perform batch, real-time, and incremental migration testing.
• Identify and troubleshoot data quality issues, duplicates, missing records, and migration defects.
• Prepare data quality, reconciliation, and migration readiness reports.
• Collaborate with data engineers, architects, BAs, and application teams.