Description

• Seasoned Data Warehousing professional
• Extensive experience in implementing large DW solutions
• Understanding and hands-on experience with transformation of legacy DW solutions to cloud
• Big data technology evolution and its adoption
• Expert level knowledge of SQL (who can guide teams)
• Expert level knowledge of ETL & ELT tools, real-time streaming, Azure/ AWS Data Stack, Databricks, Dremio.
· Experience working with Azure Services like Azure Data Factory, Logic App, Functions, Azure SQL DB, Blob Storage, Azure DevOps.
· Experience working with other Azure Services like Azure Database Migration Service, ADLS Gen2, Synapse Analytics is an added advantage.
· Experience creating Azure Data Factory pipelines leveraging Data Movement activities, Data Transformation activities like Data Flow, Stored Procedure, Custom Activity, Azure Functions etc. and Control Flow Activities like web activity, lookup activity etc.
· Experience working with RDBMS preferably Azure SQL, Microsoft SQL Server.
· Proficient in SQL, Transact-SQL and experience in developing Stored procedures.
· Experience in any programming language, preferably C#, Python.
· Experience in AI/ML, Gen AI stack like Azure Open AI or Gemini.
· Must have expert level knowledge of Key Vault for application security for data in transit and rest.
· Implementing Azure authentication and securing data on the cloud using Key Vaults and Entra ID
· Good knowledge of Agile, DevOps delivery methodologies.
· Advanced understanding of data integration, data virtualization, data federation, and database design techniques.
· Advanced knowledge of dimensional modeling, modeling for reporting applications, normalization techniques, forward-engineering, and reverse-engineering techniques.
· Knowledge of various process modeling techniques (activity hierarchy diagrams, data flow diagrams, sequence diagrams, workflow diagrams, system interface diagrams)
• Experience in maintaining a comprehensive chronological trail of solution footprint and agreements and actively contribute to the technology stream of the project change control process

Key Skills

Education

Bachelor's degree