ETL QA Test Engineer | Contract | Hybrid, Rosemont, IL Job at 2Link Partners, Chicago, IL

  • 2Link Partners
  • Chicago, IL

Job Description

ETL QA Test Engineer | Contract | Hybrid, Rosemont, IL

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.

The Opportunity

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

  • Scripting experience in Python, C#, JavaScript, or PowerShell
  • Hands-on experience with Kodda or SSIS packages

Requirements

  • Must be local to the Chicago area
  • Must be authorized to work in the US; USC, Green Card, or EAD only
  • 1099 or Corp-to-Corp engagement

Job Tags

Contract work, Local area, Remote work

Similar Jobs

GardaWorld

Response Security Supervisor Job at GardaWorld

 ...GardaWorld Security Services is Now Hiring a Response Security Officer! Ready to suit up as a Response Security Supervisor? What matters most in a role like this is your ability to adapt from one mission to the next. Tell us about how you embrace change and thrive... 

Hyundai Translead

SAP ERP Business Analyst (Sales & Logistics) Job at Hyundai Translead

 ...and technologies, we provide reliable transportation solutions designed to elevate the customer experience.Job SummaryThe SAP ERP Business Analyst - SAP Sales & Logistics role is responsible for supporting, configuring, enhancing, and optimizing SAP solutions that... 

Ampersand Therapy

Speech Language Pathology Assistant Job at Ampersand Therapy

 ...Job Description Speech Language Pathology Assistant (SLPA) Up to $42/hour | Forest City, NC | Full-Time | 2026-2027 School Year Position Details: Full time position - for 2026-2027 School Year Steady school based schedule About the Role Hi, SLPs!... 

Marriott

Resident Services Coordinator Job at Marriott

 ...meeting. Prepare Owners' Manual and schedule the welcome meeting with the Director of Residences. Maintain Owners' files to The Ritz-Carlton standards. Maintain accuracy of all legal state statutes and governing documents. Check that meeting notices and agendas are in... 

Northland

Ambulance Driver Job at Northland

 ...EMS Ambulance DriverTeam Mobile Health Care is looking for EMS Ambulance Drivers who will play a crucial role in the healthcare system by providing safe and efficient transportation for patients who require voluntary/involuntary medical assistance. They are responsible...