QA Analyst / ETL Tester
Core
Design, automate, and execute test cases for Enterprise Data Warehouse (EDW) ETL processes in a state government Medicaid environment to ensure data accuracy, integrity, and reliability.
Role type
Senior QA Analyst / ETL Tester
Builds
Data pipelines, ETL extracts, and transformations for Medicaid EDW
Domain
Healthcare data / Government / Data Warehousing
Required skills
Python, SQL, Azure Data Factory, Informatica, Teradata, JIRA, HP ALM, Azure DevOps, CI/CD, dimensional modeling, SCD, data quality validation, source-to-target reconciliation
Preferred skills
Healthcare domain knowledge (Medicaid, claims, encounters), HIPAA standards, HL7, Informatica PowerCenter, Snowflake, Pandas, shell scripting
Technologies
Azure, Python, SQL, Informatica, Teradata, Oracle, PostgreSQL, Snowflake, SSIS, Talend, JIRA, HP ALM, Azure DevOps, Git, GitHub, Pandas
Responsibilities
Design and execute test strategies for ETL processes; write complex SQL queries to verify ETL outputs; develop automated database validation scripts; integrate test automation into CI/CD pipelines; document defects and track discrepancies; perform source-to-target data reconciliation; contribute to data modeling sessions.
Seniority
Senior, hands-on IC