Employee Name: Vaishnavi Patil
Role: ETL Tester
Company: ABC Technologies (Client: MTS Health Insurance)
Skills Used: SQL, Informatica IICS, Manual Testing, Jira, Agile
The MTS Health Insurance project had 20 modules and 20+ sub-modules dealing with sensitive policy and claim data. Frequent issues arose in data accuracy and delays in data validation during ETL workflows. It was difficult to detect mismatched records early in the cycle, causing delays in report generation and regulatory compliance.
To improve the accuracy of data verification and reduce the manual effort in validating ETL job outputs.
SQL Automation: Wrote reusable SQL queries to validate policyholder details, claim dates, and premium data across staging and final tables.
Defect Tracking: Used Jira to log critical defects related to data mismatches, duplicate records, and null entries.
Test Case Optimization: Created over 200 detailed test cases covering E2E flows — from claim submission to settlement.
Collaboration: Worked closely with developers to analyze root causes of data integrity failures and retested post-fixes.
Agile Process: Attended daily stand-ups, participated in sprint planning and retrospectives for continuous improvement.
30% Reduction in ETL data validation time.
98% Accuracy achieved in monthly data reconciliation reports.
Zero escalations from the client during UAT and go-live phase.
Improved test coverage and documentation for future QA teams.
Strong SQL and data profiling skills are essential for ETL testers.
Early detection of issues through proactive testing avoids costly delays.
Clear documentation and communication play a vital role in cross-team collaboration.