Description

Key Responsibilities

Perform data testing and validation across QNXT and Snowflake platforms.

Validate data accuracy, completeness, consistency, and integrity across source and target systems.

Write and execute complex SQL queries to validate data, identify discrepancies, and perform reconciliation.

Test ETL/ELT pipelines, data transformations, and data migration processes.

Perform source-to-target data validation and backend database testing.

Validate healthcare payer data related to:

Claims processing and adjudication

Membership and enrollment

Provider management

Eligibility and benefits

Identify, document, track, and report data defects and inconsistencies.

Collaborate with developers, business analysts, and QA teams to resolve data-related issues.

Prepare test scenarios, test cases, test data, and test execution reports.

Perform regression testing and support defect resolution and root cause analysis

Requirements

Mandatory Technical Skills

Strong experience in Data Testing / Data QA.

Hands-on experience with Snowflake data validation and testing.

Strong SQL skills, including complex queries, joins, subqueries, aggregations, and data reconciliation.

Experience working with QNXT (Healthcare Payer Administration System).

Strong understanding of US Healthcare Payer business processes.

Experience validating source-to-target data mappings and ETL/ELT transformations.

Knowledge of test case design, defect management, and QA methodologies.

Mandatory Domain Experience

Candidates must have hands-on experience in US Healthcare Payer processes, particularly:

Claims: Claims processing, adjudication, payment validation, and claim data reconciliation.

Membership: Member enrollment, demographics, and membership data validation.

Provider Management: Provider records, provider data accuracy, and provider network information.

Eligibility: Member eligibility, coverage, benefits, and effective-date validation.

Good-to-Have Skills

Experience with healthcare data warehouses and large-scale datasets.

Knowledge of ETL testing tools and data integration processes.

Experience with Agile/Scrum methodologies and defect tracking tools such as JIRA.

Familiarity with healthcare EDI transactions such as 837, 835, and 834

Key Skills

Education

Bachelor's degree