Ashok Pandarkar
Sr. Test Engineer
Pune
Summary
Sr. Test Engineer with 12+ years in ETL testing, data warehouse validation, and SQL-based data reconciliation. Validates 6–8 integration touchpoints per project cycle, 20+ queries per week, transformation logic, and subscriber lifecycle data across 21+ source-to-target load flows using Informatica PowerCenter, SSIS, and stored procedures. Uses Gen AI tools to speed test case creation, SQL generation, and script comparison while protecting data quality and delivery accuracy.
Overview
3
3
Languages
12
12
years of professional experience
9
9
years of post-secondary education
Work History
Sr. Test Engineer
TransUnion
07.2023 - 06.2026
- project: Sontiq
- Spearheaded testing initiatives to guarantee software quality and reliability across multiple platforms.
- Streamlined data loading processes using SSIS jobs and executed stored procedures (SPs) to ensure data integrity across integration touchpoints including DPE partner portal and partner API.
- Leveraged SSIS jobs to streamline data loading processes and executed stored procedures (SPs) to maintain data integrity across integration touchpoints including DPE partner portal and partner API.
- Conducted comprehensive service and breach code checks to validate integrity of partner requests for subscriber services, including black web monitoring and credit monitoring.
- Validated integrity of partner requests for subscriber services, such as black web monitoring and credit monitoring, through comprehensive service and breach code checks.
- Coordinated various workstreams using strong testing principles in safe agile framework to facilitate timely project completion.
- Employed strong testing principles in safe agile framework to coordinate various workstreams and facilitate timely project completion.
- employed generative AI platforms including OneTru Assist to improve productivity by expediting test case creation, SQL/script generation, script evaluation, and interpretation of complex ETL logic
Technical Lead(Data Centric Testing)
Wipro Limited
08.2021 - 07.2023
- project-Finance gateway
- Orchestrate data-focused testing strategies for finance gateway project since August 2021, prioritizing sourcing and merging data from multiple streams via Informatica PowerCenter ETL tool.
- Formulate and execute test cases for ensuring accuracy of data extraction, transformation, and loading processes in a centralized data warehouse design.
- Oversaw and confirmed complete workflows for file watcher, file validation, parameter generation, stage load, gateway processing, file delivery tolerance checks, and project data mart (PDM) loads to ensure seamless data processing.
- oversee and confirm complete workflows involving file watcher, file validation, parameter generation, stage load, gateway processing, file delivery tolerance checks, and project data mart (PDM) loads.
- Leverage BMC Control-M for job scheduling across various environments to facilitate timely data processing and delivery.
- Evaluate Informatica workflow and session logs to resolve data processing challenges and maintain data integrity.
- Executed interface testing for business modules including loans, current accounts, non-trade, basel, slb, and money market across multiple regions and file sets.
- Conducted dmc report testing to validate exception records between exception tables and final reports, ensuring accuracy and completeness in reporting.
- Establish and execute filtering and de-duplication techniques for consolidated reports to effectively track business files by file name and business date.
- Mentored junior QAs, enhancing their skills and promoting knowledge sharing within the team.
Consultant(ETL Tester)
Capgemini
03.2019 - 08.2021
- project: Enterprise Data Quality Framework & Reporting
- Conducted thorough end-to-end testing for enterprise data quality framework.
- Ensured data quality rules for completeness, accuracy, consistency, and integrity prior to data loading.
- Validated ETL procedures, data integration mappings, source-to-target data flow, and file processing.
- Assessed functionality of Python automation scripts (generateconfig.py, validaterules.py) ensuring integrity of generated configuration files.
- Orchestrated UNIX shell scripts and validated effective data transfer into Teradata data warehouse.
- Confirmed dq execution logs and results recorded within DB2 dq_log tables.
- Executed tableau dashboard testing to verify accuracy of summary and detailed dashboards, ensuring reliable data representation.
- Authenticated dashboard computations involving pass rates, break rates, product-oriented breakdowns, and data element-wise quality control scores.
- Completed comprehensive UI validation that included assessment of labels, legends, fonts, colors, date formats, filters, navigation, and page consistency.
- Facilitated backend data reconciliation connecting DB2 database views to Tableau dashboards.
- Developed process improvement initiatives that streamlined workflows, contributing to enhanced operational efficiency and increased client satisfaction.
Test Analyst(ETL)
FIGMD
08.2017 - 02.2019
- project: American Academy of Ophthalmology (AAO), USA
- Orchestrated ETL testing for American Academy of Ophthalmology (AAO) data warehouse project, enhancing functionality for one of the largest medical academies in USA.
- Designed and conducted extensive test cases to confirm the accuracy of data extraction, transformation, and loading operations.
- Crafted and optimized SQL queries to ensure accurate data validation and count verification between source and target systems.
- Facilitated functional integration regression re-testing and validation testing to ensure data precision and system reliability.
- Validated and corroborated reporting outputs to maintain accuracy and integrity for data analysis and decision-making.
- Employed SQL Server 2012, WPS, Excel, MS Office Suite, and Jira to oversee test documentation and monitor defects efficiently.
- Engaged with diverse teams to pinpoint and address system defects.
Test Analyst(ETL)
Savy Software
05.2014 - 07.2017
- project: American Academy of Head and Neck Surgery (AAOHNS), USA
- Performed ETL validation for AAOHNS, a renowned US medical academy dedicated to head and neck surgery data aggregation.
- Validated extraction, transformation, and loading processes for client data into SQL Server 2012-based data warehouse, ensuring data accuracy.
- Confirmed extraction, transformation, and loading processes for client data into SQL Server 2012-based data warehouse.
- Conducted functional integration regression and re-testing to ensure system reliability and enhance performance.
- Implemented comprehensive system and compatibility testing across environments to maintain smooth operations.
- verified record counts and test reports for data processing accuracy
- Harnessed SQL Server 2012, WPS, Excel, MS Office Suite, and JIRA for optimized defect tracking and test management.
Education
Master of Computer Applications -
Sinhgad Institute of Technology, Lonavala
Pune, India 08.2010 - 07.2013
B.Sc - Computer Science and Technology
Chandmal Tarachand Bora College , Shirur
Pune 07.2007 - 06.2010
HSC - Science
Shri Chhatrapati Shivaji Mahavidyalaya , Shrigonda
Ahmednagar, India 07.2005 - 06.2007
SSC - General Studies
Renukadevi Vidyalaya, Pimpalgaon Pisa, Shrigonda
Ahmednagar, India 06.2004 - 06.2005
Skills
SSIS ETL
Informatica PowerCenter
AWS
BMC Control M
SQL
ETL testing
Data quality testing
Tableau dashboard testing
MS SQL server
Teradata databases
Oracle databases
Linux commands
Source-to-target mapping
Test case design
Test case execution
Defect management
Reporting validation
SAFe Agile methodology
Accomplishments
- Technical Excellence — for contributions to the Sontiq project at TransUnion.
- Customer First — for contributions to the Sontiq project at TransUnion.
- Unit Award — for contributions to the Finance Gateway project at Wipro.
- Pat on Back — for contributions to the Data Quality Control Framework project at Capgemini.
- Star Performer — for contributions to the AAOHNS project at FigMD.
Extra-curricular activities
CSR activities like Blood donation camp, Visit to Orphanage child's
- Organized and successfully coordinated a Blood Donation Camp in 2025, collecting 100+ units of blood to support local hospitals and patients in need.
- Led volunteer efforts by coordinating donors, managing event logistics, and ensuring the smooth execution of the blood donation drive.
- Visited orphanages as part of a community outreach initiative to support children's education and well-being.
- Distributed essential educational supplies, including school bags, notebooks, pens, pencils, and other stationery, to underprivileged children.
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Sr. Test Engineer
TransUnion
07.2023 - 06.2026
Technical Lead(Data Centric Testing)
Wipro Limited
08.2021 - 07.2023
Consultant(ETL Tester)
Capgemini
03.2019 - 08.2021
Test Analyst(ETL)
FIGMD
08.2017 - 02.2019
Test Analyst(ETL)
Savy Software
05.2014 - 07.2017
Master of Computer Applications -
Sinhgad Institute of Technology, Lonavala
08.2010 - 07.2013
B.Sc - Computer Science and Technology
Chandmal Tarachand Bora College , Shirur
07.2007 - 06.2010
HSC - Science
Shri Chhatrapati Shivaji Mahavidyalaya , Shrigonda
07.2005 - 06.2007
SSC - General Studies
Renukadevi Vidyalaya, Pimpalgaon Pisa, Shrigonda
06.2004 - 06.2005
Hobbies
- Mentoring
- Trekking
- Carrom
- Cricket
- Swimming
- Making new Friends