Data Warehouse QA Tester

Overview

Remote
Depends on Experience
Contract - W2
Contract - 12 Month(s)

Skills

Acceptance Testing
Extract
Transform
Load
Amazon Web Services
Data Warehouse
Data Warehouse QA
Data Management
Data Migration
IBM Cognos Analytics
OLAP
Medicaid
JIRA
IBM InfoSphere DataStage
Regulatory Compliance
Scripting
Selenium
Software Testing
Test Plans
Testing
Documentation
Health Care
Migration
SQL

Job Details

Job Summary:
Seeking an experienced Data Warehouse QA Tester to support a Medicaid Data Warehouse Migration Project. The role involves testing and validating ETL data pipelines and Cognos reports to ensure data accuracy, completeness, and compliance within Medicaid data domains such as member, claims, encounters, and provider datasets.
Key Responsibilities:

  • Validate ETL pipelines and data migration processes.

  • Test Cognos reports for accuracy and business rule compliance.

  • Perform data reconciliation across source, staging, and target systems.

  • Develop and execute test plans, cases, and scripts.

  • Log and track defects using JIRA.

  • Support UAT and prepare test documentation and reports.

Required Skills:

  • 5 7 years of software testing experience (Medicaid or healthcare preferred).

  • Strong SQL and ETL validation skills.

  • Experience testing Cognos reports.

  • Knowledge of Medicaid data domains.

  • Familiarity with data warehouses, OLAP, and test tools (JIRA, Selenium).

  • Experience with Medicaid cloud data warehouse migrations is preferred.

  • Knowledge of IBM DataStage and AWS data management tools.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.