Azure Data Factory Lead - Python Programming

6 years

0 Lacs

Posted:3 weeks ago| Platform: Linkedin logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

Job Title :

Lead ADF - Microsoft BI & Data Warehouse Lead

Skills :

Minimum 6+Years into

ADF in ETL

, Microsoft BI, DW, T-SQL / SQL, procedure writing, Azure/SQL

Overview

We are looking for an experienced Microsoft BI & Data Warehouse Lead to design, develop, and maintain robust data warehouse and ETL solutions using the Microsoft technology stack. The ideal candidate will have extensive expertise in SQL Server development, Azure Data Factory (ADF), and other Microsoft-based data integration tools such as Azure Functions, and other related tools.As a lead, he will play a crucial role in driving data strategy, ensuring system performance, and delivering scalable data solutions that meet organizational needs.

Responsibilities

Data Warehouse Development :
  • Design and implement scalable and efficient data warehouse solutions.
  • Develop complex SQL Server-based solutions, including T-SQL queries, stored procedures, and performance tuning.
  • Optimize SQL Server databases, develop T-SQL scripts, and improve query performance.

ETL Development And Maintenance

  • Build and optimize ETL workflows using Azure Data Factory (ADF) for data integration from multiple sources.
  • Ensure high-performance data pipelines for large-scale data processing.
  • Integrate and automate data processes using Azure Functions to extend ETL capabilities.

Cloud Integration

  • Implement cloud-native solutions leveraging Azure SQL Database, Azure Functions, and Synapse Analytics.
  • Support hybrid data integration scenarios combining on-premises and Azure services.

Data Governance And Quality

  • Establish and maintain robust data quality frameworks and governance standards.
  • Ensure consistency, accuracy, and security of data across all platforms.

Leadership And Collaboration

  • Lead a team of BI and data professionals, providing mentorship and technical direction.
  • Partner with stakeholders to understand business requirements and deliver data-driven solutions.
  • Define project goals, timelines, and resources for successful execution.
  • Should be flexible to support multiple IT platforms
  • Managing Day to day activities - Jira request, SQL execution, access request, resolving alerts and updating Tickets

Requirements

Education : Bachelors degree in computer science, Information Technology, or related field. B.Tech / B.ESkills (Mandatory) (Note : list of skills needed to perform the role) :
  • Strong experience with SQL Server development (T-SQL, indexing, optimization).
  • In-depth knowledge of BI-DW concepts and data modelling.
  • Extensive experience with Azure Data Factory (ADF) for ETL tools
  • Advanced knowledge of Azure SQL Database and cloud technologies.
  • Excellent problem-solving, analytical, and leadership skills.
  • Strong communication and teamwork abilities.
  • Ability to translate business requirements into technical solutions
  • Experience with cloud-based data platforms and migrations.
  • Familiarity with DevOps for CI/CD in data integration pipelines.
  • Skills (Good to Have) (Note : list of skills that will add value to the role) :
  • Experience with additional cloud platforms (e.g., Azure, AWS, Google Cloud).
  • Advanced skills in data visualization tools (e.g., Power BI, SSRS, Tableau).
  • Proficiency in Python or other scripting languages.
  • Experience with Databricks is a plus.

Certifications

  • Relevant certifications in SQL, BI-DW, or cloud platforms are highly desirable.
  • Microsoft Certified : Azure Data Fundamentals /Any Cloud Certifications (preferred).
Skills (Mandatory) (Note : list of skills needed to perform the Lead role) : Client Facing - US Based Clients - Need Strong Communication skill
(ref:hirist.tech)

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now

RecommendedJobs for You