Senior ETL QA Analyst – Healthcare Data & Reports

Compunnel Inc.; Aliso Viejo (CA); On-site; USD 90,000 - 120,000; Full time

Job summary

The Manual QA Tester role focuses on validating ETL processes, data transformations, and reporting solutions within healthcare environments. You will design and execute manual test plans, ensuring data integrity and regulatory compliance, working with developers, data engineers, and stakeholders to verify end-to-end data flows.

Candidates should have 4–6 years of experience in manual QA testing, strong SQL skills, and familiarity with SSIS/SSRS.

Qualifications

• 4–6 years of experience in manual QA testing with focus on ETL and data transformation.
• Strong experience with healthcare regulatory standards (HIPAA) and data integrity checks.
• Proficiency in SQL for data validation and integrity checks.
• Experience with defect tracking tools such as Jira or Azure DevOps.

Responsibilities

• Analyze requirements to design manual test plans, test cases, and scenarios across data platforms.
• Validate data mapping, transformations, aggregations, and business rules across source systems to reporting layers.
• Conduct data integrity checks, reconciliations, and validations using SQL and data validation techniques.
• Test SSIS packages, ETL pipelines, and data extracts for accuracy and compliance.
• Validate SSRS reports and BI outputs against warehouse data and business expectations.
• Develop and execute test cases for ETL processes and scheduled workflows, including error handling and logging.
• Communicate test results, risks, and recommendations to stakeholders.
• Perform system, integration, regression, and UAT testing across healthcare workflows and data flows.
• Log, track, and manage defects using Jira or Azure DevOps; coordinate with developers to verify fixes.
• Execute manual testing for web apps, desktop apps, backend services, extracts, and reporting solutions.
• Ensure compliance with healthcare regulations (HIPAA) and support audits.

Skills

ETL testing

SQL data validation

Data quality

Communication

Healthcare regulatory knowledge

Tools

Jira

Azure DevOps

SSIS

SSRS

Job description

The Manual QA Tester role focuses on validating ETL processes, data transformations, and reporting solutions within healthcare environments. You will design and execute manual test plans, ensuring data integrity and regulatory compliance, working with developers, data engineers, and stakeholders to verify end-to-end data flows.

Candidates should have 4–6 years of experience in manual QA testing, strong SQL skills, and familiarity with SSIS/SSRS.