Summary
Overview
Work History
Education
Skills
Timeline
Generic

Ashish Gharpure

DWH ETL Tester
Pune

Summary

Results-driven IT professional with over 8 years of experience specializing in ETL DWH testing within Sales and Insurance industries at Accenture, Pune, India. Proficient in IBM DataStage ETL tool and AWS Redshift data warehouse ETL testing, with a strong command of SQL for data validation. Skilled in test execution, preparing detailed test summary reports, and tracking defect reports. Knowledgeable in SDLC, STLC, and Data Warehouse processes, adept at creating design documents such as HLD, LLD, and unit test case documents. Actively involved in business requirement meetings at various project levels and proficient in conducting root-cause analysis within an Agile Model framework.

Overview

9
9
years of professional experience

Work History

ETL Tester

Accenture
09.2021 - Current
  • Company Overview: Accenture, Pune, India. Website: [Accenture](https://www.accenture.com)
  • Analyzed insurance domain requirements related to policies, claims, premiums, customers, and agent data for effective ETL testing coverage.
  • Validated ETL jobs by comparing source data from transactional systems (policy administration, claims processing) with the target data warehouse tables.
  • Wrote complex SQL queries to verify data integrity, completeness, and accuracy post-transformation.
  • Performed end-to-end validation of source-to-target mappings (STTM) for insurance-related data, including premium calculations, claim amounts, and policy status transitions.
  • Conducted data quality checks, such as duplicates, NULL values, incorrect mappings, and invalid code lookups (e.g., claim type, policy type).
  • Verified historical loads and incremental delta loads for correctness, with special focus on effective date tracking, renewals, lapses, and reinstatements.
  • Tested various scenarios, like claim fraud detection, policy lapse tracking, and policy renewal data, for accuracy.
  • Documented test cases, test results, and defects; tracked issues using JIRA/HP ALM, and ensured timely resolution.
  • Collaborated with ETL developers, and data architects, to clarify transformation logic and resolve data issues.
  • Accenture, Pune, India. Website: [Accenture](https://www.accenture.com)
  • Ensured data integrity by validating end-to-end data flows in complex, multi-tier systems.
  • Optimized ETL processes for faster data extraction, transformation, and loading.
  • Enhanced data quality by identifying and resolving ETL-related issues in a timely manner.
  • Maintained high-quality documentation of test plans, scripts, and defects to facilitate knowledge sharing among team members.
  • Elevated team performance by providing mentorship and guidance on best practices in ETL testing methodologies.
  • Validated data accuracy through comprehensive testing of source-to-target mappings and transformations.
  • Established a robust framework for regression testing, ensuring consistent results across multiple releases of the software application suite.
  • Supported business intelligence efforts through careful analysis of ETL-related metrics and trends.
  • Boosted project efficiency by collaborating with cross-functional teams to define test cases and test plans.
  • Safeguarded against incorrect calculations or aggregations in reports through meticulous validation of cube processing functions.
  • Contributed to successful project outcomes by effectively communicating test results and recommendations to stakeholders.
  • Performed thorough testing on data integration projects to ensure accurate results.
  • Identified opportunities for process improvements by conducting regular reviews of existing procedures and protocols.
  • Maximized system reliability through diligent verification of error-handling capabilities within various modules.
  • Collaborated closely with development teams to ensure seamless integration of ETL components, resulting in accurate, and efficient data processing.
  • Mitigated risks associated with data migration projects through rigorous pre-implementation testing activities.
  • Reduced testing timeframes by automating repetitive tasks using industry-standard tools.
  • Developed expertise in multiple ETL tools, increasing flexibility in supporting diverse project requirements.
  • Improved system performance by analyzing bottlenecks and implementing effective solutions.
  • Streamlined the testing process by developing reusable SQL queries for various ETL components.
  • Operated under Agile and Scrum frameworks to complete releases and well-organized sprints.
  • Tested the functionality and compatibility of new programs or updates in comparison to existing applications.
  • Developed and maintained defect databases for known issues.
  • Evaluated the function, performance, and design compliance of every product against design standards and customer needs.
  • Monitored the resolution of bugs, tested fixes, and helped developers tackle ongoing problems by providing a QA perspective.
  • Incorporated delivery requirements into the planning of testing schedules.
  • Built automated test scripts to handle repetitive software testing work.
  • Recommended changes and corrections to developers for optimal software performance and usability.
  • Kept scripts and test cases updated with current requirements.
  • Completed pre-implementation testing for new system modifications to assess potential impacts.
  • Documented testing procedures for developers and future testing use.
  • Authored and maintained well-organized, efficient, and successful manual test cases for the entire team.
  • Gathered data on integration issues and vulnerabilities, reported findings, and recommended improvements.
  • Completed in-depth usability testing on Windows, Android, and iOS mobile devices.
  • Advised developers on problems with databases, performance, and other issues.

ETL Tester

Accenture
09.2021 - Current
  • Company Overview: Accenture, Pune, India. Website: [Accenture](https://www.accenture.com)
  • Analyzed and validated the data as per business logic.
  • Running pipeline using Jenkin.
  • Prepared SQL queries for data validation.
  • Validated the data reflecting on dashboard as per business logic.
  • Working in Agile Model and taking part in all scrum activities.
  • Created and tracked all the issues in JIRA.
  • Involved in business requirement meetings across different levels of the project.
  • Validated the target data against to source data as per the business logic provided.
  • Data pipeline execution using Jenkins.
  • Accenture, Pune, India. Website: [Accenture](https://www.accenture.com)
  • Enhanced data quality by identifying and resolving ETL-related issues in a timely manner.
  • Maintained high-quality documentation of test plans, scripts, and defects to facilitate knowledge sharing among team members.
  • Ensured data integrity by validating end-to-end data flows in complex, multi-tier systems.
  • Optimized ETL processes for faster data extraction, transformation, and loading.
  • Elevated team performance by providing mentorship and guidance on best practices in ETL testing methodologies.
  • Validated data accuracy through comprehensive testing of source-to-target mappings and transformations.
  • Established a robust framework for regression testing, ensuring consistent results across multiple releases of the software application suite.
  • Supported business intelligence efforts through careful analysis of ETL-related metrics and trends.
  • Boosted project efficiency by collaborating with cross-functional teams to define test cases and test plans.
  • Safeguarded against incorrect calculations or aggregations in reports through meticulous validation of cube processing functions.
  • Contributed to successful project outcomes by effectively communicating test results and recommendations to stakeholders.
  • Performed thorough testing on data integration projects to ensure accurate results.
  • Identified opportunities for process improvements by conducting regular reviews of existing procedures and protocols.
  • Maximized system reliability through diligent verification of error handling capabilities within various modules.
  • Collaborated closely with development teams to ensure seamless integration of ETL components, resulting in accurate and efficient data processing.
  • Mitigated risks associated with data migration projects through rigorous pre-implementation testing activities.
  • Reduced testing timeframes by automating repetitive tasks using industry-standard tools.
  • Developed expertise in multiple ETL tools, increasing flexibility in supporting diverse project requirements.
  • Improved system performance by analyzing bottlenecks and implementing effective solutions.
  • Streamlined the testing process by developing reusable SQL queries for various ETL components.
  • Operated under Agile and Scrum frameworks to complete releases and well-organized sprints.
  • Tested functional and compatibility of new programs or updates in comparison to existing applications.
  • Developed and maintained defect databases for known issues.
  • Evaluated function, performance and design compliance of every product against design standards and customer needs.
  • Monitored resolution of bugs, tested fixes, and helped developers tackle ongoing problems by providing QA perspective.
  • Incorporated delivery requirements into planning of testing schedules.
  • Built automated test scripts to handle repetitive software testing work.
  • Recommended changes and corrections to developers for optimal software performance and usability.
  • Kept scripts and test cases updated with current requirements.
  • Completed pre-implementation testing for new system modifications to assess potential impacts.
  • Documented testing procedures for developers and future testing use.
  • Authored and maintained well-organized, efficient, and successful manual test cases for the entire team.
  • Completed in-depth usability testing on Windows, Android and iOS mobile devices.
  • Advised developers on problems with databases, performance and other issues.

Senior Associate

Capgemini Pvt. Ltd.
04.2016 - 08.2021
  • Company Overview: Capgemini Pvt. Ltd. Website: [Capgemini](https://www.capgemini.com)
  • Perform low level and high-level data testing on migrated data.
  • Worked with Development team to implement required changes in mappings and logic at Informatica level.
  • Performed data validation testing.
  • Covered all the functionality and requirements while testing.
  • Logged, tracked, and closed defects in JIRA.
  • Actively participated in defect calls and bridges for quick resolution of defects.
  • Created mappings Involved in Change and Release management process.
  • Involved in Unit Testing and regression testing.
  • Involved in Migration activities for migrating the code across environment.
  • Involved in creating design document like HLD, LLD and unit test case document.
  • Involved in business requirement meetings across different level of project.
  • Capgemini Pvt. Ltd. Website: [Capgemini](https://www.capgemini.com)
  • Trained and supported new team members, maintaining culture of collaboration.
  • Collaborated with cross-functional teams to drive successful completion of complex projects within deadlines.
  • Mentored junior associates, fostering professional growth and helping them reach their full potential.
  • Consistently maintained strong relationships with clients, ensuring clear communication and timely updates on project progress.
  • Effectively managed multiple competing priorities while maintaining focus on delivering exceptional results for clients and the organization.
  • Implemented process improvements that led to significant time savings and increased accuracy in deliverables.
  • Increased client satisfaction through thorough analysis of project requirements and delivering high-quality results.
  • Streamlined operational efficiency by identifying areas for improvement and proposing actionable solutions.
  • Identified potential risks to develop mitigation plans and minimize impact on project timelines.
  • Analyzed customer data to identify trends and anticipate customer needs.
  • Developed and implemented strategies to increase customer satisfaction and engagement.
  • Completed daily logs for management review.
  • Increased customer service success rates by quickly resolving issues.
  • Drafted common document templates to reduce time spent creating documents from scratch.
  • Followed detailed directions from management to complete daily paperwork and computer data entry.
  • Trained and supervised employees on office policies and procedures.
  • Opened and properly distributed incoming mail to promote quicker response to client inquiries.
  • Performed wide-ranging administrative, financial and service-related functions.
  • Volunteered to help with special projects of varying degrees of complexity.
  • Increased profitability and productivity by minimizing downtime and streamlining quality control procedures.
  • Streamlined office operations by effectively monitoring and addressing client correspondence and data communications.
  • Managed data and correspondence to secure information across complex landscapes of organizational departments.
  • Served as corporate liaison for finance, IT, and marketing departments.
  • Directed automation of office procedures such as correspondence management, recordkeeping and online communications.
  • Planned and coordinated logistics and materials for board meetings, committee meetings, and staff events.
  • Remained solutions-oriented in face of complex problems to assist management and overall business direction.
  • Proofread and edited documents for accuracy and grammar.
  • Assisted clients with daily living needs to maintain self-esteem and general wellness.
  • Answered and managed incoming and outgoing calls while recording accurate messages for distribution to office staff.

Education

Bachelor Of Engineering - Electronics

G.H. Raisoni College of Engineering
Nagpur, Maharashtra
05-2015

Skills

SQL

PL/SQL

Python

AWS Redshift

Oracle 11g

Informatica Power Center 91

IBM DataStage

AWS

Jenkin

JIRA

Confluence

Unix

WinSCP

Putty

Databricks

Cognos

Timeline

ETL Tester

Accenture
09.2021 - Current

ETL Tester

Accenture
09.2021 - Current

Senior Associate

Capgemini Pvt. Ltd.
04.2016 - 08.2021

Bachelor Of Engineering - Electronics

G.H. Raisoni College of Engineering

Similar Profiles

CREATE PROFILE
Ashish GharpureDWH ETL Tester