Manish Pandey

About Manish Pandey

6 years of experience in ETL/Data-warehouse Testing with a strong focus on AGILE (SCRUM) Methodologies and Software Test Life Cycle (STLC).Worked extensively with modern integration tools such as Snowflake, Azure Data Factory, Azure Logic Apps, and Dell Boomi.Actively involved in Sprint Planning Meetings, Sprint Review Meetings, and Sprint Retrospective Meetings.In-depth knowledge of Star schema and Snowflake schema, including the management of Dimension and Fact Tables in Data-warehouses.Hands-on experience in writing complex SQL Queries on databases such as Teradata and Oracle SQL Developer.Proficient in HP-ALM Test Management Tool for writing and executing test cases based on Mapping and Design Documents.Strong knowledge of Defect Life Cycle Management using HP-ALM, with extensive experience in defect tracking and bug reporting.Experience with issue tracking and bug reporting using Jira.Solid understanding of Informatica Client Components —including Workflow Manager and Workflow Monitor —and strong testing experience in Informatica Power Centre.Extensive use of ETL methodology for supporting data extraction, transformation, and loading processes across corporate environments.Highly analytical with strong critical-thinking and problem-solving abilities.Experienced in client interactions, including gathering requirements, understanding business needs, conducting product demonstrations, and providing ongoing product support.Responsible for preparing key testing documents, including Test Strategy and Test Summary reports.

Experience

1. Assistant Manager

   Deloitte

   May 2025 — Present · Gurugram, IN

Education

• Kavi Kulguru Institute of Technology and Science, Ramtek

  Bachelor of Engineering - BE

  2011 — 2015

• Army Public School (APS)

  High School

  2010 — 2011