Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic
SHANTANU VINCHURKAR

SHANTANU VINCHURKAR

Pune

Summary

Seasoned Senior Data Engineer with over 9.5+ years of experience serving clients in the USA and Canada, specializing in the insurance, banking, and finance domains. Expertise in ETL tools such as DBT, Snowflake ADF, and Informatica, alongside proficiency in Oracle 12G and UNIX environments. Skilled in analyzing business requirements and implementing multi-dimensional data projects, while maintaining high standards of quality and speed. Excellent interpersonal skills and ability to manage critical situations independently, ensuring effective collaboration with team members and stakeholders.

Overview

10
10
years of professional experience
1
1
Certification

Work History

Senior Data Engineer

Cummins India
Pune
02.2024 - Current
  • Executed migration of existing ODI-OBI warehouse to Snowflake using Matillion framework.
  • Led Power BI team to develop multiple dashboards for various plants.
  • Created generic ADF pipelines to migrate data from diverse source systems to Snowflake.
  • Maintained comprehensive Meta Data Framework tables within SQL Server database.
  • Developed Azure data flows for streamlined integration layers.
  • Migrated SSIS packages to Matillion for integration and data mart models.
  • Optimized load timings during data transfers into Snowflake target tables.
  • Provided support and resolution for production job failures to relevant teams.

Specialist Data Engineer

Larson And Tourbo Infotech
Pune
09.2021 - 01.2024
  • Developed generic ADF pipelines for data migration from various source systems to Snowflake.
  • Established XML parsing framework utilizing Snowflake functionalities.
  • Maintained all metadata framework tables within SQL Server database.
  • Migrated existing Informatica mappings into DBT for current system of records.
  • Designed Azure data flows for integration layer enhancements.
  • Converted SSIS packages into DBT models for integration and data mart applications.
  • Optimized load timings for efficient data loading into Snowflake target tables.
  • Provided support and resolutions for production failure jobs to relevant teams.

Data Engineer

Persistent Systems
01.2019 - 09.2021
  • Abinitio, Informatica, DBT-Snowflake, Oracle12g, Autosys, Control Center, JIRA,Udeploy, AWS S3, Java Script Procedures in Snowflake
  • The purpose of the project is 'Single View of Data' to the downstream consumers from all the subject area source systems like Credit, Deposit, and Securities in wholesale banking of Wells Fargo.
  • The purpose also serves the need for the conformance and non-conformance activities of all the SOR (system of record) data which was coming directly from the sources.
  • Designing, establishing, assessing and implementing AB Initio ETL graphs.
  • Responsible for creating generic frameworks which would create Xfr, Dml and Psets dynamically during run time and loading maximum number of tables through the Psets generated.
  • Migrated the existing Informatica mappings into Ab Initio graphs for the existing SOR's.
  • Developed shell scripting for File based data's coming from Different sources.
  • Working on the JIRA assigned sprint wise from the client on various development and enhancement tasks.
  • Creating the tables using snowsql as per the business requirements.
  • Creating Snowflake procedures with ETL transformations for staging and data mart Models with DBT.
  • Crating task for snowflake procedures.

Consultant

Saama Technologies
Pune
12.2015 - 01.2019
  • Responsibilities include Requirement Gathering, FRS clarification, and preparing High level and Low-level design documents.
  • Involved in Business Users Meetings to understand their requirements.
  • Worked with complex mappings having an average of 10 transformations.
  • Daily communication with the onsite counterparts, Clients.
  • Develop Informatica Mappings, Write SQL queries, and mentoring of project modules.
  • Primary Role: ETL Process, SQL Developer
  • Involved in design, development, and maintenance of database for Data warehouse project.

Education

B.E - Computer Science

Pune University
Sandip Foundation
05.2015

H.S.C -

Maharashtra Board
Bhonsala Military School
03.2011

Maharashtra Board
Pethe High School
03.2009

Skills

  • SQL
  • DBT
  • Snowflake
  • Snowpipe
  • Snowsql
  • Python
  • Azure Data factory
  • Azure Data flow
  • Oracle
  • Informatica Power Centre
  • ETL
  • ELT
  • Data Warehouse Development
  • XML Parsing using Snowflake
  • Hadoop
  • HIVE
  • Power BI
  • Matillion
  • Metadata management
  • Performance optimization
  • Agile methodologies
  • Business requirements analysis
  • Team Leader
  • Leadership
  • Strategic planning
  • Time management
  • Team collaboration
  • Supervision and leadership

Certification

  • Academy accreditation - generative AI fundamentals
  • Snowflake Hands-On Essentials - Data Warehouse
  • Track 1: From data loading to stunning visualizations
  • Big data engineering with Hadoop and Spark
  • Academy Accreditation - Generative AI Fundamentals

Languages

English
Advanced (C1)
C1
Hindi
Advanced (C1)
C1
Marathi
Advanced (C1)
C1

Timeline

Senior Data Engineer

Cummins India
02.2024 - Current

Specialist Data Engineer

Larson And Tourbo Infotech
09.2021 - 01.2024

Data Engineer

Persistent Systems
01.2019 - 09.2021

Consultant

Saama Technologies
12.2015 - 01.2019

B.E - Computer Science

Pune University

H.S.C -

Maharashtra Board

Maharashtra Board

Similar Profiles

CREATE PROFILE
SHANTANU VINCHURKAR