ETL Developer with 7+ years in Healthcare Data Validation
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
ETL Testing professional with 7 years of experience, including 5 years in IT, specializing in healthcare data validation and reconciliation. Extensive experience performing end-to-end ETL testing for claims and billing data across staging, ODS, and data warehouse layers. Strong expertise in SQL-based source-to-target validation, financial reconciliation, and data quality checks on large datasets. Proficient in validating ETL mappings, transformations, business rules, full/incremental loads, and CDC processes. Well-versed in SDLC, STLC, defect lifecycle, and testing in Agile environments. Hands-on experience with Informatica, SSIS, SQL Developer, JIRA, and UNIX for backend and ETL testing.
Kings College of Engineering
Bachelor of Information Technology
August 1, 2012 – June 30, 2016
Sagility India Pvt Ltd
Test Engineer
January 1, 2022 – February 1, 2024
Chennai, Tamil Nadu, India
Hinduja Global Solutions Limited
Test Engineer
October 1, 2016 – December 1, 2021
Chennai, Tamil Nadu, India
Claims & Billing ETL Validation
June 30, 2026 – Present
Performed end-to-end ETL testing for healthcare claims and billing data using Informatica PowerCenter. Conducted source-to-target data validation across staging, ODS, and data warehouse layers using SQL. Executed financial reconciliation for charges, payments, adjustments, and write-offs to ensure data accuracy. Validated Informatica transformations and workflows (lookups, joins, aggregators, update strategies). Tested full load, incremental load, and CDC processes for new and updated claim records. Performed data quality checks including nulls, duplicates, data types, and referential integrity.
ETL Testing for Healthcare Billing Systems
June 30, 2026 – Present
Performed end-to-end ETL testing for healthcare claims and billing data using Informatica PowerCenter. Conducted source-to-target data validation across staging, ODS, and data warehouse layers using SQL. Executed financial reconciliation for charges, payments, adjustments, and write-offs to ensure data accuracy. Validated Informatica transformations and workflows (lookups, joins, aggregators, update strategies). Tested full load, incremental load, and CDC processes for new and updated claim records. Performed data quality checks including nulls, duplicates, data types, and referential integrity.
Software Testing & Automation Certification
Unknown
June 1, 2026 – Present
Cultural Fit Analysis
The candidate's projects and experience are highly aligned with the ETL Developer role, focusing on data integration and quality. The repeated nature of project descriptions suggests a deep specialization in a specific domain (healthcare ETL testing). While this indicates strong domain expertise, it also points to a potentially narrow breadth of experience across different industries or diverse ETL challenges. The mention of basic AWS and Python skills indicates some willingness to learn new technologies, but the core experience is concentrated.
Soft Skills & Operational Fit
The candidate demonstrates a strong focus on data accuracy and consistency, which is crucial for an ETL Developer role. Their experience in defect tracking and Agile environments suggests good operational fit. However, the resume does not provide explicit details on collaboration or problem-solving approaches beyond defect identification.