Sr Azure Synapse Developer

Hi,

We are having opening for the position of Sr Azure Synapse Developer.

Looking for immediate joiners to 1 month notice period

Mode of interview - Face 2 Face

Work mode - Work from office

Job Summary

Provide technical guidance to functional area and partnering areas e.g. system, program, product or sales for internal, external or both. Collaborate with a customer and team (i.e internal and/or external) to ensure projects are completed effectively and efficiently. Implement and coordinate pipelines & policies. Conduct ongoing evaluations to ensure effectiveness of programs and recommends modifications as necessary.

Role and Responsibilities

- Design and develop Azure Synapse Pipelines from scratch based on business requirements.
- Analyze existing report queries and database procedures/functions in SQL Server and optimize for better performance. - Enhance and optimize Synapse Pipelines to ensure high data quality and performance. - Implement job dependencies and workflow orchestration to ensure seamless data integration. - Develop and customize ETL/ELT processes for data extraction and transformation using big data technologies (Spark Pool, SQL Pool, etc. - Create data mapping documentation, transformation rules, and selection criteria for data processing. - Implement and configure transformation logic, field mappings, and value structures. - Evaluate data quality within Data Warehouses/Data Marts and recommend improvements. - Manage source code control, Pull Requests, and Code Reviews to ensure code quality and collaboration.

- Core responsibilities: Design & Development, Data Integration, ETL/ELT Processes, Data Modeling & design, Performance Optimization, Data Quality, version management.

- Communication: Excellent communication and collaboration skills for working with diverse teams.

- Problem-Solving: Strong problem-solving and troubleshooting skills to address challenges in data pipelines and solutions.

Qualifications and Education Requirements

Bachelor's degree preferred. Engineering Computer science

Looking for immediate joiners

Experience: 5 to 8 years' experience- 5 years of experience in Data Warehouse development with at least 3 years in Azure Synapse, SQL Data Warehouse, or Dedicated SQL Pool.

Skills

- 5 years of experience in Data Warehouse development.

-Minimum 3 years in Azure Synapse, SQL Data Warehouse, or Dedicated SQL Pool.
- Experience in designing STAR Schema (Type 1, Type 2, Role-Playing Dimensions, Facts) and implementing pipelines in at least two projects. - Strong ability to communicate technical concepts to business teams using business language. - Proficiency in Azure DevOps for CI/CD pipeline management.

-Azure Synapse Analytics:

Deep understanding and hands-on experience with Azure Synapse, including Pipelines, SQL Pools, and Spark Pools.

Data Modeling:

Strong knowledge of data modeling principles and experience with relational and dimensional modeling.

ETL/ELT:

Experience with ETL/ELT processes, including data extraction, transformation, and loading.

SQL:

Strong SQL skills for querying and manipulating data within Synapse SQL Pools.

Python/PySpark:

Experience with Python and PySpark for data processing and transformation tasks, particularly within Spark Pools.

Data Storage:

Understanding of Azure data storage solutions like Azure Blob Storage and Azure Data Lake Storage.

Note for HR

1. Please look at the below points (Synapse is Mandate)
1. 5 to 8 years Exp in Azure Synapse, SQL development.

2. Primary Skills

   : Azure Synapse, SQL, data Warehouse

3. Secondary Skills:

   SSIS, ADF.