Job Description :
Description/Comment:
Must have - Microsoft Azure (Azure Data Factory, Azure Data lake Store, Azure SQL Data Warehouse) and BI technologies such as MSBI, SQL server, SQL queries - DDL, DML and other 
Exposure to .NET technologies: C#/.Net 
Power Shell scripting is a plus 

Hands on experience in designing & development of ETLs using Azure data factory 
Participate in Framework design & building solution 
Should know how to establish connections to different data sources such as Data Lake 
Should be familiar with all the transformations available in ADF such as copy, web, look ups, decision controls, iteration loops, data flow task etc. in order to perform ETL 
Should have experience in scheduling and automating ADF pipelines 
Good experience in SQL Server database system and No-SQL databases: knowledge of SQL query is a must 
Should be able to design and develop stored procedures for Azure SQL DWH 
Hand-on experience on Polybase or any other external table concepts 
Experience in designing and developing various SSIS packages (ETL) to extract and transform data and scheduling SSIS packages 
Should have hands on knowledge on executing SSIS packages via ADF 
Should have development, testing and deployment knowledge including best practices and coding standards 
Practical knowledge of Agile approach 
Client facing skills