Cynet Systems
Azure Data Engineer
Cynet Systems, Jackson, Wisconsin, United States, 53037
Job Description:
Mandatory Skills:
Candidate will be 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.dvanced 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.Experience with TDD/BDD.Know device communication pattern.
Mandatory Skills:
Candidate will be 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.dvanced 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.Experience with TDD/BDD.Know device communication pattern.