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.