Dineshkumar Murugan
Chennai
Summary
Detail-oriented ETL Tester with 5.2 years in banking, specializing in ETL testing and data validation. Expert in SQL-based source-to-target validation, defect management with JIRA, and Agile Scrum methodologies. Developed automation scripts for test case preparation and data extraction, enhancing data quality across enterprise ETL pipelines.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Quality Engineering Lead
Infosys Ltd
Chennai
10.2020 - Current
- Developed automation scripts to dynamically generate test cases and extract validation datasets directly from databases, significantly reducing manual effort, and accelerating regression cycles.
- Designed and executed complex SQL validation scripts to verify data transformation logic, aggregation accuracy, and end-to-end reconciliation between source and target systems.
- Managed and maintained comprehensive test cases, ensuring business rules, and data validation coverage across banking ETL pipelines.
- Identified data discrepancies, performed root cause analysis, and logged defects in JIRA with detailed reproduction steps and validation queries to facilitate effective resolution.
- Analyzed mapping documents and transformation specifications to ensure business rule integrity across Informatica ETL workflows.
- Performed target table load verification, ensuring completeness, referential integrity, and successful job execution prior to business sign-off.
- Coordinated with client stakeholders and development teams to resolve defects efficiently and ensure adherence to service level agreements.
- Conducted regression testing cycles post-fix deployment, and formally validated and closed defect tickets upon successful remediation.
- Maintained defect lifecycle tracking to enhance data quality metrics and reduce turnaround time for defect resolution.
- Participated in daily scrums, including stand-ups, and defect tracking meetings.
Education
Bachelor of Engineering - Computer Science
Kongu Engineering College
Erode04-2020
Skills
- ETL testing
- Database testing
- Data warehouse testing
- SQL
- Informatica
- Python
- Regression testing
- Root cause analysis
- Manual testing
Certification
Informatica Tutorial - Beginner to Expert Level - Udemy.
Languages
Tamil
Native
Native
English
Proficient (C2)
C2
Timeline
Quality Engineering Lead
Infosys Ltd
10.2020 - Current
Bachelor of Engineering - Computer Science
Kongu Engineering College