Summary
Overview
Work History
Education
Skills
Timeline
Address
Hi, I’m

Rohit Patil

Pune
Rohit Patil

Summary

  • 11+ years of experience in Quality Assurance with specialization in ETL/BI testing, pipeline validation, data migration, and software testing across healthcare, finance, multimedia, and entertainment domains.
  • Strong expertise in end-to-end QA processes : requirement analysis, test case design, test execution, defect logging, triage, and stakeholder reporting.
  • Hands-on experience in pipeline testing across ETL workflows and data lakes, validating source-to-target mappings, transformations, and near real-time data synchronization.
  • Created complex SQL queries to validate multiple scenarios and transformations , ensuring data accuracy and reconciliation across source and target systems.
  • Skilled in basic API testing using Postman , validating REST APIs, JSON responses, and integration points between applications.
  • Basic working knowledge of Python and PySpark for scripting, automation, and data validation tasks.
  • Proficient with ETL tools (Informatica, SSIS, ADF, Databricks, Hive), BI tools (Power BI, Qlik, Tableau, SAP BOXI), and cloud platforms ( AWS, Azure, Snowflake ).
  • Experienced in defect management using HP ALM, Rally, JIRA, VSTS, MTM, ADO, ensuring timely resolution and root cause analysis.
  • Adept at preparing test data, Requirement Traceability Matrix, and Test Summary Reports for compliance and audit readiness.
  • Extensive involvement in Agile/Scrum methodologies , actively participating in Sprint Planning, Daily Stand-ups, Sprint Reviews, and Retrospectives.
  • Demonstrated leadership skills as QA Lead: preparing estimations, defining Master Test Plans, mentoring new joiners, providing knowledge transfer (KT), and ensuring smooth onboarding.
  • Recognized for reducing defect leakage and improving QA efficiency through process improvements, optimized SQL scripts, and proactive triage management.
  • Tracked and managed burning hours in Azure DevOps (ADO) boards , ensuring accurate effort allocation, monitoring task progress, and providing visibility to stakeholders on sprint commitments and resource utilization.
  • Collaborated with Scrum Masters and Product Owners to refine sprint planning based on burn

Overview

12
years of professional experience
3
Languages

Work History

LTIMINDTREE Pvt. Ltd.

Specialist
10.2022 - Current

Job overview

  • Project Title : Project Everest.
  • Client: Mercer
  • Domain: Investment Banking
  • Role: Specialist
  • Project and Stakeholder Management
  • Contributed to project estimation, planning, and requirement analysis.
  • Acted as a liaison between BAU teams, vendors, and client stakeholders, ensuring effective communication and issue resolution.
  • Delivered daily and weekly status updates, facilitated change request discussions, and presented blockers with resolution strategies.
  • Test Execution and Validation.
  • Planned and executed end-to-end test cycles across QA, staging, and production environments.
  • Performed functional, regression, data validation, and sanity testing in production to confirm stability.
  • Prepared and built test data aligned with defined test scenarios.
  • Defect Management.
  • Identified, logged, and tracked defects related to code, deployment, design, and data inconsistencies using Rally and Azure DevOps (ADO).
  • Facilitated defect triage meetings, collaborated with developers, and business analysts for root-cause analysis, and ensured timely resolution.
  • Monitored defect trends and burning hours in ADO boards, providing insights into sprint progress and resource utilization.
  • Technical Expertise.
  • Designed and executed complex SQL and Athena queries for backend validation and financial data testing across pipelines and data lakes.
  • Leveraged basic knowledge of PySpark within Databricks for data validation and transformations.
  • Conducted BI report testing using Power BI and Qlik to validate dashboards and ensure accuracy.
  • Documentation and Compliance.
  • Produced Requirement Traceability Matrix, defect logs, test execution evidence, and Test Summary Reports for audit and compliance purposes.
  • Prepared and delivered detailed test result reports to stakeholders and clients, ensuring transparency and traceability.
  • Agile Methodology.
  • Actively participated in Agile ceremonies, including Sprint Planning, Daily Stand-ups, Sprint Reviews, and Retrospectives.
  • Collaborated with Product Owners, Scrum Masters, and other stakeholders to refine user stories, prioritize backlog items, and align testing objectives with sprint goals.
  • Demonstrated validated deliverables during Sprint Reviews, and recommended process improvements in Retrospectives to enhance team efficiency.

Neudesic Limited

Senior Test Analyst Neudedic
09.2021 - 10.2022

