Summary
Overview
Work History
Education
Skills
Rewards & Recognition
Timeline
Generic

Varsha Mandave

Specialist Data Engineer
Pune,Maharashtra

Summary

Experienced Data Engineer with 8 years of expertise in Snowflake, DWH, ETL, and data warehouse application development. Skilled in designing and maintaining scalable data pipelines, ETL processes, and data warehousing solutions. Proficient in Snowflake, PL/SQL, and Informatica IICS. Strong background in performance tuning, automation, and cross-functional collaboration. Adept at transforming complex data into actionable insights to support strategic decision-making. Recognized for delivering high-quality solutions in fast-paced, deadline-driven environments.

Overview

5
5
years of professional experience
6039
6039
years of post-secondary education

Work History

Specialist – Data Engineering | Data & Analytics

LTIMindtree
Pune
07.2022 - Current
  • Built Snowflake-based data lake integrating data from SAP, SFDC, Oracle, and other sources.
  • Developed views and ETL pipelines using Informatica IICS and HVR.
  • The platform will allow ingestion of all relevant data related to Finance, Customer Experience, Procurement and engineering verticals.
  • Enabled global reporting access for 500+ business users and C-level executives, consolidating data into a single source of truth for analytics and decision-making.
  • By doing so, it will address the existing challenges of consuming disparate data from various sources.
  • It will enable global business users, C-Executives and other personas to have a seamless reporting experience concerning the central data lake as a single source of truth.
  • Ensured data quality through validation and transformation processes.
  • Streamlined workflows and collaborated with cross-functional teams for seamless reporting.
  • Role & Responsibilities: Requirement analysis based on client provided Data Model and Mappings, interacting with Client for any clarifications.
  • Developing Views in Snowflake as per the requirements and Designing IICS Jobs to load the data into Fact Table using stored procedure framework designed by Honeywell.
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
  • Led requirement analysis based on client-provided data models and mappings, resolving 100+ queries/clarifications through ongoing client interactions.
  • Improved data validation accuracy by 30% through automated transformation logic and pre-load checks, reducing manual errors and reprocessing time.
  • Increased query performance by 40% by redesigning data ingestion flows, optimizing warehouse usage, and restructuring tables for analytics efficiency.
  • Designed and implemented a stored procedure framework to automate data loading into 10+ fact tables, ensuring consistency and reusability.
  • Tools Used: Snowflake, Informatica IICS, Bitbucket, GitHub, Control-M

Consultant

Capgemini
Pune
05.2020 - 07.2022
  • Managed transactional databases for vehicle sales, invoicing, and stock movement.
  • Enhanced and optimized PL/SQL code across 50+ procedures/functions, improving system response time by 30% and resolving 20+ recurring bugs.
  • Led incident resolution and root cause analysis (RCA) for 100+ issues, maintaining >98% SLA compliance and reducing repeat incidents by 25%.
  • Independently handled integrations and dashboard development.
  • Roles and Responsibilities: Designed and deployed 5+ integration modules to process daily data feeds from various upstream systems, ensuring seamless data ingestion and functional transformation.
  • Developed custom dashboards and monitoring tools that improved visibility into stock and sales movement, reducing manual reporting time by 40%.
  • Handled daily batch monitoring, troubleshooting, and ensured proper execution of automated jobs to maintain business continuity.
  • Independently managed change requests and service requests, completing over 30+ work orders (WOs), and providing cost and effort estimations for each.
  • Acted as a key point of contact for functional teams and stakeholders, translating business requirements into scalable solutions and technical tasks.

Education

Bachelor of Engineering (BE) -

Savitribai Phule Pune University
Pune
06.2016

HSC -

Shivaji University
Satara
06.2012

SSC -

Shivaji University
Satara
05.2010

Skills

  • Snowflake

  • Oracle PL-SQL

  • ETL Tools: Informatica IICS, Control-M

  • Application Enhancement & Maintenance

Version Control : GitHub, Bitbucket, TeamCity, WinSCP

  • Tools & IDEs: PL/SQL Developer, Putty, JIRA, SDI Vivant

  • Incident Management (RCA)

  • Functional Expertise: Application Development , Data Analysis, Incident Management (RCA), Application Enhancement & Maintenance

Rewards & Recognition

  • Super Crew Award – 2025
  • Titanic Award – 2021
  • Project Star Award – 2020
  • Fire Fighter Award – 2019

Timeline

Specialist – Data Engineering | Data & Analytics

LTIMindtree
07.2022 - Current

Consultant

Capgemini
05.2020 - 07.2022

Bachelor of Engineering (BE) -

Savitribai Phule Pune University

HSC -

Shivaji University

SSC -

Shivaji University

Similar Profiles

CREATE PROFILE
Varsha MandaveSpecialist Data Engineer