Quality Assurance Analyst ETL Tester

Quality Assurance Analyst / ETL Tester Enterprise Data Warehouse

Location: Remote

Position Summary:

• The ETL Tester will be responsible for designing automating and executing test cases for Enterpris Data Warehouse (EDW) ETL processes in a State Government Medicaid 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.

Required Qualifications:

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.

Bachelors degree or higher in Information Technology Computer Science Mathematics Statistics Analytics Business Technology or related field.

Key Responsibilities

Requirement Analysis

Review Change Requests (CRs) and participate in requirement analysis for new EDW extracts and transformations.

Participate in data modeling and requirement gathering sessions to ensure testing aligns with business needs

Data Validation

Perform backend testing to compare data in source systems to target Medicaid Enterprise Data Warehouses (EDW).

Verify source-to-target data mapping and transformation logic for Medicaid datasets.

Validate data quality standardization rules and loading accuracy.

SQL & Scripting

Write complex SQL queries (including multi-table JOINs aggregations) to validate ETL outputs against business rules.

Conduct row counts null checks duplicate checks referential integrity validation.

Test Strategy & Execution

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.

Defect Management

Identify document and track discrepancies using tools like JIRA HP ALM or Azure DevOps Test Plans.

Collaborate with ETL developers to resolve defects and perform regression testing.

Automation

Develop automated database validation scripts using Python SQL Alchemy and Pandas.

Create shell scripts for ETL monitoring and log analysis.

Integrate automation into CI/CD pipelines in Azure DevOps.

Required Skills & Qualifications

Technical Skills: Deep proficiency in SQL and relational database systems (Oracle SQL Server PostgreSQL).

Healthcare Domain Knowledge: Direct experience with Medicaid systems HIPAA claims (837/835) eligibility provider data or clinical standards like ICD-9/10 CPT and HL7.

ETL Knowledge: Strong understanding of EDW and ETL concepts including Star/Snowflake schema Slowly Changing Dimensions (SCD1/SCD2).

Tools: Experience with ETL tools (such as Informatica Talend SSIS ADF) and test management tools (Such as Azure DevOps JIRA HP ALM).

Analytical Skills: Ability to compare datasets identify root causes of discrepancies and validate against business rules.

Soft Skills: Excellent communication and collaboration skills; ability to work in Agile/Scrum sprint cycles.

Work Experience: Minimum 5 years of QA/testing experience in data warehouse ETL or healthcare analytics environments

Education: Bachelors degree in computer science Information Systems Data Analytics or related field

Preferred Qualifications

Knowledge of Medicaid reporting encounter data and data mart validation.

Experience with Medicaid Enterprise Systems (MES)

Familiarity with Illinois HFS or other state Medicaid agencies.

Python Test Automation and GitHub Code Management tool

Informatica Tool Knowledge.