Automation Test Lead - Cloud ETL, DW Automation
United States
Apply now
Job Description
Automation Test Lead - Cloud ETL, DW Automation
Philadelphia, Pennsylvania

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.
Maximum Salary (US): 
Minimum Salary (US): 
Apply now
Information at a Glance

Why HCLTech?

At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 223,000 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending June 2026 totaled $14.8 billion. 

 

Compensation and Benefits

A candidate’s pay within the range will depend on their skills, experience, education, and other factors permitted by law. This role may also be eligible for performance-based bonuses subject to company policies. In addition, this role is eligible for the following benefits subject to company policies: medical, dental, vision, pharmacy, life, accidental death & dismemberment, and disability insurance; employee assistance program; 401(k) retirement plan; 10 days of paid time off per year (some positions are eligible for need-based leave with no designated number of leave days per year); and 10 paid holidays per year.