Job Description
Job Summary
We are seeking an experienced ETL Tester to ensure the quality, accuracy, and reliability of data across enterprise data platforms. The ideal candidate will have strong hands on experience in ETL testing, and database testing with a proven background in healthcare or medical claims data environments. This role involves close collaboration with data engineers, developers, business analysts, and QA teams to validate data pipelines, transformations, and downstream reporting systems across the full data lifecycle.
Key Responsibilities
ETL & Data Testing
Review data requirements, source to target mappings, and design documents to create test scenarios.
Validate data extraction, transformation, and loading (ETL) processes for accuracy, completeness, and consistency.
Perform data reconciliation between source systems, staging layers, and target data warehouses/ marts.
Analyze data anomalies, transformation logic issues, and load failures, and report defects with clear root cause analysis.
Validate healthcare data for business rules, data integrity, and regulatory compliance.
Design, develop, and execute automated ETL test scripts for data validation and regression testing.
Execute manual ETL and data tests for complex business logic and exception scenarios.
Support testing using SQL to validate joins, aggregations, calculations, and historical data loads.
Collaboration & Quality Assurance
Work closely with cross functional teams to ensure end to end data quality.
Participate in Agile ceremonies including sprint planning, backlog grooming, and defect triage.
Document test cases, test results, and defect metrics using test management tools.
Assist in troubleshooting production data issues and support root cause analysis.
Required Qualifications
Education & Experience
Bachelors degree or equivalent professional experience.
8+ years of QA/ Data Testing experience.
3+ years of ETL and Data Testing experience.
Overall 10+ years of professional IT experience.
Technical Skills
Strong experience in ETL testing and database testing using SQL.
Hands on experience with test automation tools (e.g., Selenium or equivalent automation frameworks).
Experience validating large scale datasets in data warehouses or analytical platforms.
Exposure to Azure or cloud based data environments.
Familiarity with test management tools and defect tracking systems.
Domain Experience
Healthcare Insurance industry experience.
Medical claims data background is required.
Key Competencies
Strong analytical and problem solving skills.
Excellent communication and documentation abilities.
High attention to detail with a data first mindset.
Ability to work independently in complex data environments.
Proven ability to collaborate effectively across technical and business teams.
Preferred Qualifications
Experience testing data pipelines supporting reporting, analytics, or regulatory submissions.
Knowledge of Agile/ Scrum methodologies.
Understanding of data governance, data quality frameworks, and audit controls.
