Vaibhav Kalshetty
Pune
Summary
Results-driven Data Engineer with 4 years of experience in designing and implementing scalable data solutions across AWS, GCP, Snowflake, DBT, SQL, and Python. I am skilled in developing efficient data pipelines, transforming complex datasets, and enabling analytics through modern cloud and ELT frameworks. Known for strong ownership, structured problem-solving, and the ability to thrive in dynamic, collaborative environments. Committed to delivering high-quality data products while contributing to team growth, innovation, and operational excellence.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Sr System Engineer
Infosys Technologies Ltd.
04.2022 - Current
- Engineered robust pipelines using Snowflake, DBT, and Python, optimizing data ingestion from AWS S3 and GCP Cloud Storage via Snow-Pipe (SQS) and COPY INTO commands for structured and semi-structured (JSON) data.
- Architected Change Data Capture (CDC) workflows using Snowflake Streams and Tasks to automate seamless incremental processing from staging to production layers.
- Developed modular DBT models utilizing macros, custom tests, and snapshots to enforce data integrity and streamline transformation logic across cross-functional teams.
- Integrated DBT Elementary for real-time observability and automated alerting via Control-M, reducing pipeline downtime and data quality incidents.
- Optimized complex query performance using LATERAL joins, window functions, and flattened views for high-performance analytics in Snowflake and Big-Query.
- Leveraged Terraform (IAC) to provide AWS resources and managed IAM/RBAC policies to ensure secure, compliant data access and governance.
- Implemented lightweight automation using GCP Cloud Functions and Pub/Sub for event-triggered data processing and API-based data extraction.
- Query Optimization: Leveraged Snowflake Query Profiling to identify bottlenecks, reducing average transformation runtime by [20%] through strategic clustering and pruning.
- Scalability: Migrated manual workflows to DBT-based incremental materialization, handling [500GB+] of daily data with zero manual intervention.
- Security Compliance: Automated PII data masking using Snowflake Masking Policies and DBT post-hooks, ensuring 100% compliance with data privacy standards.
Education
Bachelor of Engineering - Mechanical
Savitribai Phule Pune University
Skills
- Snowflake
- DBT
- SQL
- PYTHON
- AWS
- GCP
- Data Warehousing
- Google Big-Query
- Transformation & Modeling
- Python (Pandas, API Integration)
- Cloud Platforms
- AWS (S3, SQS)
- GCP (Cloud Storage, Functions, Pub/Sub)
- DevOps & Infrastructure
- Terraform (IAC)
- Git (Version Control)
- CI/CD
- Observability & Scheduling
- DBT Elementary
- Control-M
Certification
- Google cloud certified Professional Data Engineer
- Infosys Certified Google Cloud Digital Leader
- Infosys Certified SAP Business Intelligence
- Coursera Certified Snowflake Developer
- Essentials of Cloud Computing, Infosys
- Infosys Global Agile Developer Certified
- Coursera Certified Working on Big-Query
Personal Information
- Date of Birth: 09/05/98
- Marital Status: Unmarried
Projects
Northwestern Mutual, Northwestern Mutual Life Insurance Company is one of Milwaukee's largest corporations, and among the largest life insurance providers, real estate investors, and financial services enterprises in the United States.
Disclaimer
I hereby declare that the information given above is best of my knowledge and true.
Languages
- Hindi
- Marathi
- Kanada
- English
- Hindi
- Marathi
- Kanada
Key Performance Highlights
- Query Optimization, Leveraged Snowflake Query Profiling to identify bottlenecks, reducing average transformation runtime by 20% through strategic clustering and pruning.
- Scalability, Migrated manual workflows to DBT-based incremental materialization, handling 500GB+ of daily data with zero manual intervention.
- Security Compliance, Automated PII data masking using Snowflake Masking Policies and DBT post-hooks, ensuring 100% compliance with data privacy standards.
Languages
English
First Language
Marathi
Beginner
A1
Hindi
Proficient
C2
Kannaada
Intermediate
B1
Timeline
Sr System Engineer
Infosys Technologies Ltd.
04.2022 - Current
Bachelor of Engineering - Mechanical
Savitribai Phule Pune University