Hybrid ETL QA Test Engineer - Chicago Data Warehouse Expert

2Link Partners; Chicago (IL); Hybrid; USD 96,000 - 165,000; Full time

Job summary

2Link Partners in the Chicago area is seeking a seasoned ETL QA Test Engineer on a contract basis to ensure data integrity across MDM and Data Warehouse ecosystems. The role is hybrid, combining on-site Rosemont presence with remote work flexibility and engagement with cross-functional teams.

You will own testing strategy and execution, write complex SQL queries for validation, and perform RCA with reporting. Local candidates authorized to work in the US are required.

Qualifications

• 10+ years of hands-on ETL testing experience in enterprise environments.
• 10+ years of Quality Assurance experience in enterprise environments.
• 5+ years of Data Warehousing experience with dimensional databases.
• Intermediate to advanced SQL skills with complex queries.

Responsibilities

• Lead ETL testing across MDM, Data Warehouse, and legacy platforms.
• Write and execute complex SQL queries for validation and data analysis.
• 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

Quality Assurance

Data Warehousing

SQL

Root Cause Analysis

Communication

Agile/Waterfall

Tools

SSIS

Kodda

Job description

2Link Partners in the Chicago area is seeking a seasoned ETL QA Test Engineer on a contract basis to ensure data integrity across MDM and Data Warehouse ecosystems. The role is hybrid, combining on-site Rosemont presence with remote work flexibility and engagement with cross-functional teams.

You will own testing strategy and execution, write complex SQL queries for validation, and perform RCA with reporting. Local candidates authorized to work in the US are required.