QA Analyst / ETL Tester
Overview:
In this role you will validate and automate ETL tests for an Enterprise Data Warehouse supporting state Medicaid systems. You'll work in Agile sprints with QA engineers, ETL developers, and stakeholders to ensure data accuracy and reliability. You will design test strategies, execute data validation, and drive quality across full-load and incremental pipelines. Your work directly supports healthcare data delivery and program integrity, with a modern stack including Informatica PowerCenter, Teradata, Azure DevOps, and Python automation. Compensation / Benefits Fully remote
Responsibilities:
- Design, automate, and execute test cases for EDW ETL processes in a Medicaid environment
- Develop test strategies to validate functional and non-functional requirements of data pipelines
- Perform backend data validation: source-to-target, mappings, and data quality checks
- Write complex SQL queries to validate ETL outputs and data integrity
- Build automated validation scripts (Python, SQL Alchemy, Pandas) and shell scripts for monitoring
- Document test results, manage defects, and support regression testing in CI/CD pipelines
- Collaborate with ETL developers and stakeholders in Agile sprints
Key requirements:
- 5+ years of QA/testing experience in ETL/data warehouse/backend systems 5+ years with Python, Azure, and Azure Data Factory for validation and automation
- Strong SQL skills and experience with Teradata, SQL Server, Oracle, PostgreSQLExperience testing ETL, data warehouses, and data quality validation
- Knowledge of data warehousing concepts (dimensional modeling, SCD, star/snowflake schema)
- Experience with ETL tools (ADF, Informatica, Talend, SSIS) and test management tools (Azure DevOps, Jira, HP ALM)
- Experience in Agile/Scrum and stakeholder collaboration
- Bachelor's degree in Computer Science, Information Technology, Information Systems, Data Analytics, Mathematics, Statistics, or related fieldstrong analytical and problem-solving skillseffective communication and collaborationattention to detail
- Informatica PowerCenterTeradataAzure DevOps