The ETL Tester designs and executes test strategies for data warehouse ETL processes, validating data accuracy and integrity while collaborating within agile teams.
Position Summary: The ETL Tester will be responsible for designing, automating, and executing test cases for Enterprise
Data Warehouse (EDW) ETL processes in a State Government Medicaid environment. In this role, you will be responsible for ensuring the accuracy, integrity, and reliability of data as it moves through our ETL processes. You will leverage your expertise to design and execute test strategies that validate both functional and non-functional requirements of our data pipelines.
The tester will leverage ETL tools, primarily Informatica PowerCenter for extraction, transformation, and loading, and Teradata RDBMS for core data store validation — within Azure DevOps and agile sprint cycles to ensure data quality, identify defects, and automate repeatable testing processes.
Requirement Analysis & Test Strategy
- Review change requests and participate in requirement analysis for EDW data pipelines and transformations
- Collaborate with data engineers, analysts, and business stakeholders to ensure test coverage aligns with business requirements
- Design comprehensive test strategies, test plans, and test cases for ETL workflows
ETL & Data Validation
- Perform end-to-end validation of data pipelines from source systems to EDW targets • Validate source-to-target mappings, transformation logic, and business rules
- Execute data quality checks including row counts, null validation, duplicate detection, and referential integrity SQL & Backend Testing
- Develop complex SQL queries (joins, aggregations, transformations) to validate ETL processes
- Perform backend and database testing across large datasets and multiple systems
Automation & Scripting
- Develop and maintain automated data validation frameworks using Python (Pandas, SQLAlchemy)
- Build reusable scripts for regression testing, reconciliation, and data comparisons
- Integrate automated testing into Azure DevOps CI/CD pipelines
Cloud & Data Platform Testing
- Validate data pipelines and workflows within Azure Data Factory (ADF)
- Test integrations across Azure services including Azure Data Lake, Azure SQL, and related components
- Support validation of cloud-based data processing and orchestration workflows
Defect Management & Reporting
- Identify, document, and track defects using tools such as Azure DevOps, JIRA, or HP ALM
- Partner with development teams to troubleshoot issues and ensure resolution
- Provide clear, audit-ready documentation of test results and findings
Required Qualifications:
- 5+ years of experience in QA/testing with a focus on ETL, EDW, or backend data systems
- 5+ years of hands-on Python experience for data validation, automation, and scripting
- 5+ years of Azure experience, including data platform and cloud-based testing
- 5+ years of Azure Data Factory (ADF) experience, including pipeline validation and orchestration testing
- 5+ years of experience working in cloud environments, preferably Azure
- Strong SQL expertise with hands-on experience in relational databases (Teradata, SQL Server, or equivalent)
- Experience testing complex data transformations, data models (star/snowflake), and SCD (Type 1/Type 2)
- Experience with test management and defect tracking tools (Azure DevOps, JIRA, HP ALM)
- Strong analytical and troubleshooting skills with attention to detail
- Experience working in Agile/Scrum environments
Preferred Qualifications
- Healthcare or Medicaid domain experience (claims, encounters, eligibility, provider data)
- Knowledge of HIPAA and healthcare data standards (837/835, ICD, CPT, HL7)
- Experience with Medicaid Enterprise Systems (MES) or State agencies (e.g., Illinois HFS)
- Experience with Informatica or legacy ETL tools (nice-to-have, not required)
- Familiarity with GitHub or version control for automation
Similar Jobs
Information Technology • Professional Services • Consulting • Big Data Analytics
Validate and test ETL pipelines and EDW extracts for a state Medicaid environment. Review requirements, design and execute test cases (manual and automated), write complex SQL, develop Python-based validation scripts, document defects in JIRA/ALM/Azure DevOps, integrate automation into CI/CD, and collaborate with developers and stakeholders to ensure data quality and compliance with healthcare standards.
Top Skills:
Azure DevopsAzure Devops Test PlansCi/CdGitHp AlmInformatica PowercenterJIRAOraclePandasPythonShell ScriptingSQLSQL ServerSqlalchemyTeradata
Insurance • Logistics • Software • Transportation • Business Intelligence
The Senior Product Manager will oversee the strategy and development of telematics data products, manage cross-functional teams, and ensure product viability and market alignment through customer insights and technical fluency.
Top Skills:
Api ArchitectureData Pipeline DesignMachine LearningTelematics
.png){kind=logo}
AdTech • eCommerce • Information Technology • Software • Travel • Generative AI
Write, audit, and maintain partner-facing help content across self-service platforms; own content strategy, taxonomies, and structured approaches to improve findability and reuse; use data and audits to prioritize work and measure impact; collaborate with Product, Marketing, and Operations to translate changes into content; champion voice, accessibility, and content standards while driving strategic improvements at scale.
Top Skills:
AemSalesforce KnowledgeSharepointZendesk
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
