Automation Test Lead - Cloud ETL, DW Automation

HCL America Inc.
United States
11 days ago
Apply on www.indeed.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Compensation
$78,000 - $131,000
Working hours
Regular working hours
Job source

Tech stack

Automation of Tests Cloud Computing Cloud Testing Data Validation Extract Transform Load (ETL) Data Migration Data Warehousing Standard Sql SQL Databases Strategies of Testing Enterprise Data Management Data Delivery

Job description

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., * 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.

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.

Must Have Skill

Cloud Testing,Extract Transform Load (ETL) Automation, * 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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.indeed.com
Prepare application

Good distractions

Loading talks and stories from around this role…