ETL QA Test Engineer

ZealHire Inc.; Illinois; Híbrido; USD 83.000 - 124.000; Jornada completa

Descripción de la vacante

ZealHire Inc. in Rosemont, IL is seeking a seasoned ETL Quality Assurance Test Engineer for a contract role. The position is hybrid and open to local Chicago-area candidates, with a focus on data integrity across MDM and Data Warehouse environments.

You will own quality from strategy through execution, leading ETL testing, writing complex SQL, RCA, and reporting. Strong communication and enterprise QA experience are essential.

Formación

• 10+ years hands-on ETL testing in enterprise environments.
• 10+ years QA experience in enterprise environments.
• 5+ years Data Warehousing, including dimensional databases.
• Intermediate to advanced SQL for complex queries.
• Proven RCA, test lifecycle management, QA best practices.
• Strong analytical skills and attention to detail.
• Excellent communication and client-facing interpersonal skills.

Responsabilidades

• Lead ETL testing across MDM, data warehouse, and legacy systems.
• Write and execute complex SQL queries for validation.
• Develop and execute test strategy, design, and execution plans.
• Perform RCA and produce heatmaps and reports.
• Collaborate with development and business teams to resolve issues.
• Work within Agile and Waterfall methodologies.

Conocimientos

ETL testing

SQL

Data Warehousing

QA processes

Root Cause Analysis

Agile & Waterfall

Communication

Herramientas

SSIS

Kodda

Descripción del empleo

Location : Rosemont, IL Hybrid Need locals only

USC/GC/EAD ONLY 2 F2F interviews
We are looking for a seasoned ETL Quality Assurance Test Engineer to join a high-impact data team on a contract basis out of Rosemont, IL. This is a hybrid role a mix of on-site and remote working and is open to local Chicago-area candidates only.

You'll play a critical role in ensuring data integrity across a complex ecosystem that includes Master Data Management (MDM), Data Warehouse environments, legacy platforms, and online database systems. This is a hands‑on position for someone who takes ownership of quality from strategy through execution.

What You’ll Be Doing

• Leading ETL process and data testing across MDM, Data Warehouse, and legacy platforms
• Writing and executing complex SQL queries for results validation, data mining, and foreign key dependency analysis
• Developing and executing Test Strategy, Test Design, and Test Execution plans
• Performing Root Cause Analysis (RCA) and producing heatmaps and reporting
• Collaborating cross‑functionally with development and business teams to identify and resolve issues
• Working within both Agile and Waterfall methodologies

What You Bring

• 10+ years of hands‑on ETL testing experience- this is non‑negotiable
• 10+ years of Quality Assurance experience in enterprise environments
• 5+ years of Data Warehousing experience, including dimensional databases
• Intermediate to advanced SQL skills with a strong focus on complex queries
• Proven experience with RCA, test lifecycle management, and QA best practices
• Strong analytical skills with exceptional attention to detail
• Excellent communication and client‑facing interpersonal skills

Nice to Have

• Hands‑on experience with Kodda or SSIS packages

$000,000 – $000,000 Salary range is not shown on the candidate portal

Nov 22, 2026