Data Warehouse Quality Assurance

Job Title : Data Warehouse Quality Assurance

Duration : 12 Months

Location : Lincoln Nebraska

Data Warehouse Quality Assurance

Job Summary :

We are seeking adetail-oriented MES Testerto support theMedicaid Data Warehouse Migration Project. The successful candidate will be responsible for testing and validatingETL data pipelinesandCognos reportsto ensure data accuracy completeness and integrity across key Medicaid data domains including member claims encounters and provider datasets. This role demands hands-on experience indata validation report testing and ETL verificationwithin aMedicaid or healthcare data environment.

Key Responsibilities :

Validate ETL pipelines after data migration from legacy systems to new data warehouses or cloud platforms.

Test and verify Cognos reports for accuracy completeness formatting and compliance with defined business rules.

Develop and execute test plans test cases and scripts for both ETL and reporting validation.

Perform data reconciliation between source staging and target systems to ensure integrity and correctness.

Collaborate with data engineers and business analysts to understand reporting requirements and ETL transformations.

Identify log and track defects or discrepancies using JIRA.

Support the state team during User Acceptance Testing (UAT) for migrated data and reports.

Document testing activities results and provide summary reports and recommendations.

Ensure testing adheres to HIPAA CMS and state Medicaid compliance standards.

Required Skills and Experience :

Bachelors degree in computer science Information Systems or a related field

5-7 years of experience in software testing preferably in Medicaid or healthcare data systems.

Knowledge of Medicaid data (eligibility enrollment claims encounters providers).

Hands-on experience validating ETL processes and data migration projects.

Strong experience testing Cognos reports

Proficiency in SQL for data validation and troubleshooting.

Familiarity with data warehouses staging and OLAP environments.

Experience with test management tools (JIRA Selenium etc ).

Strong analytical documentation and problem-solving skills.

Preferred Qualifications :

Experience with Medicaid Cloud data warehouse implementations and migrations.

Exposure to ETL tools such as IBM DataStage.

Familiarity with AWS based data management solutions and applications.

Required Skills :

UATAWSSELENIUMTESTINGJIRAOLAP

Key Skills

Test Cases,SQL,Quality Assurance,Agile,TFS,Jira,Software Testing,Test Automation,Cucumber,QA / QC,SDLC,Selenium

Employment Type : Full Time

Experience : years

Vacancy : 1