Automation Test Lead - Cloud ETL, DW Automation

Job Summary

We are seeking a detail-oriented and analytical ETL Tester to validate and ensure the quality, accuracy, integrity, and performance of data flowing through ETL processes and Data Warehouse environments. The ideal candidate will possess strong knowledge of ETL testing methodologies, SQL, data validation techniques, and experience working with large-scale enterprise data platforms.

The candidate will collaborate with ETL developers, business analysts, data architects, and stakeholders to ensure reliable and accurate data delivery across reporting and analytical systems.

Key Responsibilities

• Review requirements, source-to-target mappings, conversion rules, and acceptance criteria; create and execute migration test cases.
• Reconcile source and target records using SQL, record counts, field comparisons, and financial control totals. Investigate missing, duplicate, or mismatched data.
• Validate patient and guarantor accounts, encounters, payer and plan data, diagnoses, charges, claims, remittances, payments, adjustments, refunds, and balances.
• Test target-system RCM workflows and conversion exceptions, including claim status, payment posting, denials, reversals, unapplied cash, and open or historical accounts.
• Document defects and evidence, retest fixes, maintain requirement-to-test traceability, and report financial or data-quality risks.
• Support migration rehearsals, cutover and post-load checks; follow applicable privacy, security, and quality procedures.

Skill Requirements

• Experience in QA, data migration, ETL Testing, Reporting, etc.
• Working SQL skills and experience reconciling data across systems.
• Ability to write test cases, document evidence, and manage defects.
• Strong attention to detail and responsible handling of confidential healthcare data.

Other Requirements

• Experience with healthcare RCM, patient accounting, billing, claims, payment posting, or accounts receivable.
• Familiarity with remittances, denials, adjustments, aging, and healthcare billing codes.
• Experience with migration rehearsals or testing in a regulated or quality-managed environment.