> Markdown version of [/jobs/ext/280404-quality-assurance-analyst-etl-tester-enterprise-data-warehouse](https://www.wearedevelopers.com/jobs/ext/280404-quality-assurance-analyst-etl-tester-enterprise-data-warehouse). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Quality Assurance Analyst / ETL Tester - Enterprise Data Warehouse

- **Company:** RiverPoint
- **Location:** Snowflake, AZ, United States (Remote available)
- **Experience:** Expert
- **Salary:** $104,728.0 - $158,550.0
- **Contract:** Temporary contract
- **Skills:** JIRA, Automation of Tests, Microsoft Azure, Big Data, Bug Tracking Systems, Software Bug Management, Cloud Computing, Cloud Database, Code Coverage, Data Validation, Data Infrastructure, Data Integrity, Extract Transform Load (ETL), Data Transformation, Data Systems, Data Warehousing, Relational Databases, Database Testing, Github, Python (Programming Language), Microsoft SQL Server, SQL Azure, Scrum Methodology, Regression Testing, Azure DevOps Pipelines, Azure Data Lake, SQL Databases, SQLAlchemy, Teradata SQL, Test Management, Strategies of Testing, Scripting, Freeform SQL, Enterprise Software Applications, Cloud Platform System, Azure Data Factory, Informatica Powercenter, Delivery Pipeline, Snowflake, Hp Alm, Backend, Pandas, Core Data, Health Level Seven International, Software Version Control, Data Pipelines
- **Published:** May 25, 2026
- **Apply:** https://www.careerjet.com/jobad/us7a49cc315126306fb357593059d2f03f

## About the Role

* 5+ years of experience in QA/testing with a focus on ETL, EDW, or backend data systems
 * 5+ years of hands-on Python experience for data validation, automation, and scripting
 * 5+ years of Azure experience, including data platform and cloud-based testing
 * 5+ years of Azure Data Factory (ADF) experience, including pipeline validation and orchestration testing
 * 5+ years of experience working in cloud environments, preferably Azure
 * Strong SQL expertise with hands-on experience in relational databases (Teradata, SQL Server, or equivalent)
 * Experience testing complex data transformations, data models (star/snowflake), and SCD (Type 1/Type 2)
 * Experience with test management and defect tracking tools (Azure DevOps, JIRA, HP ALM)
 * Strong analytical and troubleshooting skills with attention to detail
 * Experience working in Agile/Scrum environments, * Healthcare or Medicaid domain experience (claims, encounters, eligibility, provider data)
 * Knowledge of HIPAA and healthcare data standards (837/835, ICD, CPT, HL7)
 * Experience with Medicaid Enterprise Systems (MES) or State agencies (e.g., Illinois HFS)
 * Experience with Informatica or legacy ETL tools (nice-to-have, not required)
 * Familiarity with GitHub or version control for automation

## Description

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., Requirement Analysis & Test Strategy

 * Review change requests and participate in requirement analysis for EDW data pipelines and transformations
 * Collaborate with data engineers, analysts, and business stakeholders to ensure test coverage aligns with business requirements
 * Design comprehensive test strategies, test plans, and test cases for ETL workflows

ETL & Data Validation

 * Perform end-to-end validation of data pipelines from source systems to EDW targets
 * Validate source-to-target mappings, transformation logic, and business rules
 * Execute data quality checks including row counts, null validation, duplicate detection, and referential integrity

SQL & Backend Testing

 * Develop complex SQL queries (joins, aggregations, transformations) to validate ETL processes
 * Perform backend and database testing across large datasets and multiple systems

Automation & Scripting

 * Develop and maintain automated data validation frameworks using Python (Pandas, SQLAlchemy)
 * Build reusable scripts for regression testing, reconciliation, and data comparisons
 * Integrate automated testing into Azure DevOps CI/CD pipelines

Cloud & Data Platform Testing

 * Validate data pipelines and workflows within Azure Data Factory (ADF)
 * Test integrations across Azure services including Azure Data Lake, Azure SQL, and related components
 * Support validation of cloud-based data processing and orchestration workflows

Defect Management & Reporting

 * Identify, document, and track defects using tools such as Azure DevOps, JIRA, or HP ALM
 * Partner with development teams to troubleshoot issues and ensure resolution
 * Provide clear, audit-ready documentation of test results and findings


## Related Videos

- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)
- [Innovating Developer Tools with AI: Insights from GitHub Next](https://www.wearedevelopers.com/videos/1268-innovating-developer-tools-with-ai-insights-from-github-next)
- [Improving quality with Agentic AI with Rovo Dev and Xray](https://www.wearedevelopers.com/videos/2005-improving-quality-with-agentic-ai-with-rovo-dev-and-xray)
- [AIQSpecFlow: Improves and automates your agile process of specification and creation of testcases.](https://www.wearedevelopers.com/videos/100084-aiqspecflow-improves-and-automates-your-agile-process-of-specification-and-creation-of-testcases)
- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [Bringing AI Model Testing and Prompt Management to Your Codebase with GitHub Models](https://www.wearedevelopers.com/videos/1536-bringing-ai-model-testing-and-prompt-management-to-your-codebase-with-github-models)

## Related Articles

- [The 8 Best Code Testing Tools](https://www.wearedevelopers.com/magazine/402-the-8-best-code-testing-tools)
- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [Integration And E2E Testing: Are They Complementary or Interchangeable?](https://www.wearedevelopers.com/magazine/86-integration-and-e2e-testing-are-they-complementary-or-interchangeable)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)