Azure Data Architect

Position: Azure Data Architect

Location: NY/NJ (Day1 Onsite)

Duration: Long-term

Responsibilities:

Azure Service:-

1. Must have hands on -

1. Databricks

2. Azure Data Factory - ETL

3. Cosmos DB

4. Azure Cognitive Search = Plus point to have

2. Logic App

3. Function App

4. Azure Blob Storage - Gen1 , Gen2

Programming Language:-

1. Knowledge and Hands on - Python, PySpark, Spark SQL, Big Data Hadoop system.

2. SQL Procedure, T-SQL

3. No-SQL - Cosmos DB

Database/Warehouse Concepts

• Have very good experience with ETL frameworks and tools on Cloud platforms using Azure Data Factory with SQL or Python.
• Very good experience in understanding data life cycle and data software development, data engineering with SQL in a Data Warehouse environment, building data pipelines and complex data transformations as well using Relational & NoSQL databases, open data formats, and programming languages such as Python.
• Ability to use one or more of the following tools for data hunting, testing, analytics, and metrics such as SQL IDE's, and analytics tools such as Power BI or similar tool.
• Implemented Surrogate key by using Key Management functionality for newly inserted rows in Data warehouse which made data availability more convenient.
• Very good understanding and implementation experience with dimensions and fact table designs.
• Participated in the identification of key performance indicators and methods for data warehouse to assist with operational and strategic planning.
• Installed, developed, and maintained a variety of applications to support business intelligence products, data warehouses and reporting systems.
• Designed and implemented daily data migration between central data warehouse server and application/reporting database server and analyst database server.