Job overview

  • Project Title: Data Modernization.
  • Client: ISAGENIX
  • Domain: Multimedia / Data Engineering
  • Role : Senior Consultant I

    Responsibilities:
  • Conducted requirement analysis, peer reviews, and test execution, ensuring deliverables aligned with business objectives.
  • Collaborated with Business Analysts, Developers, and client stakeholders to clarify study data requirements and resolve issues during project calls.
  • Prepared and built test data sets tailored to defined test scenarios for comprehensive validation.
  • Designed and executed complex SQL queries to verify application data handling and backend processes.
  • Performed SQL-based backend data load verification and report testing, ensuring accuracy and completeness of migrated datasets.
  • Identified and logged defects related to code, deployment, design, and source data, tracking them through Excel-based defect management.
  • Produced test execution evidence documents, including Requirement Traceability Matrix and Test Summary Reports, to support audit and compliance.
  • Attended daily status and triage meetings, providing updates on blockers, and suggesting resolution strategies.
  • Utilized Hive, Azure Data Factory (ADF), and Databricks for ETL testing, data validation, and cloud migration activities.
  • Actively participated in Agile ceremonies, including Sprint Planning, Daily Stand-ups, Sprint Reviews, and Retrospectives, contributing to backlog refinement, transparent communication, and continuous improvement.
  • Partnered with Product Owners, Scrum Masters, and stakeholders to refine user stories, prioritize backlog items, and align testing objectives with sprint goals.
  • Presented validated deliverables during Sprint Reviews, ensuring stakeholder confidence in data quality and reporting accuracy.
  • Recommended process improvements in retrospectives, enhancing collaboration, reducing defect leakage, and improving overall team efficiency.

Evolent Technologies

Senior Test Engineer
06.2020 - 09.2021

Job overview

  • Project Title: TPAMlops
  • Client: ECP
  • Domain: Healthcare
  • Role : QA Analyst
  • Conducted requirement analysis, peer reviews, and test execution , ensuring QA deliverables aligned with business objectives.
  • Worked onsite to review and verify end-to-end QA requirements, coordinating with onsite teams to understand business needs, and set up system requirements for testing.
  • Collaborated with stakeholders, client teams, and developers to discuss change requests, clarify requirements, and resolve issues during calls.
  • Prepared and built test data sets aligned with defined test scenarios for comprehensive validation.
  • Executed negative scenario testing to verify the handling of rejected data within the application.
  • Identified and logged defects related to code, deployment, design, and source data , tracking them using HP-ALM for timely resolution.
  • Produced test execution evidence documents, including Requirement Traceability Matrix and Test Summary Reports, to support compliance and audit readiness.
  • Attended daily status and triage meetings , providing updates on blockers, suggesting resolutions, and escalating issues per S2T protocol.
  • Reviewed and identified automation regression suites for regression testing of the application, ensuring stability across releases.
  • Utilized JIRA, SQL Server, SAS, and Power BI for defect tracking, backend validation, and reporting accuracy.
  • Actively participated in Agile ceremonies, including Sprint Planning, Daily Stand-ups, Sprint Reviews, and Retrospectives, contributing to backlog refinement, transparent communication, and continuous improvement.
  • Partnered with Product Owners and Scrum Masters to refine user stories, prioritize backlog items, and align QA objectives with sprint goals.
  • Presented validated deliverables during Sprint Reviews , ensuring stakeholder confidence in data quality and reporting accuracy.

Nihilent Technologies

IT Analyst
03.2019 - 06.2020

Job overview

  • Project Title: EDILZ (Enterprise Data Information Landing Zone)
  • Client: Multichoice.
  • Domain: Multimidea.
  • Role: QA Analyst.
  • Conducted analysis, design of test cases, peer reviews, and test execution, ensuring QA deliverables met project objectives.
  • Reviewed and verified end-to-end QA requirements, coordinating with onsite teams to understand business needs, and set up system requirements for testing.
  • Collaborated with onsite team members and developers to discuss change requests, clarify requirements, and resolve issues during sprint calls.
  • Created and updated test cases in Rally, tracking progress, and ensuring coverage across functional and regression scenarios.
  • Prepared and built test data sets aligned with defined test scenarios for comprehensive validation.
  • Executed negative scenario testing to verify the handling of rejected data within the application.
  • Identified and logged defects related to code, deployment, design, and source data, tracking them using the VSTS Tool for timely resolution.
  • Produced test execution evidence documents, including the Requirement Traceability Matrix and Test Summary Reports, to support compliance and audit readiness.
  • Attended daily status and triage meetings, providing updates on blockers, suggesting resolutions, and escalating issues when required.
  • Utilized Oracle, SQL Server, and Informatica for backend validation, ETL testing, and data warehouse integration.
  • Actively participated in Agile ceremonies, including Sprint Planning, Daily Stand-ups, Sprint Reviews, and Retrospectives, contributing to backlog refinement, transparent communication, and continuous improvement.
  • Partnered with stakeholders and Scrum Masters to refine user stories, prioritize backlog items, and align QA objectives with sprint goals.
  • Presented validated deliverables during Sprint Reviews, ensuring stakeholder confidence in data quality and reporting accuracy.

Infosys Limited

Test Analyst
08.2018 - 03.2019

