Azure Data Architect

Azure Data Architect This role will be responsible for Designing and creating Data Ingestion solution with Azure Data Factory Pipelines Dataflows. Key role is to understand the business requirements and design an ingestion system from scratch using Azure Data Factory, Azure Synapse and Other Azure Services. Roles Responsibilities : - Understand business requirement and actively provide inputs from Data perspective - Understand the underlying data and flow of data. - Provide solution design and architecture diagrams - Creating the data ingestion framework using Azure Services - Build simple to complex pipelines dataflows. - 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. Knowledge, Skills Abilities : - Minimum 10 years+ Expert level hands on experience in designing implementing data ingestion solution using Azure Data Factory, Blob Storage/ADLS Gen2, Azure function app, logic app, Azure Synapse - Expert knowledge of DBMS and ETL/ELT concepts , T-SQL, hands on experience on writing complex stored procedures and function - Should be able to analyze and understand complex data - Hands on experience of Azure Services like Azure Monitor, Alerts, App Insights - Hands on Experience in Microsoft SQL Server SSIS - Hands on Experience in .Net/C# - Knowledge of master data management, data warehousing and business intelligence architecture. - Experience in database design with excellent knowledge of on-prem to cloud database migration best practices. - Excellent interpersonal/communication skills (both oral/written) with the ability to communicate at various levels with clarity precision. - Should have clear understanding of DW lifecycle and contribute in preparing Design documents, Unit Test plans, Code review reports. - Experience working in Agile environment (Scrum, Lean, Kanban) is a plus - Knowledge of Azure CI/CD is a plus.