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

Let's Work

Marine Welder / Pipe Fitter (ABS Preferred) Job at Let's Work

 ...Marine Welders and Pipe Fitters perform structural and pipe welding on vessels, barges, and marine structures. required to follow ABS, OSHA, USCG and company policies. Responsibilities: SMAW, FCAW, GMAW welding on carbon steel, aluminum, stainless Fit and... 

Sunbelt Staffing

Travel Echo Technician - $2,898 per week Job at Sunbelt Staffing

Sunbelt Staffing is seeking a travel Echo Technician for a travel job in Glenview, Illinois.Job Description & RequirementsSpecialty: Echo TechnicianDiscipline: Allied Health ProfessionalDuration: 13 weeks40 hours per weekShift: 8 hours, daysEmployment Type... 

Cambridge Investment Research (USA)

Data Engineering Intern Job at Cambridge Investment Research (USA)

## Data Engineering InternApply: On-Site: Phoenix, AZ: Fairfield, IA: Full time: Posted 2 Days Ago: R-2025-221# **Job Summary**The Data Engineering Intern will support the Business Intelligence and Insights team and collaborate with Data Architecture and Engineering team... 

TRS Healthcare

Travel Nurse RN - PICC - $2,579 per week Job at TRS Healthcare

 ...TRS Healthcare is seeking a travel nurse RN PICC for a travel nursing job in Scarborough, Maine. Job Description & Requirements ~ Specialty: PICC ~ Discipline: RN ~ Start Date: ASAP ~ Duration: 26 weeks ~40 hours per week ~ Shift: 8 hours... 

bohler-

Landscape Designer Job at bohler-

 ...outdoor spaces that connect people to placesBring your creativity and technical skills to real land development projects, shaping landscapes that enhance communities while growing through professional development and mentorship from experienced designers and engineers....