Automation Test Lead - Cloud ETL, DW Automation
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Tech stack
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.
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