ETL Tester-Data Migration & Transformation Validation

Nexwave; Chicago (IL); On-site; USD 63,000 - 89,000; Full time

Job summary

Nexwave is seeking an ETL Tester for data migration and validation in Chicago, onsite from day one. The role focuses on leading testing for large-scale migrations and ensuring data integrity across enterprise platforms.

You will design validation strategies, develop SQL queries and automation scripts, and collaborate with engineers and analysts to define acceptance criteria and readiness assessments. This is a 12-month, onsite engagement with a daily rate of $55/hr on C2C.

Qualifications

• Experience leading testing for large-scale data migrations and validations.
• Strong SQL skills and ability to develop complex validation queries.
• Proven ability to design end-to-end data validation strategies across domains.

Responsibilities

• Lead testing efforts for large-scale data transformation and migration initiatives.
• Design and execute data validation strategies for accuracy and integrity during migrations.
• Develop complex SQL queries and automated validation scripts to reconcile source and target systems.

Skills

SQL Queries

ETL Testing

Data Migration

Data Validation

Automation Scripts

Data Quality

Collaboration

Tools

SQL

ETL Tools

Job description

Role : ETL Tester-Data Migration & Transformation Validation

Location : Chicago, IL ( Onsite from day 1 )

Duration : 12 Months

Rate : $55/Hr on C2C

JD:

• Lead testing efforts for large-scale data transformation and migration initiatives involving millions of records across enterprise Network Operation platforms.
• Design and execute comprehensive data validation strategies to ensure data accuracy, completeness, consistency, and integrity during migrations.
• Develop complex SQL queries and automated validation scripts to reconcile source and target systems at scale.
• Validate ETL/ELT processes, transformation rules, data mappings, and business logic across multiple data domains.
• Perform end-to-end testing of batch, real-time, and incremental data migration workflows.
• Identify, analyze, and troubleshoot data quality issues, migration defects, duplicates, missing records, and transformation anomalies.
• Collaborate closely with data engineers, architects, business analysts, and application teams to define test strategies and acceptance criteria.
• Generate detailed data quality metrics, reconciliation reports, and migration readiness assessments for stakeholders.
• Drive best practices in database testing, automation, and data quality engineering to ensure successful delivery of enterprise migration programs