ETL Developer QA Tester (35014)

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.

Required Qualifications:

• 5+ years of experience in software testing and quality assurance.
• 5+ years of experience testing backend, database, EDW, or ETL systems.
• 4+ years of strong SQL experience and hands-on work with at least one RDBMS (e.g., Teradata, SQL Server).
• 4+ years of experience in UI, smoke, end-to-end, and integration testing.
• 4+ years of strong troubleshooting and analytical skills, with the ability to debug and resolve complex technical issues.
• 4+ years of experience in test design and working with at least one test management tool.
• Bachelor’s degree or higher in Information Technology, Computer Science, Mathematics, Statistics, Analytics, Business Technology, or related field.

Key Responsibilities

Requirement Analysis

• Review Change Requests (CRs) and participate in requirement analysis for new EDW extracts and transformations.
• Participate in data modeling and requirement gathering sessions to ensure testing aligns with business needs

• Data Validation –

• Perform backend testing to compare data in source systems to target Medicaid Enterprise Data Warehouses (EDW).
• Verify source-to-target data mapping and transformation logic for Medicaid datasets.
• Validate data quality, standardization rules, and loading accuracy.

• SQL & Scripting

• Write complex SQL queries (including multi-table JOINs, aggregations) to validate ETL outputs against business rules.
• Conduct row counts, null checks, duplicate checks, referential integrity validation.

• Test Strategy & Execution

• Design test plans, test cases, and test scenarios for ETL processes.
• Document test results and provide detailed feedback to stakeholders, highlighting areas for improvement
• Execute manual and automated tests for both full-load and incremental-load cycles.

• Defect Management

• Identify, document, and track discrepancies using tools like JIRA, HP ALM, or Azure DevOps Test Plans.
• Collaborate with ETL developers to resolve defects and perform regression testing.

• Automation

• Develop automated database validation scripts using Python, SQL Alchemy, and Pandas.
• Create shell scripts for ETL monitoring and log analysis.
• Integrate automation into CI/CD pipelines in Azure DevOps.

• Required Skills & Qualifications

• Technical Skills: Deep proficiency in SQL and relational database systems (Oracle, SQL Server, PostgreSQL). • Healthcare Domain Knowledge: Direct experience with Medicaid systems, HIPAA, claims (837/835), eligibility, provider data, or clinical standards like ICD-9/10, CPT, and HL7.
• ETL Knowledge: Strong understanding of EDW and ETL concepts, including Star/Snowflake schema, Slowly Changing Dimensions (SCD1/SCD2).
• Tools: Experience with ETL tools (such as Informatica, Talend, SSIS, ADF) and test management tools (Such as Azure DevOps, JIRA, HP ALM).
• Analytical Skills: Ability to compare datasets, identify root causes of discrepancies, and validate against business rules.
• Soft Skills: Excellent communication and collaboration skills; ability to work in Agile/Scrum sprint cycles.
• Work Experience: Minimum 5 years of QA/testing experience in data warehouse, ETL, or healthcare analytics environments
• Education: Bachelor’s degree in computer science, Information Systems, Data Analytics, or related field

• Preferred Qualifications

• Knowledge of Medicaid reporting, encounter data, and data mart validation.
• Experience with Medicaid Enterprise Systems (MES)
• Familiarity with Illinois HFS or other state Medicaid agencies.
• Python Test Automation and GitHub Code Management tool.

• Informatica Tool Knowledge.