Azure Data Architect Lead

Hi, We are looking for Azure Data Architect. Interested can send their profiles to manikandan.g@itcinfotech.com mentioning Current CTC, Expected CTC, Notice period to join.

Experience in Order to Cash Process (O2C), Oracle

Workflow, Procure to Pay, Rights and Royalties. Experience in Azure

Cloud, Azure Data Factory, Azure synapse analytics, Azure Databricks, Azure

Storage, Snowflake, Azure key vault, Continuous Integration, and Delivery (CI / CD).

Experience on Migrating SQL Database to Azure Data Lake, Azure

SQL Database, Controlling and granting Database access. Migrating On

premise databases to Azure Data Lake raw zone store using Azure Data factory /

Azure Synapse and Transform the data in Databricks notebook / synapse

notebook to store in curation zone.

Direct Client Interaction for Requirement gathering, analysis and developed

Functional Design based on business requirement; Having hands on experience

working with MSSQL complex queries and stored procedures. Development and

enhancement in SSIS jobs

Develop shell scripts, SSMS scripts, PL / SQL package, MSSQL complex queries,

stored procedures and C# code. Creating interfaces for royalty payments using

technical expertise in Oracle, Tibco, Aptify, Microsoft SQL Server, Visual Studio C#,

Internet Information Service.

Contribution in automation of crucial business processes for Business users

by helping the Automation team in end-to-end business processes. Analytical,

methodical, and resourceful approach to design system requirements, bug fixing,

identifying root cause and corrective actions to meet short and long-term

business goals.

Working as Solution Architect for the current project. Created High level Design

(HLD) and presented to Architectural Review Board to finalize the project. Also to

create LLD for architectural perspective to develop the project.

Conducting Personalization Sessions for business understanding, gathering

requirement for customizations and then solution development.

Provide demo of design and demo of done to client’s program manager and

product owner, highlighting the effectiveness and value.

Create SCD type 2, SCD type 1 data ingestion technic for dimension tables.

Designed and implemented complex data models aligned with business

requirements, optimizing for cost efficiency and enhanced performance

Designed and deployed real-time and batch processing solutions, ensuring

efficient data ingestion and transformation workflows.

Several initiatives have been taken from organization level as well as project

account level on different value-added services and POCs on Azure Databricks,

Microsoft fabric, Databricks GenAI.

Mentoring approx. 50+ Associates who are switching from other technology,

and 100+ junior resources on Azure Data Engineering technology from organization.