Tester III - Software Testing

Groupe Kardol; Aliso Viejo (CA); On-site; USD 70,000 - 110,000; Full time

Job summary

Axelon Services Corporation in Chicago, IL is seeking a Manual QA Tester for ETL processes and data transformations across source systems, staging areas, data warehouses, and reporting layers. The role focuses on designing comprehensive test plans, validating mappings and business rules, executing SQL-based checks, and performing UAT to ensure end-to-end healthcare workflows meet regulatory requirements.

Candidates will document results, track defects in Jira/Azure DevOps, and collaborate with

Qualifications

• Analyze business, functional, and technical requirements to design comprehensive manual test plans, test cases, and test scenarios across application and data platforms.
• Validate data mappings, transformations, aggregations, and business rules across source systems, staging layers, data warehouses, and reporting layers.
• Log, track, and manage defects using Jira or Azure DevOps, collaborating with developers and data engineers to resolve issues.

Responsibilities

• 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.
• Perform system, integration, regression, and UAT testing to validate end-to-end healthcare workflows and data flows.

Skills

SQL

Manual testing

Healthcare domain

Tools

SSIS

SSRS

Jira

Azure DevOps

Job description

Job Title: Manual QA Tester ETL Process and Data Transformation

Job location: Chicago, IL

• Experience with Microsoft Databases technical stack is strongly demonstrated
• Health care Experience is Plus
• 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, recommendations, and contributing to continuous QA process improvements.
• 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, collaborating 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.

About the Company

Axelon Services Corporation