Job overview

  • Got reviewed and verified end-to-end QA requirements, coordinating with onsite teams to understand business needs, and set up system requirements for testing.
  • Done requirement analysis, test case design, peer reviews, and test execution, ensuring QA deliverables aligned with project objectives.
  • Collaborated with onsite and offshore teams and developers to discuss change requests, clarify requirements, and resolve issues during triage and sprint calls.
  • Created and executed ETL and report test cases in VSTS, preparing and optimizing SQL scripts for backend validation.
  • Built test data sets aligned with defined scenarios, including negative testing to validate rejected data handling.
  • Identified and logged defects related to code, deployment, design, and source data, tracking them using the MTM Tool for timely resolution.
  • Produced test execution evidence documents, including the Requirement Traceability Matrix and Test Summary Reports, to support compliance and audit readiness.
  • Delivered status updates to stakeholders, escalated unresolved issues per test strategy, and participated in defect triage meetings.
  • Supported UAT activities, ensuring smooth execution and stakeholder confidence in deliverables.
  • Provided knowledge transfer (KT) to new joiners, assisting with onboarding and access setup.

Capgemini

Associate Consultant
09.2016 - 08.2018

Job overview

  • Reviewed and verified end-to-end QA requirements, coordinating with onsite teams to understand business needs, and set up system requirements for testing.
  • Collaborated with onsite/offshore teams and developers to discuss change requests, clarify requirements, and resolve issues during triage and sprint calls.
  • Created and executed ETL and report test cases in HP-ALM, preparing and optimizing SQL scripts for backend validation.
  • Built test data sets aligned with defined scenarios, including negative testing to validate rejected data handling.
  • Identified and logged defects related to code, deployment, design, and source data, tracking them using the HPQC Tool for timely resolution.
  • Produced test execution evidence documents, including Requirement Traceability Matrix and Test Summary Reports, to support compliance and audit readiness.
  • Delivered status updates to stakeholders, escalated unresolved issues per test strategy, and participated in defect triage meetings.
  • Supported UAT activities, ensuring smooth execution and stakeholder confidence in deliverables.
  • Provided knowledge transfer (KT) to new joiners, assisting with onboarding, and access setup.
  • Utilized Informatica, DB2, and SAP BOXI (BI Tool) for ETL testing, backend validation, and BI report verification.

Savy Software

Test Engineer
05.2014 - 08.2016

Job overview

  • Designed and executed test cases for ETL workflows and reporting validation, ensuring data accuracy across the Data Mart.
  • Conducted requirement analysis, test design, peer reviews, and test execution, aligning QA deliverables with project objectives.
  • Reviewed and verified end-to-end QA requirements, coordinating with onsite teams to understand business needs, and configure system requirements for testing.
  • Collaborated with onsite/offshore teams and developers to discuss change requests, clarify requirements, and resolve issues during triage calls.
  • Logged and tracked defects using HP ALM 12, ensuring timely resolution of issues related to code, deployment, design, and source data.
  • Prepared test execution evidence documents, including Requirement Traceability Matrix and Test Summary Reports, to support compliance and audit readiness.
  • Built test data sets aligned with defined scenarios, including negative testing to validate rejected data handling.
  • Utilized SSIS, SQL Server, and XML for backend validation, ETL testing, and data integration across multiple sources.
  • Delivered status updates to stakeholders, highlighting progress, blockers, and resolution strategies.
  • Attended daily status and triage meetings , providing proactive updates and escalating unresolved issues per test strategy.

Education

St Mary's College of Engineering
Hyderabad

B.Tech. from Information Technology
01-2013

Skills

ETL/BI Testing

Data Pipeline Testing

Data migration validation

Data Warehouse Testing

Defect Management

Cloud Platforms (AWS, Azure, Snowflake)

ETL Tools: (Informatica, SSIS, ADF, Databricks)

BI Tools: (Power BI, Qlik, Tableau, SAP BOXI)

Databases: (SQL Server, Oracle, MongoDB, DB2, Postgres, Snowflake DB, Athena, Databricks )

Testing Tools (HP ALM, Rally, JIRA, VSTS, ADO, MTM)

Scripting (SQL, Python, PySpark )

Timeline

Specialist

LTIMINDTREE Pvt. Ltd.
10.2022 - Current

Senior Test Analyst Neudedic

Neudesic Limited
09.2021 - 10.2022

Senior Test Engineer

Evolent Technologies
06.2020 - 09.2021

IT Analyst

Nihilent Technologies
03.2019 - 06.2020

Test Analyst

Infosys Limited
08.2018 - 03.2019

Associate Consultant

Capgemini
09.2016 - 08.2018

Test Engineer

Savy Software
05.2014 - 08.2016

St Mary's College of Engineering

B.Tech. from Information Technology

Address

Permanent Address: Guruprasad, Plot no-4, Svno-120/9b, Sus Road, Pashan, Near Lotus excellency, Pune -411021

Similar Profiles

CREATE PROFILE
Rohit Patil