Quality Assurance Analyst / ETL Tester – Enterprise Data Warehouse

Gilder Search Group; United States; On-site; USD 70,000 - 90,000; Full time

Job summary

Gilder Search Group is looking for a Quality Assurance Analyst / ETL Tester in the United States. This role is responsible for designing and executing test strategies for ETL processes in a State Government Medicaid environment. Candidates should have strong skills in SQL and ETL testing, utilizing tools like Informatica PowerCenter. You will work to identify defects and ensure data quality through manual and automated tests, integrating automation into CI/CD pipelines within Azure DevOps. Expect collaboration with development teams and a focus on data integrity.

Qualifications

• Experience with ETL testing in a Medicaid environment.
• Strong SQL skills for complex queries and data validation.
• Ability to write and automate test cases.

Responsibilities

• Design and execute test cases for ETL processes.
• Perform data validation and quality checks.
• Collaborate with developers to resolve defects.

Skills

ETL Testing

SQL

Automation

Data Validation

Backend Testing

Informatica PowerCenter

JIRA

Azure DevOps

Tools

Teradata RDBMS

Python

SQL Alchemy

Pandas

Job description

Quality Assurance Analyst / ETL Tester - Enterprise Data Warehouse

Vergence -null, United States

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

• 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.
• 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.
• 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.