Azure Data Engineer

Weekday AI; Mumbai; On-site; INR 500,000 - 1,800,000; Full time

Job summary

Weekday AI in Mumbai, India is seeking an experienced Azure Data Engineer to design, build, and maintain scalable data integration solutions using Azure Data Factory, SSIS, and SQL Server. Collaborate with data analysts, architects, and engineers to deliver reliable cloud-based data platforms.

The role emphasizes ETL/ELT development, data quality, production support, and migration of on‑prem workloads to Azure, with a focus on pipelines, datasets, and governance.

Qualifications

• 5+ years of professional experience in data engineering or ETL.
• Strong hands-on expertise with Microsoft Azure, ADF, and SSIS.
• Proven design and development of complex ADF pipelines and ETL workflows.
• Experience migrating ETL workloads to Azure cloud.
• Excellent SQL development and data warehousing knowledge.

Responsibilities

• Design, develop, and maintain scalable Azure data pipelines using ADF.
• Build and manage ETL/ELT workflows from multiple sources.
• Develop, enhance, and support SSIS packages for enterprise integration.
• Create ADF pipelines, datasets, linked services, triggers, and integration workflows.
• Monitor production pipelines and resolve data integration issues.
• Collaborate with Data Architects, Analysts, and stakeholders; ensure governance.

Skills

Azure Data Factory

SSIS

SQL

ETL Design

Data Pipelines

Azure Synapse

Azure SQL Database

Education

Bachelor's degree in CS/IT/Engineering

Tools

SQL Server

Azure Data Factory

SSIS

Azure Synapse

Azure DevOps

Git

Job description

This role is for one of the Weekday's clients

Salary range: Rs 500000 - Rs 1800000 (ie INR 5-18 LPA)

Experience: 5+ yrs

Location: Mumbai, Maharashtra, India

Job Type: Full-time

We are looking for an experienced Azure Data Engineer with strong expertise in Microsoft Azure, Azure Data Factory (ADF), and SQL Server Integration Services (SSIS) to design, develop, and maintain scalable data integration and processing solutions.

The ideal candidate will have strong hands‑on experience building data pipelines, integrating diverse data sources, transforming and processing large datasets, and supporting modern cloud‑based data platforms. You will work closely with data analysts, architects, developers, business stakeholders, and other engineering teams to deliver reliable and high‑quality data solutions.

The role requires a strong understanding of data engineering principles, ETL/ELT processes, cloud technologies, data integration, SQL, and production support.

Requirements

Key Responsibilities

• Design, develop, and maintain scalable Azure data pipelines using Azure Data Factory.
• Build and manage ETL/ELT workflows for extracting, transforming, and loading data from multiple sources.
• Develop, enhance, and support SSIS packages for enterprise data integration.
• Create ADF pipelines, datasets, linked services, triggers, parameters, and integration workflows.
• Integrate data from SQL Server, databases, files, APIs, cloud applications, and other enterprise systems.
• Develop complex SQL queries, stored procedures, views, functions, and data transformation logic.
• Support migration of on‑premise ETL workloads and SSIS processes to Azure‑based data platforms.
• Implement incremental data loads, scheduling, dependency management, error handling, and retry mechanisms.
• Monitor production pipelines and proactively identify and resolve data integration failures.
• Troubleshoot performance, data quality, connectivity, and pipeline execution issues.
• Optimize ADF pipelines, SSIS packages, SQL queries, and data processing workloads.
• Implement data validation, reconciliation, and quality checks across data pipelines.
• Collaborate with Data Architects, BI Developers, Analysts, Software Engineers, and business stakeholders.
• Support deployment across development, testing, and production environments.
• Maintain technical documentation for pipelines, mappings, data flows, dependencies, and operational procedures.
• Follow data security, governance, access‑control, and development standards.
• Use Git and modern CI/CD practices to manage data engineering code and deployments.
• Contribute to automation, process improvements, and modernization of existing data platforms.

What Makes You a Great Fit

• 5+ years of professional experience in data engineering, ETL development, data integration, or a related field.
• Strong hands‑on expertise in Microsoft Azure, Azure Data Factory, and SSIS.
• Proven experience designing and developing complex ADF pipelines and ETL/ELT workflows.
• Strong experience with SSIS package development, deployment, troubleshooting, and optimization.
• Excellent knowledge of SQL Server and advanced SQL development.
• Experience with stored procedures, views, functions, joins, performance tuning, and query optimization.
• Strong understanding of data warehousing concepts, dimensional modelling, ETL architecture, and data integration patterns.
• Experience integrating data from relational databases, flat files, APIs, and cloud‑based sources.
• Practical experience migrating or modernizing traditional ETL workloads to Azure.
• Familiarity with Azure services such as Azure SQL Database, Azure Blob Storage, ADLS, Synapse Analytics, or Databricks is an advantage.
• Experience with Git, CI/CD, Azure DevOps, and deployment automation is preferred.
• Strong troubleshooting, analytical, and problem‑solving skills.
• Good understanding of data quality, security, governance, and production support practices.
• Strong communication and collaboration skills with technical and business stakeholders.
• Ability to manage multiple priorities and independently own data engineering deliverables.
• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related discipline is preferred.