Tester III - Software Testing

The Manual QA Tester will be responsible for validating ETL processes, data transformations, reporting outputs, and end-to-end healthcare data workflows. The role requires deep understanding of data quality, SQL-based validation, Microsoft BI tools, and healthcare compliance standards. The tester will work independently while guiding junior testers and supporting test leads.

Key Responsibilities:

• Analyze business, functional, and technical requirements to identify testable scenarios and clarify ambiguities in user stories and specifications.
• Design comprehensive manual test plans, test scenarios, and test cases for applications and data platforms.
• Validate data mapping, transformations, aggregations, and business rules across source systems, staging layers, data warehouses, and reporting layers.
• Perform data integrity checks, reconciliations, and consistency validations using SQL and other data validation techniques.
• Test and validate ETL pipelines, SSIS packages, batch jobs, scheduled workflows, and data extracts for accuracy, completeness, and compliance.
• Validate SSRS reports, BI dashboards, and downstream deliverables to ensure alignment with warehouse data and business expectations.
• Execute manual testing for web applications, Windows-based desktop applications, backend/data services, ETL processes, and reporting solutions.
• Perform smoke, system, integration, regression, and user acceptance testing (UAT) to validate end-to-end healthcare workflows and data flows.
• Identify, log, track, and manage defects using tools such as Jira or Azure DevOps, and collaborate with developers and data engineers to resolve issues and verify fixes.
• Document test execution results, defect reports, test evidence, and sign-off artifacts to support quality assurance, audits, and compliance.
• Ensure all testing activities comply with healthcare regulatory standards such as HIPAA and support audit and compliance requirements.
• Communicate test results, risks, quality metrics, and recommendations clearly to cross-functional stakeholders.
• Guide and mentor junior testers, assist test leads with reporting and estimation, and contribute to continuous QA process improvements.

• 46 years of experience in manual testing, with strong focus on ETL, data transformation, and data validation.
• Proven experience in healthcare domain testing, including regulatory and compliance requirements (HIPAA).
• Strong hands-on experience with Microsoft database technology stack (SQL Server, SSIS, SSRS).
• Advanced SQL skills for data validation, reconciliation, and integrity checks.
• Experience testing data warehouses, staging layers, and reporting systems.
• Hands-on experience with defect tracking tools such as Jira or Azure DevOps.
• Strong understanding of testing methodologies, testing life cycle, and QA best practices.
• Ability to design efficient test cases, create test data, and execute tests independently.
• Strong analytical, problem-solving, and communication skills.
• Experience working in Agile environments and collaborating with cross-functional teams.

• Bachelors degree in Computer Science, Information Technology, Engineering, or a related field.
• 46 years of relevant experience in manual QA testing with ETL and data-focused applications.
• Healthcare domain experience is mandatory.
• Experience with Microsoft BI and database tools is required.
• Relevant testing or healthcare IT certifications are a plus.