Senior QA Engineer – ETL Testing (Healthcare Domain)

Senior QA Engineer – ETL Testing (Healthcare Domain)

Experience

6–8 Years

Remote

Job Summary

We are seeking an experienced QA professional with strong expertise in ETL Testing, Data Warehouse Testing, and Healthcare domain applications. The ideal candidate will have hands-on experience validating large-scale data migrations, data transformations, healthcare claims, member, provider, and clinical data systems while ensuring data quality, integrity, and compliance.

Key Responsibilities

• Design, develop, and execute ETL test strategies, test plans, and test cases.
• Validate source-to-target data mappings and business transformation rules.
• Perform data quality, completeness, accuracy, and reconciliation testing.
• Execute end-to-end testing for ETL pipelines, data warehouses, and reporting systems.
• Analyze complex SQL queries for data validation and defect investigation.
• Validate healthcare data including claims, members, providers, eligibility, encounters, and clinical datasets.
• Perform regression, integration, system, and UAT support testing.
• Work closely with Data Engineers, Business Analysts, Developers, and Product Owners.
• Identify, track, and report defects using defect management tools.
• Participate in Agile ceremonies including sprint planning, grooming, and retrospectives.
• Ensure compliance with healthcare regulations and data standards.

Required Skills

ETL & Data Testing

• Strong experience in ETL Testing and Data Warehouse Testing.
• Expertise in validating ETL workflows and transformation logic.
• Experience with source-to-target reconciliation.
• Data migration and data conversion testing experience.
• Knowledge of data quality testing methodologies.

Database Skills

• Advanced SQL skills.
• Experience with:
• Oracle
• SQL Server
• PostgreSQL
• Snowflake (preferred)
• Query optimization and data validation.

ETL Tools

Experience with one or more:

• Informatica
• Talend
• SSIS
• DataStage
• Azure Data Factory (ADF)
• AWS Glue

Test Management & Automation

• Jira
• Azure DevOps
• ALM/Quality Center
• Selenium (good to have)
• Python or SQL-based automation (preferred)

Healthcare Domain Experience

Must have experience working with healthcare data and processes such as:

• Claims Processing
• Member Enrollment
• Provider Management
• Eligibility Verification
• Clinical Data Integration
• EDI Transactions
• HIPAA Compliance
• Healthcare Data Warehousing

Knowledge of healthcare standards:

• HIPAA
• ICD-10
• CPT
• HCPCS
• HL7/FHIR (preferred)

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or related field.
• 6–8 years of QA experience with at least 4+ years focused on ETL/Data Testing.
• Experience working in Agile/Scrum environments.
• Strong analytical and problem-solving skills.

Preferred Qualifications

• Experience with cloud platforms (AWS, Azure, GCP).
• Exposure to Big Data testing.
• Knowledge of healthcare interoperability standards such as HL7 and FHIR.
• ISTQB or relevant QA certification.

Key Competencies

• ETL Testing
• Data Warehouse Testing
• SQL Validation
• Healthcare Domain Knowledge
• Data Reconciliation
• Defect Management
• Agile Methodology
• Stakeholder Communication