Sangram Mohite
Pune
Summary
Experienced Azure Data Engineer with a certification and a track record of success in designing and implementing efficient data pipelines, architectures, and ETL workflows on the Azure cloud platform. Utilizing various Azure services such as Azure Data Factory (ADF), Azure Databricks, PySpark, and Azure SQL Database to create scalable and effective data solutions. Skilled in managing data lakes, integrating and processing data from multiple sources, and ensuring smooth data flow across cloud environments. Expertise in optimizing data pipelines for high performance, cost-effectiveness, and scalability while upholding data quality and security standards.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Data Engineer
Tata Consultancy Services
07.2022 - Current
- Performed comprehensive data exploration to identify anomalies and inconsistencies, ensuring high-quality and reliable data for analysis and reporting
- Designed and optimized SQL queries and stored procedures to handle large datasets efficiently, improving data retrieval times and query performance
- Developed advanced SQL-based data extraction and cleaning workflows to preprocess raw data, enabling accurate insights for business intelligence
- Engineered a scalable Data Lake architecture using Azure Data Lake Storage Gen2, streamlining data storage, access, and management for a variety of data types
- Implemented end-to-end ETL pipelines with Azure Data Factory, automating data flow from multiple sources, including APIs, on-prem databases, and flat files, to ensure seamless integration and data transformation
- Built and optimized big data processing workflows using Azure Databricks and PySpark, reducing data processing latency by 30% and improving the performance of business-critical analytics
- Developed and managed ETL pipelines within Databricks to transform raw data into structured, analytical datasets, enhancing data accessibility for data science teams
- Configured and optimized Databricks clusters for cost-effective, scalable compute resources, ensuring high performance and reduced infrastructure costs
- Collaborated with cross-functional teams to understand data requirements and deliver high-impact, actionable insights to stakeholders
- Automated data quality checks within ETL pipelines to ensure data accuracy and consistency across all integrated sources
Assistant System Engineer
Tata Consultancy Services
01.2022 - 07.2022
- Led the migration of complex Sybase stored procedures to Snowflake and PostgreSQL, translating and adapting SQL logic to suit cloud-based environments, ensuring a smooth transition and minimal disruption
- Conducted thorough testing post-migration to validate data integrity, performance, and consistency, ensuring successful and reliable cloud migrations
Trainee Engineer
BOSCH Limited
02.2021 - 12.2021
- Designed, developed, and maintained interactive dashboards for monitoring of manufacturing production data, providing valuable insights into production performance, rejection rates, and overall process efficiency. Utilized Power BI to present data-driven insights for leadership and operational teams.
- Analyzed daily rejection data from Testline parameters to identify patterns, trends, and areas for improvement. Provided actionable insights to optimize production processes and reduce rejection rates.
Education
Bachelor - Engineering
Savitribai Phule Pune University
06.2020
INTERMEDIATE -
SMV
04.2016
HIGH SCHOOL -
KVPM
06.2014
Skills
- SQL
- Python
- PySpark
- Databricks
- Azure Data Factory
- Microsoft Azure
- Snowflake
- Power BI
- CI / CD
- SSRS
- ETL development
- Data modeling
Certification
- Microsoft Azure Data Engineer (DP-203), 08/2024, Achieved Azure Data Engineering Data completion certification through Microsoft, demonstrating proficiency and successful assessment completion.
- Microsoft Power BI Certification (PL-300), 02/2024, Achieved Power BI completion certification through Microsoft, demonstrating proficiency and successful assessment completion.
Timeline
Data Engineer
Tata Consultancy Services
07.2022 - Current
Assistant System Engineer
Tata Consultancy Services
01.2022 - 07.2022
Trainee Engineer
BOSCH Limited
02.2021 - 12.2021
INTERMEDIATE -
SMV
HIGH SCHOOL -
KVPM
Bachelor - Engineering
Savitribai Phule Pune University
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Pratik ChaflePratik Chafle
Data Engineer Manager at SaksoftData Engineer Manager at Saksoft