> Markdown version of [/jobs/ext/4602198-automation-test-lead-cloud-etl-dw-automation](https://www.wearedevelopers.com/jobs/ext/4602198-automation-test-lead-cloud-etl-dw-automation). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Automation Test Lead - Cloud ETL, DW Automation - **Company:** HCL America Inc. - **Location:** United States - **Experience:** Expert - **Salary:** $78,000 - $131,000 - **Contract:** Permanent contract - **Skills:** 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 - **Published:** November 6, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=6049a042416cedad ## About the Role * 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. ## 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.