• Reqroute
  • $107,040.00 -160,420.00/year*
  • Whitehouse Station , NJ
  • Information Technology
  • Full-Time
  • 51 School Rd

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

Associated topics: .net, algorithm, c#, develop, java, php, programming, sdet, software development engineer, software engineer

* The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.

Launch your career - Upload your resume now!

Upload your resume

Loading some great jobs for you...