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 factoryMust 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 managesM the concept of azure IOT multitenant services that exposes its functionality to various actor.Know how to setup bidirectional communication with IOT devicesMust be aware of terms like TLS & its other version.Must have done configuration of IOT hub to use TLS 1.2Good knowledge of ETL process, OLAP and OLTPAdvanced knowledge of T-SQL including complex SQL queries (ex: using various joins and sub-queries) and best practicesExperience integrating data from structured and unstructured formats: flat files, XML, EDI, JSON, EXCELWorking knowledge and experience in Cloud based online transactional (OLTP) processing and analytical processing (OLAP) databases and schemasExperience with TDD/BDDKnow device communication pattern