ATISH DIPANKAR MUKHERJEE
Pune
Summary
ETL QA Lead | Databricks & Data Testing | BFS & Insurance | Delivery Excellence | PSM I & II | Driving Quality, Zero Defect Delivery & High Performing Teams
- Results-driven IT professional with 18 years of experience, including 15 years with TCS, specializing in testing delivery and quality engineering across Insurance and BFS domains. Proven track record of leading end-to-end QA for large-scale, business-critical programs with strong focus on quality, efficiency, defect prevention, and customer satisfaction.
- Experienced in defining and implementing test strategies, optimizing processes, and ensuring high-quality data validation and system reliability. Skilled in Databricks, PySpark, and SQL for data quality assurance and validation of cloud migration and analytics solutions. Hands-on experience with modern test management tools like Azure DevOps (ADO) to streamline test lifecycle and enhance traceability.
- Recognized for strong leadership and people management, currently leading a 10-member team while contributing to a Customer Satisfaction Index (CSI) score of 95% through continuous coaching, process improvements, and delivery excellence. Committed to innovation in testing methodologies to minimize defect leakage and accelerate product delivery.
Overview
19
19
years of professional experience
1
1
Certification
Work History
ETL Test Lead
Munich RE
10.2023 - Current
- Data Marketplace platform for discovering and managing analytical data
- Led ETL testing delivery for a Data Marketplace platform, managing a 10-member QA team across 4 business domains
- Responsible for test strategy, planning, estimation, execution, defect management, and sign-off across all domains
- Worked as an Individual Contributor for the Finance domain, owning end-to-end testing lifecycle, including requirement analysis, data validation, and release readiness
- Took initiative to define and standardize Smoke Test and Regression Test suites
- Drove regression automation using PySpark and SQL, improving test coverage and execution efficiency
- Delivered end-to-end testing for 15+ products and product enhancements across 10 consecutive monthly releases.
- Designed and executed 3,000+ functional, integration, and data validation test cases.
- Identified and logged 200+ defects across SIT & regression cycles, preventing production issues.
- Ensured consistent quality across frequent releases through structured smoke, regression, and impact-based testing.
QA Lead & Scrum Master
Credit Suisse, Tata Consultancy Services
07.2020 - 10.2023
- Handling multiple projects and requirements under Investment Banking
- Managed a peak team of 5 resources for QA delivery under Investment Banking
- Undertook Test Planning, Management, Test Estimation, and Resource Planning
- Involved in eliciting requirements through extensive client and end user interaction
- Created reusable test cases, testing courseware and documentation
- Provided training, technical upskilling, and mentoring for junior team members
QA Lead
Toll Holdings Ltd, Tata Consultancy Services
06.2019 - 04.2020
- Single-entry point for logistics and freight transport services
- Identified scope for testing, walked through wireframes, and created test scripts based on wireframe or JIRA story
- Participated in various testing types including System and User Acceptance Testing
- Developed robust test plans and executed automation test scripts using Selenium
QA Lead
Morgan Stanley, Tata Consultancy Services
09.2010 - 06.2019
- Involved in Web service testing and ETL testing during this period.
- Tested Java and Python based applications using agile & waterfall methodologies
- Worked on all the backend RFB automation/maintenance for 39 applications in QA and UAT environment.
- Prepared test plans and traceability matrices
- Participated in daily scrum meetings to provide testing current status
- Managed defect tracking and reporting
- Infrastructure monitoring, support and management across all the applications in non-PROD environments [ QA / UAT / Dev] with 18 x 5 coverage.
Developer
Syntel India LTD
07.2007 - 09.2010
- As a Sybase programmer Handling procedure, triggers, cursors modification for new business requirement
- Hands on experience in bug tracking and fixing in procedures and triggers
- Writing shell scripting and Cron job modification according to business rules.
- Finding impact analysis for the bulk data uploading and updating Automation of test scenarios
- Handling Unix-Sybase Production Server, taking backup and organizing files in the UNIX Production server for batch processing.
- Providing RCA (Root Cause Analysis) of certain data inconsistency.
- Finding the reason of corn job failure.
Education
Master of Computer Application -
Graphic Era Institute of Technology, Garhwal University
Uttarakhand, India05.2007
Bachelor of Computer Application - undefined
University Of Burdwan (B.U)
West Bengal, India05.2004
Skills
Quality Assurance and Test Strategy
Expert in enhancing testing processes and improving product quality
Leadership and Team Management
Strong leadership skills in leading cross-functional teams
KEY ACHIEVEMENTS
- Reduced defect leakage by 35% by introducing an early-defect-detection framework through enhanced requirement reviews and shift-left testing practices.
- Improved data validation efficiency by 40% by implementing automated PySpark/SQL validation suites in Databricks for large datasets during cloud migration.
- Delivered critical releases with zero post-production critical defects, ensuring uninterrupted business operations for Insurance & BFS clients.
- Achieved 95% Customer Satisfaction Index (CSI) consistently through strong stakeholder engagement, proactive risk management, and delivery discipline.
- Scaled QA capability by 60% through mentoring and upskilling team members in ETL, Databricks, and test automation.
- Saved ~500+ manual hours per release cycle by optimizing test planning, regression coverage, and reusable test accelerators.
Certification
Databricks Certified Data Engineer Associate
Professional Scrum Master (PSM I & PSM II)
Completed Power BI Certification – Edureka
BFSI level-1 certified
Completed certification on OCA 1ZO-007.
TCS ITIL Internal/External certified.
Additional Information
Testing & QA: Azure DevOps (ADO), JIRA, ALM / QC
Technologies: Databricks, PySpark, SQL, Delta Lake
Cloud Migration & Data Testing: ETL/Data Pipelines, Data Reconciliation, SCD validation, Performance testing of data pipelines
Automation: Python-based automation
Agile / SDLC: Scrum, Sprint Planning, PI Planning, Retrospectives, Defect Triage, Release Management
Timeline
ETL Test Lead
Munich RE
10.2023 - Current
QA Lead & Scrum Master
Credit Suisse, Tata Consultancy Services
07.2020 - 10.2023
QA Lead
Toll Holdings Ltd, Tata Consultancy Services
06.2019 - 04.2020
QA Lead
Morgan Stanley, Tata Consultancy Services
09.2010 - 06.2019
Developer
Syntel India LTD
07.2007 - 09.2010
Bachelor of Computer Application - undefined
University Of Burdwan (B.U)
Master of Computer Application -
Graphic Era Institute of Technology, Garhwal University