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. In this role, you will be responsible for ensuring the accuracy, integrity, and reliability of data as it moves through our ETL processes. You will leverage your expertise to design and execute test strategies that validate both functional and non-functional requirements of our data pipelines.

The tester will leverage ETL tools, primarily Informatica PowerCenter for extraction, transformation, and loading, and Teradata RDBMS for core data store validation — within Azure DevOps and agile sprint cycles to ensure data quality, identify defects, and automate repeatable testing processes.

Key Responsibilities

Requirement Analysis & Test Strategy

• Review change requests and participate in requirement analysis for EDW data pipelines and transformations
...