Chinmay Joshi
Pune
Summary
Experienced Data Engineer with a robust background in SQL, specializing in designing and implementing ETL/ELT processes, Data Warehouse, and Data Lakehouse solutions using Azure Data Factory, Databricks and Snowflake. Strong leadership and communication skills that help in delivering complex data projects efficiently.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Junior Software Engineer
Encora Inc.
08.2022 - Current
- Contributed to a data migration project for a major state run insurance provider in the US from on prem database servers to Snowflake using Azure Data Factory and Azure Databricks including more than 250 database servers and integrating diverse data sources from external vendors including API, Service Now,SmartSheet and files of various formats like zip,csv,parquet,,pdf, multi-tab xlsx, etc
- Developed both batch and near real time stream processing using Azure Databricks Delta Lakehouse platform
- Designed and developed a Data Engineering and Unified Data Governance solutions using Azure Databricks for the insurance company providing them with a delta lake and integrated analytics environment
- Engineered Data Warehousing solutions using Azure Synapse Analytics, Data Lake Storage, and Stream Analytics for a leading East US pharmaceutical company, enhancing BI reporting and inventory management
- Integrated EHR systems with Teradata Vantage, developing BI reports using Apache Superset.
- Developed and deployed a cycle counting inventory management algorithm using SQL in Azure Synapse Analytics that helped the pharmacy keep a better track of its SKUs and replenish them in a timely manner
Software Development Intern
Bluepineapple.io
12.2019 - 06.2020
- Worked on optimizing and developing complex SQL queries and stored procedures for performing ELT processes using Azure Data Factory and MS SQL Server to build a OLAP system for an organisation in the pharmaceutical industry.
- Developed complex views for the analytical dashboard.
Education
Master of Science - Industrial Mathematics with Computer Applications
Fergusson College
Pune2020
Bachelors of Science - Computer Science
Fergusson College
Pune2017
Skills
- Languages : SQL, Python, Javascript
- Tools and Technologies : Azure Data Factory, Databricks, Azure Synapse Analytics, Snowflake, Azure SQL Database, Azure Data Lake Storage Gen 2, Azure Stream Analytics, Teradata, PySpark, SparkSQL
Accomplishments
- Selected for the Indian Air Force (Flying Branch) in 2017
Certification
- Microsoft Azure Data Engineer Associate (DP-203)
- Databricks Data Engineer Associate
- Teradata Vantage Associate 2.3
Timeline
Junior Software Engineer
Encora Inc.
08.2022 - Current
Software Development Intern
Bluepineapple.io
12.2019 - 06.2020
Master of Science - Industrial Mathematics with Computer Applications
Fergusson College
Bachelors of Science - Computer Science
Fergusson College
Similar Profiles
Edinson Quevedo HolguinEdinson Quevedo Holguin
Senior QA Automation Engineer at Encora inc.Senior QA Automation Engineer at Encora inc.
JAYVELYN G. DIAZJAYVELYN G. DIAZ
IT Operation Analyst at Encora Inc.IT Operation Analyst at Encora Inc.
Suganya VasudevanSuganya Vasudevan
Principal Consultant at Encora Inc.Principal Consultant at Encora Inc.
Komal SatputeKomal Satpute
Azure Data Engineer at Motifworks Inc. – An Accion Labs CompanyAzure Data Engineer at Motifworks Inc. – An Accion Labs Company
MOHIT SINGHMOHIT SINGH
Fiber Network Planner at Tech MahindraFiber Network Planner at Tech Mahindra