Tester III - Software Testing

Compunnel Inc.; Aliso Viejo (CA); Presencial; USD 85.000 - 120.000; Jornada completa

Descripción de la vacante

Compunnel Inc. is seeking a Manual QA Tester to validate ETL processes, data transformations, and reporting solutions within healthcare environments.

You will design and execute comprehensive manual test plans, ensuring data integrity and compliance with healthcare regulations. Responsibilities include testing SSIS pipelines, SSRS reports, and data extracts, while collaborating with developers and data engineers to resolve issues and support audits.

Formación

• 4–6 years of manual QA testing focusing on ETL and data transformation.
• Strong SQL experience for data validation and integrity checks.
• Hands-on testing of SSIS packages, ETL pipelines, and SSRS reports.
• Familiar with Jira or Azure DevOps for defect tracking and collaboration.
• Knowledge of healthcare regulatory standards (e.g., HIPAA) and audit readiness.

Responsabilidades

• Analyze requirements to design comprehensive manual test plans and test scenarios across data platforms.
• Validate data mapping, transformations, and business rules across source systems to reporting layers.
• Perform data integrity checks and reconciliations using SQL and data validation techniques.
• Test ETL pipelines, SSIS packages, and data extracts for accuracy and compliance.
• Validate SSRS reports and BI outputs against warehouse data and business expectations.

Conocimientos

Manual QA testing

ETL testing

SQL data validation

Healthcare knowledge (HIPAA)

Communication

Herramientas

SSIS

SSRS

Jira/Azure DevOps

Descripción del empleo

The Manual QA Tester is responsible for validating ETL processes, data transformations, and reporting solutions within healthcare environments. This role involves designing and executing comprehensive manual test plans, ensuring data integrity, and verifying compliance with healthcare regulatory standards. The tester will work closely with developers, data engineers, and stakeholders to ensure accuracy, completeness, and quality across data platforms and workflows.

Key Responsibilities:

• Analyze business, functional, and technical requirements to design comprehensive manual test plans, test cases, and test scenarios across application and data platforms.
• Validate data mapping, transformations, aggregations, and business rules across source systems, staging layers, data warehouses, and reporting layers.
• Conduct data integrity checks, reconciliations, and consistency validations using SQL and other data validation techniques.
• Test and validate SSIS packages, ETL pipelines, and data extracts to ensure accuracy, completeness, and compliance with requirements.
• Validate SSRS reports, BI outputs, and downstream deliverables, ensuring alignment with warehouse data and business expectations.
• Develop and execute test cases for ETL processes, data transformations, batch jobs, and scheduled workflows, including error handling and logging.
• Communicate effectively with cross-functional stakeholders, providing clear test results, risk assessments, and recommendations.
• Perform system, integration, regression, and user acceptance testing (UAT) to validate end-to-end healthcare workflows and data flows.
• Log, track, and manage defects using tools such as Jira or Azure DevOps; collaborate closely with developers and data engineers to resolve issues and verify fixes.
• Execute manual testing for web applications, Windows-based desktop applications, backend/data services, extracts, and reporting solutions.
• Ensure all testing activities comply with healthcare regulatory standards (e.g., HIPAA) and support audit and compliance requirements.
• Maintain thorough test documentation, including test plans, test evidence, defect reports, and sign-off artifacts to support quality assurance and audits.

Required Qualifications:

• 4 to 6 years of experience in manual QA testing with a focus on ETL processes and data transformation.
• Strong experience with Microsoft Databases technical stack.
• Proficiency in SQL for data validation and integrity checks.
• Hands-on experience testing SSIS packages, ETL pipelines, and SSRS reports.
• Familiarity with defect tracking tools such as Jira or Azure DevOps.
• Strong understanding of healthcare workflows and regulatory standards (e.g., HIPAA).
• Excellent communication skills and ability to work independently and collaboratively.

Preferred Qualifications:

• Experience in BI testing and validating complex reporting solutions.
• Exposure to automation tools for ETL testing (optional).
• Knowledge of healthcare data models and compliance frameworks.