Summary
Overview
Work History
Education
Skills
Websites
Accomplishments
Certification
Timeline
Generic

ASHWITA GAJARE

Mumbai,Maharashtra

Summary

Data Engineer with nearly 3 years of experience designing and optimizing ETL pipelines, data workflows, and cloud data warehousing solutions using Snowflake and AWS services (S3, Glue, Lambda, Step Functions, Athena, DMS). Specialized in query optimization, data reconciliation, and pipeline automation to ensure accurate, scalable, and reliable data delivery. Skilled in data modelling and preparing analytics-ready datasets for business reporting. Passionate about leveraging cloud technologies to provide business stakeholders with real-time insights into portfolio distribution, market trends, and performance.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Data Engineer

KFin Technologies Pvt. Ltd.
02.2023 - Current
  • 1. Snowflake Integration with AWS Data Lake (Client: 360 One WAM)
  • Designed and implemented data ingestion pipelines from AWS S3 to Snowflake, optimizing for minimal cost and high throughput.
  • Automated daily workflows using SnowSQL tasks and stored procedures, improving efficiency and reducing manual interventions.
  • Optimized Snowflake compute/storage usage, achieving 50% cost reduction by fine-tuning queries and warehouse sizing.
  • Improved transaction processing pipelines, delivering an 80% reduction in processing time for large datasets.
  • Contributed to data modeling and KPI design, enabling 10× faster portfolio analysis and real-time reporting.
  • 2. ETL Pipeline for Master Data Management (MDM) using AWS
  • Migrated on-premise data to AWS using Change Data Capture (CDC) with DMS.
  • Developed incremental ETL logic in Glue/PySpark to build mirror datasets for MDM, reducing processing costs.
  • Built audit and reconciliation framework to validate mirrored data and implemented real-time alerts for discrepancies.
  • Orchestrated workflows with Step Functions, Lambda, EventBridge, and Secrets Manager for robust end-to-end automation.
  • 3. Analytical Reporting & Data Mart Design
  • Designed data marts and KPIs in Snowflake to support wealth management analytics.
  • Wrote advanced SQL procedures/functions (e.g., XIRR, Benchmark Returns) that processed GBs of data with sub-second response times.
  • Structured data pipelines to enable real-time dashboarding and client-ready analytics reports.
  • 4. Client Reporting & Power BI Dashboards on Audit Framework
  • Created Power BI dashboards directly on top of migrated data outputs and ETL Jobs to provide client-facing transparency into data quality and accuracy.
  • Designed validation reports highlighting discrepancies, ensuring quick resolution and building client trust.
  • Automated data refresh cycles (daily, weekly, monthly) with built-in validation layers, ensuring reporting accuracy across periods.
  • Empowered business stakeholders with self-service dashboards to track reconciliation, reducing dependency on manual reports.

Software Analyst Intern

Coffee Chat Pvt. Ltd.
12.2021 - 06.2022
  • 1: Web Development & UI Enhancement
  • Developed and maintained responsive web pages using Bootstrap, improving page load speed and accessibility for internal users.
  • Designed interactive UI wireframes in Adobe XD, streamlining the design approval process and reducing rework.
  • 2: Data Collection & Operational Analysis
  • Built and maintained data collection scripts for internal projects, ensuring accurate and timely data for analytics.
  • Collaborated with business teams to analyze operational workflows and propose improvements that led to smoother feature rollouts.

Education

Master of Science - Master In Computer Applications

Veermata Jijabai Technological Institute
Mumbai, India
01.2023

Bachelor of Science - Bachelor in Science, Information Technolgy

Sophia College (Autonomous)
Mumbai, India
01.2019

Skills

  • Cloud & Data: Snowflake AWS (Glue, Lambda, Step Functions, Athena, S3, DMS) Data Lakes
  • Programming & Querying: SQL (Oracle, PostgreSQL, MySQL) Python PySpark Scala
  • ETL & Data Engineering: ETL Development Data Modeling Data Reconciliation Query Optimization
  • Visualization & Tools: Power BI Figma Git Adobe XD

Websites

Accomplishments

Awards: Rookie Rockstar (KFin Technologies), Silver Medal in Athletics & Carrom (Sophia College)

Certification

Certification: Data Analytics with Python (NPTEL)

Timeline

Data Engineer

KFin Technologies Pvt. Ltd.
02.2023 - Current

Software Analyst Intern

Coffee Chat Pvt. Ltd.
12.2021 - 06.2022

Master of Science - Master In Computer Applications

Veermata Jijabai Technological Institute

Bachelor of Science - Bachelor in Science, Information Technolgy

Sophia College (Autonomous)

Similar Profiles

CREATE PROFILE
ASHWITA GAJARE