An ETL developer having 5.7 years of Overall Industry Experience, proficient in SQL, Azure Data Factory, Azure DataBricks, Microsoft SSIS, and Power BI. Skilled in developing and optimizing Complex Extract, Transform and Load (ETL) processes and developing business critical power bi reports and dashboards, I consistently deliver high-quality Data Solutions tailored to meet business requirements.
Educational Qualification:
Bachelor Of Technology (C.E.), 2014-2018
Dharmsinh Desai University
Work Experience:
Data Engineer -
Role and Responsibilities:
● Designed and Implemented End-to-End delta data mechanism to load incremental data from various sources including Oracle DB, SQL Server, MongoDB, Delimited Texts as well as API Responses with high performance.
● Provided Support on operations for Data Load for SQL DataWarehouses.
● Migrated Snaplogic Data Pipelines to Azure Data Factory Pipelines for better integration.
● Designed and Implemented multiple ETL solutions for migration using SQL Server Integration Service.
● Designed and Implemented End-to-End process in ADF, DataBricks to Extract, Transform and Load the data from various DataBases and REST API with 25 % decrease in overall processing time.
● Successfully Migrated SSIS solutions into Microsoft Azure Data Factory pipelines that resulted in a 50 % decrease in overall data load time.
● Built Business Critical Dashboards and Reports in Power BI with effective usage of various visualization tools and Database Queries from SQL Server and MongoDB.
● Created multiple SQL Stored procedures to ingest/process Unstructured data for Data Warehouse applications.
● Optimized Existing SQL stored procedures which resulted in up to 60% time reduction in overall execution.
● Refactored multiple SQL Queries to improve data load performance by 300%
● Managed and mentored a small team of newly onboarded ETL developers.
● Maintained multiple strategies for small teams to optimize deployments to higher environments with Support of Azure DevOps CI/CD Processes.
Copyright© Cosette Network Private Limited All Rights Reserved