Role: Azure data lakes Consultant Location: Jackson MI (Initially Remote Role) Contract: 6+months
Job Description:
Candidate will responsible for the data integration and data transformation using Azure, setting up Azure Synapse Analytics, design, documentation, development, unit testing, and support of Data Integration.
Must have hands-on experience in APIm, azure service Bus,Azure logic app and azure event grid.
Hand-on experience on azure data factory
Must have worked on azure cloud based IOT solution which delivery highly secure and reliable communication between Internet of Things (IoT) application and the devices it manages
M the concept of azure IOT multitenant services that exposes its functionality to various actor.
Know how to setup bidirectional communication with IOT devices
Must be aware of terms like TLS & its other version.
Must have done configuration of IOT hub to use TLS 1.2
Good knowledge of ETL process, OLAP and OLTP
Advanced knowledge of T-SQL including complex SQL queries (ex: using various joins and sub-queries) and best practices
Experience integrating data from structured and unstructured formats: flat files, XML, EDI, JSON, EXCEL
Working knowledge and experience in Cloud based online transactional (OLTP) processing and analytical processing (OLAP) databases and schemas
