Strong experience in Business Intelligence/SQL Server Developer in ADF, Database designing, Data loading, Data Modelling and Reports creation using SQL Server 2016/2014/2012/2008R2 for OLTP/ETL/OLAP environments.
Strong Knowledge on Azure & function apps
MS Dynamics 365 exp is must
Strong experience in Dynamic SQL queries, Sub-queries, CTE’s (common table expressions), Tale Variables and Temp Tables.
Strong experience with analysing and debugging existing Complex stored procedures, and error handling using Try-Catch blocks.
Strong experience in implementing Azure Data factory pipeline components such as linked services, Datasets, and Activities.
Strong experience in connecting to different sources like on-premises SQL servers, Virtual Machines, Azure SQL database, data lake storage, and blob storage from ADF.
Strong experience in installing the IRs in ADF
Good knowledge on C#, CSS and HTML
Proven proficiency in Data Transformations like Lookup, Derived Column, Conditional Split, Sort, Data Conversion, Union All and Merge Join.
Azure cloud Engineer with experience in Planning, Implementing and Supporting Azure Infrastructure
Strong experience in creating different types of Complex Reports using MS Excel Power Query, MS Excel Power View, and Power BI
Having Experience on Microsoft Power BI (Desktop, Service, Mobile)
Extracted data from On-Premises into Power BI desktop.
Created the data model by pulling the data from multiple sources and transform the raw data into business information by applying the transform rules.
Applied transform rules Data Conversion, Data Cleansing, Data Aggregation, Data Merging and Data split.
Good experience in SDLC (Software Development Life Cycle) involving System analysis, Design Development & Implementation using Waterfall methodology

ADF Engineer