Sagar Kotak
Jamnagar
Summary
Seasoned Data Engineer with 6 years of overall experience and 2 years specializing in Azure Data Engineering. Proven track record in optimizing complex data pipelines, ensuring data security and compliance.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Azure Data Consultant
Infaworx Data Management Services
07.2024 - Current
- Revamped existing pipelines to drive efficiency by reducing total duration, enhancing stability, and aligning triggers with the source system for improved data accuracy.
- Collaborated with cross-functional teams to drive and oversee the migration of data from a legacy platform to a newly implemented centralized architecture
- Contributed to the design and implementation of dimension models
Azure Data Engineer
Capgemini
07.2022 - 07.2024
- Designed and implemented generic data ingestion pipelines for handling huge datasets for multiple objects spread across multiple schemas using Microsoft Azure Data Factory.
- Developed Generic Notebooks to ingest curated data into Azure Databricks and Synapse using PySpark.
- Monitored and optimized data pipeline for accuracy, security, and efficiency while collaborating with stakeholders to ensure adherence to data governance policies.
- Conducted data validation and error handling processes to ensure high data quality.
Founder / Director
URVISH SAGAR TECH Pvt Ltd
08.2017 - 02.2022
- Designed and developed a prototype of a new-age Automated Cooking System for household use.
- Defined company roles and responsibilities to establish and enhance processes.
- Learned Various Skills: 3D Printing, Fusion360, Android App Development, PCB Designing.
- Employed machine learning techniques to create predictive models for user behavior and product performance.
Education
B. Tech - ECE
01.2017
GPA: 7.4
Skills
- SQL
- Python
- Azure Data Factory
- Azure Databricks
- Azure Synapse Analytics
- SQL Server
- Dimensional Modeling
- Data Warehousing
Projects
Drone Delivery System (01/01/23)
Conducted a detailed analysis of drone-enabled food delivery systems. Evaluated direct and hybrid models, identified operational hubs, and developed a rollout plan for the Indian market. Performed SWOT analysis and calculated investment requirements for a single-city launch. Created a comprehensive presentation with detailed explanations and supporting calculations.
Airline Database Analysis (11/01/22)
Analyzed flight data to identify flights with the highest and lowest range, cancellation trends by date and airport, and customer refund details. Generated reports on flight delays and cancellations to support business decision-making.
Funnel Analysis (09/01/22)
Examined traffic changes and conversion rates through various stages (L2M, M2C, C2P, P2O). Developed hypotheses for conversion fluctuations, analyzed traffic trends compared to previous weeks, and identified sources of traffic variability.
Certification
- DATA ANALYST CERTIFICATION COURSE, Skillovilla, 01/01/23
- AI-0 Certification the Basics of Data Science, Univ.AI, 07/01/22
- Microsoft Power BI PL-300 Exam Course, Udemy, 05/01/22
- SQL Crash course for Aspiring Data Scientist, Udemy, 04/01/22
- Azure Data Engineering Workshop in a Weekend, Udemy, 03/01/22
- DP-900 Azure Data Fundamentals, Microsoft, 03/01/22
Languages
Hindi
First Language
English
Advanced (C1)
C1
Gujarati
Upper Intermediate (B2)
B2
Timeline
Azure Data Consultant - Infaworx Data Management Services
07.2024 - Current
Azure Data Engineer - Capgemini
07.2022 - 07.2024
Founder / Director - URVISH SAGAR TECH Pvt Ltd
08.2017 - 02.2022
Lovely Professional University - B. Tech, ECE
Similar Profiles
Puja KumariPuja Kumari
Customer Care Executive at Karvy Data Management Services LimitedCustomer Care Executive at Karvy Data Management Services Limited
Lakshmi CLakshmi C
• Technical Operations Analyst (Remote Job) at PBS Business Applications Management and Data Services Pvt Ltd, Bengaluru, Karnataka, India• Technical Operations Analyst (Remote Job) at PBS Business Applications Management and Data Services Pvt Ltd, Bengaluru, Karnataka, India
Ramya T.VRamya T.V
Renewal Operations Analyst at Rubrik India Private Limited (Cloud Data Management – Data & Cyber Security)Renewal Operations Analyst at Rubrik India Private Limited (Cloud Data Management – Data & Cyber Security)
Hardik RosiyaHardik Rosiya
Manager at Reliance Industries Limited, RILManager at Reliance Industries Limited, RIL
Advocate Samad F. IsaniAdvocate Samad F. Isani
Panel Lawyer at ICICI BankPanel Lawyer at ICICI Bank