Data Warehouse QA Tester - REMOTE

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:

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