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.
Responsible for ensuring the accuracy, integrity, and reliability of data as it moves through ETL processes.
Leverage expertise to design and execute test strategies that validate both functional and non-functional requirements of data pipelines.
Perform backend testing to compare data in source systems to target Medicaid EDW.
Verify source-to-target data mapping and transformation logic for Medicaid datasets.
Validate data quality, standardization rules, and loading accuracy.
Write complex SQL queries to validate ETL outputs against business rules.
Conduct row counts, null checks, duplicate checks, and referential integrity validation.
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.

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.

Quality Assurance Analyst – ETL Tester

Key skills