Senior ETL QA Tester — Data Warehouse & MDM (Hybrid)

ZealHire Inc.; Illinois; Hybrid; USD 83,000 - 124,000; Full time

Job summary

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.

Qualifications

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

Responsibilities

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

Skills

ETL testing

SQL

Data Warehousing

QA processes

Root Cause Analysis

Agile & Waterfall

Communication

Tools

SSIS

Kodda

Job description

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.