Hands on Experience in Azure data factory (ADF) data migration projects from On-
Prem to Cloud and legacy applications (such as SSIS , Talend, Snowflake) to Cloud.
•Hands on experience with Azure Data Factory, Azure Data Lake, Azure SQL Data
Warehouse, Azure Blob, Azure Storage Explorer, Azure Data flows and Azure services
like Logic apps & Azure functions.
•Experience in designing and building Data Factory Pipelines from the scratch,
schedule and monitor them.
•Experience in writing T-SQL Objects like Stored Procedures, Indexes, Views, Joins,
Temporary Tables and User defined Functions.
•Worked with incremental loads and methods like SCD Type1 & SCD Type 2
•Worked with various activities like Get Metadata, Lookup, Foreach, copy data,
wait, delete, stored procedure,
set variable, append variable, if condition, filter, until, data flow, web activity
, execute pipeline , fail ,
validation & scripts activities
•Worked with various Transformations like Flatten, derived column, surrogate key,
select, union, aggregate,filter, Lookup, Conditional Split, exists & alter row
•Worked with Azure Security & Identity features like Azure Active Directory App
Permissions, Key Vaults.
•Worked on stored procedures that insert & update the ADF pipeline logs
•Worked with logic apps to send an email notification on failure of the pipeline
•Worked on ADF error handling and logging the bad data from source
•Worked on pulling the data from API’s using web activity transforming the data
using data flows and loading
them into Azure blob
•Experience in creating Linked services for Azure SQL Server , SFTP, Rest API’s ,
Azure PostgreSQL , On premise
SQL server , Azure Blob , Azure Data Lake , DB2 , On premise file system
•Experience in creating scheduled & event based triggers•Hands on Experience i
