Ashish Purohit

Data Engineer

Pune, Maharashtra, India8 yrs 8 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

Expert in designing scalable data pipelines.
Proficient in Azure cloud technologies.
Strong background in data engineering for healthcare.

Stackforce AI infers this person is a Data Engineering expert in the Healthcare and Automotive sectors.

Contact

Skills

Core Skills

Data EngineeringAzure DatabricksAzure Data FactoryAzure Synapse AnalyticsDevopsFrontend Development

Other Skills

AngularAngularJSAzure Data Lake Storage Gen2Azure Data LakehouseAzure DevOpsAzure SQL Data WarehouseCI/CDCSSData ExtractionData MigrationData Pipeline DesignData PipelinesETLExpressJSGit

About

Graduated with a Bachelor’s Degree in Computer Science from Jaipur Engineering College and Research Centre, I am currently working as a Data Engineering Manager at Blue Altair. My responsibilities include designing, building, and maintaining robust data pipelines that standardize large-scale data ingestion into an Azure Data Lakehouse environment for a global pharmaceutical firm. Leveraging expertise in Azure Databricks, PySpark, and Azure Data Factory, I focus on creating scalable solutions to transform and manage high-volume data. My work is driven by a collaborative approach, ensuring seamless integration of data pipelines and optimizing workflows.

Experience

Blue altair

2 roles

Manager

May 2024 – Present · 1 yr 10 mos · Pune, Maharashtra, India · On-site

> Working as Data Engineering Manager for a global Pharmaceutical firm.
> Responsible for designing, building and maintaining scalable & robust data pipelines, bringing high volume data from different source systems and load them in an industry standard format in a Data Lake.
> Responsible for building triggers and schedule pipelines to run in a unified flow to ingest data using configurable parameters into an Azure DataBricks LakeHouse managed tables.

Azure DatabricksData EngineeringData PipelinesAzure Data Lakehouse

Senior Consultant

Aug 2022 – Apr 2024 · 1 yr 8 mos · Pune, Maharashtra, India · On-site

> Led data engineering efforts for a global pharmaceutical firm, specializing in Azure cloud technologies.
> Designed, orchestrated, and maintained large-scale data pipelines utilising Azure Data Factory, Azure Data Lake Storage Gen2, and Azure Databricks.
> Implemented Medallion Architecture for lakehouse, ingesting data from diverse sources like Relational Databases, REST APIs, and SharePoint into Azure Data Lake Storage Gen2.
> Architected & Desgined a custom CI/CD solution to migrate ETL pipelines and datasets from Azure Data Factory to higher environment allowing migration of a single artifact which is not supported by ADF CI/CD out of the box.
> Facilitated migration of BI solutions from On-Prem to Azure Synapse Analytics for a major US auto auctions firm.
> Orchestrated ETL pipelines in Azure Synapse Analytics, processing data with custom SQL logic and populating an Enterprise Data Warehouse with close to 60 Dims and Fact tables for reporting via PowerBI.
> Ensured data integrity across platforms by troubleshooting stored procedures, ETL logic, and data ingestion processes.
> Established robust CI/CD pipelines using Azure DevOps for deploying ETL pipelines and Data Warehouse objects, alongside devising an efficient git branching strategy.

Azure Data FactoryAzure Data Lake Storage Gen2Azure DatabricksMedallion ArchitectureCI/CDAzure Synapse Analytics+2

Fresh gravity

Consultant

Jun 2020 – Jul 2022 · 2 yrs 1 mo · Pune, Maharashtra, India

> Migrating an on-premises data warehouse to Azure Synapse Analytics for a major US-based auto auctions firm.
> Working as a DevOps Engineer, managing Azure DevOps platforms by creating and maintaining code repositories and CI/CD pipelines for Azure Synapse Analytics, Azure SQL Data Warehouse, and Azure Data Factory.
> Developing a Clinical Trials Data Tenant using Python, extracting unstructured data from ClinicalTrials.gov and loading it into Reltio MDM in a standardised industry format.
> Participating in multiple projects at Gravity Labs and Enterprise Labs, utilizing technologies such as Python, Azure, AWS, and GCP.
Contributing to the technical recruitment process for roles in DevOps, SDET, Cloud Data Engineering, Full Stack Development, and Site Reliability Engineering (SRE).

Azure Synapse AnalyticsAzure SQL Data WarehouseAzure Data FactoryPythonDevOpsData Engineering

Accenture

2 roles

Application Development Analyst

Promoted

May 2019 – Jun 2020 · 1 yr 1 mo · Pune Area, India

> Re-wrote one of the Client’s application using Angular6 and used JSON Schema Form and Data Grids in place of HTML Forms and Tables to achieve better UI and performance.
> Responsible for creating the initial project structure, implementing routing and creating services which are consumed throughout the application.
> Implemented Server-Side Pagination in Data Grids to increase the Grid performance by at least 10 times while handling about 100,000 records at a time.
> Implemented SSO using MSAL to enable user login through O365 account and fetch user details via the MS Graph API.
> Integrated Socket.io on both client side and server side to enable dynamic data refresh on the view as soon as the DB is changed without manual refresh.
> Worked on various Data Grids including ui-gird, ag-grid and ejs-grid to process huge amount of data.

AngularJavaScriptHTML5CSSJSONFrontend Development

Application Development Associate

May 2017 – Apr 2019 · 1 yr 11 mos · Pune Area, India

> Worked on Front-End development using MEAN (MongoDB, ExpressJS, Angular, NodeJS) stack as part of Accenture’s Green Field Training Program.
> Worked on e2e website development using Angular as a framework and NodeJS as the backend.
> Created Responsive Websites using BootStrap v3.0
> Leveraged concepts of asynchronous programming and AJAX to create event driven and interactive web apps.
> Worked on TypeScript: a superset of JavaScript and created several projects using the same.

AngularNodeJSMongoDBExpressJSFrontend Development