Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic

Sunny Jagtap

Pune

Summary

Google Cloud Certified Data Engineer with 9 years of experience in designing, implementing, and optimizing data solutions. Proven expertise in building scalable data pipelines on Google Cloud Platform (GCP) using BigQuery, Data Fusion, and Cloud Composer. Adept at automating complex data processes with Python and Bash, managing diverse data storage systems, and collaborating with cross-functional teams to deliver high-impact data-driven results. Recognized as a top performer for strong technical analysis and data warehousing management skills.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Data Engineer

VOIS
12.2020 - Current
  • Engineered and deployed robust, scalable data pipelines on Google Cloud Platform (GCP) utilizing Data Fusion, BigQuery, and Cloud Composer to process large-scale datasets efficiently.
  • Designed and managed comprehensive data storage solutions across BigQuery, Cloud Storage, and Cloud SQL, ensuring data integrity, availability, and performance.
  • Automated critical data processing and Business-As-Usual (BAU) tasks using Python, Bash, and AWS Lambda, reducing manual intervention and improving system reliability.
  • Led the integration of disparate data sources, including RDBMS and delimited files, by developing custom ETL solutions with Oracle Data Integrator (ODI).
  • Collaborated directly with data scientists and business analysts to translate complex requirements into technical solutions, enhancing data accessibility and analytical capabilities.

Technical Lead, ETL Developer

Clover Infotech Pvt Ltd
04.2020 - 12.2020
  • Supervised the architecture, design, and implementation of ETL solutions and Change Requests, ensuring alignment with business objectives.
  • Played a key role in designing scalable, reusable, and low-maintenance ETL templates using Oracle Data Integrator (ODI).
  • Conducted rigorous code reviews and walkthroughs to maintain high standards of code quality and documentation across the team.
  • Automated solution monitoring processes, significantly reducing the need for manual oversight and improving operational efficiency.

ETL Developer

Tata Consultancy Services
08.2016 - 03.2020
  • Developed ETL processes to integrate General Ledger transaction data from multiple SAP systems into an OBIEE data warehouse using Oracle Data Integrator (ODI).
  • Translated business requirements into technical specifications for the enterprise data warehouse, designing Star and Snowflake schemas.
  • Designed and developed a fully automated system for catalog generation using Talend, applying core ETL and data warehousing concepts.
  • Wrote, optimized, and maintained complex SQL statements, stored procedures, cursors, and views across MySQL, PostgreSQL, and Oracle databases.
  • Developed custom Java routines within Talend to extend functionality and meet specific project requirements.

Education

Bachelor of Science - Computer Science

R.Y.K Science College (Pune University)
Nashik, India
04-2016

Skills

    Cloud Platforms: Google Cloud Platform (GCP) (BigQuery, Cloud Data Fusion, Cloud Composer, Cloud Storage, Cloud SQL, Cloud Spanner), AWS (Lambda)

    Data Engineering & ETL: Oracle Data Integrator (ODI 11g & 12c), Talend 701, Data Warehousing Management, ETL/ELT Design, Data Modeling

    Databases: Oracle Database (12c), MySQL, PostgreSQL, RDBMS, PL/SQL

    Programming & Scripting: Python, SQL, Bash, PowerShell, VB Script

    BI & Reporting: Oracle Business Intelligence Enterprise Edition (OBIEE)

Certification

Associate Cloud Engineer - Google Cloud Platform (Issued April 2023)

Languages

English
Bilingual or Proficient (C2)
Hindi
Bilingual or Proficient (C2)
Marathi
Bilingual or Proficient (C2)

Timeline

Data Engineer

VOIS
12.2020 - Current

Technical Lead, ETL Developer

Clover Infotech Pvt Ltd
04.2020 - 12.2020

ETL Developer

Tata Consultancy Services
08.2016 - 03.2020

Bachelor of Science - Computer Science

R.Y.K Science College (Pune University)
Sunny Jagtap