What you will do?

The future is being built today, and Johnson Controls is making that future more productive, secure and sustainable. We are harnessing the power of cloud, data analytics, the Internet of Things, and user design thinking to deliver on the promise of intelligent buildings and smart cities that connect communities in ways that make people’s lives – and the world – better & safer.

Data & Analytics CoE is a diverse team of technology enthusiast enabling our global business. JCI has embarked on a Data strategy that focuses on establishing strong technology CoE, enterprise data management & cloud based business solutions. Technical Architect (Ingestion / ETL) is an integral part of Technical Architecture team.  This role will be based out of India, reporting into ETL Technical Architect - Data & Analytics.

This role will be responsible for creating Data orchestration with Azure Data Factory Pipelines & Dataflows. Key role is to understand the business requirements and implement the requirements using Azure Data Factory, utilizing & enriching our framework.

How you will do it?

• Understand business requirement and actively provide inputs from Data perspective

• Understand the underlying data and flow of data

• Build simple to complex pipelines & dataflows via our framework

• Work with other Azure stack modules like Azure Data Lakes, SQL DW, etc.

• Should be able to implement modules that has security and authorization frameworks

• Recognize and adapt to the changes in processes as the project evolves in size and function

What we look for?

• Bachelor of Science degree and/or Masters in Software Engineering / Computer Science or an equivalent discipline

• 3 – 5 yrs of hands on experience using various development methodologies to deliver robust PaaS and DaaS based analytics solutions using Azure Cloud technologies Azure Data Factory, HD Insights, Azure Data bricks,  SSIS and other ETL tools

• Strong knowledge of Hadoop, MPP Data platform, Azure Data Factory, Azure HDI, Power BI and Open source technologies, Azure Analysis Service, DAX, and Advanced Cube design techniques

• Candidates should be flexible / willing to work across this delivery landscape which includes and not limited to Agile Applications Development, Support and Deployment.

• Expert level experience with Azure Data Lake, Azure Data Factory, Synapse Azure Blob, Azure Storage Explorer

• Proficient in creating Data Factory pipelines for on-cloud ETL processing; copy activity, custom Azure development etc.

• Knowledge of Azure Data Catalog, Event Grid, Service Bus, SQL and Synapse

• Good technical knowledge in SQL Server BIsuite (ETL, Reporting, Analytics, Dashboards) using SSIS, SSAS, SSRS, Power B

​

Technology Requirement

• ETL/ELT Tools: Azure Data Factory, SSIS, Azure Data Bricks, SAP BODS, Informatica

• Azure HDInsight, Synapse Analytics, Access and Security Management 

• DevOps: GitHub, Azure DevOps

• ETL/ELT Framework design and implementation

• Object Oriented Programing skills using Java, Python, and .Net

Essential Skills

• Strong Leadership, organizational, and prioritization skills

• Excellent written and verbal skills to communicate technical solutions to business teams

• Demonstrated experience leading and influencing individuals and teams without formal organizational control

• Understanding trends, new concepts, industry standards and new technologies in Data and Analytics space

• Ability to work with global distributed teams