Asif Shaik

Data Engineer @Edge Solutions

GB

Involved in designing the strategy for extracting data from Oracle Source Database and ingesting into Azure Data Lake Storage Layer• Produced flexible Data models on Azure SQL databases to redesign Reporting Platform• Designing and Developing Reusable Data Factory pipelines to load Dimension Tables• Designing and Developing Data Factory pipelines to load Fact Tables• Analysis and Design of CDC(Change Data Capture) Mechanisms in ETL jobs• Designing the Data Lake Architecture using Medallion Architecture on Azure Cloud Platform• Designing and Developing Data Factory pipelines to Process Semi Structured Data in Data Lake Silver Layer• Designing and Developing Data Factory pipelines to Integrate Data and load into Datalake Gold Layer• Performance tuning of Azure Data factory Pipelines and Azure SQL Datawarehouse Queries• Engineered and deployed a Synapse pipeline that centralized data from multiple sources like SAP ECC, KRONOS SQL Database, FRED Open API, S4 Hana and Success-Factor into Azure Data Lake Storage, optimizing data availability and streamlining processing tasks.