What You'll DoYou'll own the quality of data as it moves through ETL pipelines in a state Medicaid environment - from reviewing requirements all the way through defect resolution, regression testing, and automation.
- 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 stays aligned with business needs.
- 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 across full-load and incremental-load cycles.
- Write complex SQL queries - multi-table JOINs, aggregations, row counts, null checks, duplicate checks, and referential integrity validation - to validate ETL outputs against business rules.
- Design test plans, test cases, and test scenarios for ETL processes; execute both manual and automated tests.
- Identify, document, and track discrepancies using JIRA, HP ALM, or Azure DevOps Test Plans; collaborate with ETL developers to resolve defects and perform regression testing.
- Develop automated database validation scripts using Python, SQLAlchemy, and Pandas; create shell scripts for ETL monitoring and log analysis.
- Integrate test automation into CI/CD pipelines in Azure DevOps.
- Document test results and provide detailed, actionable feedback to stakeholders.
Requirements
- 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 (Teradata, SQL Server, Oracle, or similar)
- 4+ years of experience in UI, smoke, end-to-end, and integration testing
- 4+ years of experience in test design and working with at least one test management tool (Azure DevOps, JIRA, HP ALM)
- Strong understanding of EDW and ETL concepts, including Star/Snowflake schema and Slowly Changing Dimensions (SCD1/SCD2)
- Direct experience in a Medicaid, healthcare, or government data environment, including familiarity with HIPAA and healthcare data standards (837/835 claims, ICD-9/10, CPT, HL7)
- Bachelor's degree in Computer Science, Information Technology, Data Analytics, Mathematics, or a related field
Preferred Qualifications- Hands-on experience with Informatica PowerCenter
- Knowledge of Medicaid reporting, encounter data, and data mart validation
- Familiarity with Medicaid Enterprise Systems (MES) or a state Medicaid agency (e.g., Illinois HFS)
- Python test automation and GitHub for code management
- Experience integrating automated tests into CI/CD pipelines
