DEandA - Core - Advanced Visualization And Cloud Reporting - Azure Analysis Services

Zensar Technologies; Pune District; On-site; INR 1,800,000 - 2,400,000; Full time

Job summary

Zensar Technologies is seeking a Data Integration & Middleware Engineer Lead to design, orchestrate, and optimize scalable data pipelines on Azure. You will work across ADF, Blob Storage, and Azure SQL to deliver high-quality data and reliable ETL processes.

The role emphasizes data governance, performance tuning, cost optimization, and collaboration with cross-functional teams to support on-premise and cloud integrations.

Qualifications

• Strong experience with Azure Data Factory for orchestration.
• Hands-on ETL/ELT development experience.
• Experience with Azure Blob Storage/Data Lake.
• Proficiency in Azure SQL Database / SQL Server.
• Understanding of data warehousing concepts and data modeling.
• Knowledge of DevOps, CI/CD pipelines for data workflows.

Responsibilities

• Manage end-to-end data integration pipelines using Azure Data Factory (ADF).
• Orchestrate and monitor data workflows, ensuring reliability, performance, and error handling.
• Implement and manage ETL/ELT processes for data ingestion, transformation, and loading.
• Manage and optimize data storage solutions using Azure Blob Storage.
• Maintain structured data models in Azure SQL Database / Azure DB.
• Ensure data quality, validation, and governance across pipelines.
• Support integration with on-premise and cloud-based systems.
• Perform performance tuning and cost optimization across the data platform.

Skills

ADF orchestration

ETL/ELT development

Azure Blob Storage

Azure SQL/SQL Server

Data warehousing & modeling

DevOps CI/CD for data

Data governance & security

Azure Databricks

Synapse Analytics

Tools

Azure Databricks

Synapse Analytics

Job description

Job Description:

Role Overview

We are seeking a skilled Data Integration & Middleware Engineer Lead to implement and manage scalable data pipelines and middleware solutions. The role will focus on orchestrating data workflows using Azure technologies such as Azure Data Factory (ADF), Azure Blob Storage, and Azure SQL Database, ensuring efficient ETL/ELT processing and high-quality data delivery.

Key Responsibilities

• Manage end-to-end data integration pipelinesusing Azure Data Factory (ADF)
• Orchestrate and monitor data workflows, ensuring reliability, performance, and error handling
• Implement\ Manage ETL/ELT processesfor data ingestion, transformation, and loading
• Manage and optimize data storage solutionsusing Azure Blob Storage
• Maintain structured data modelsin Azure SQL Database / Azure DB
• Ensure data quality, validation, and governanceacross pipelines
• Support integration with on-premise and cloud-based systems
• Perform performance tuning and cost optimizationacross the data platform

Technical Skills Required

Core Skills – Must Have

• Strong experience with Azure Data Factory (ADF)for orchestration
• Hands-on experience with ETL/ELT development
• Experience with Azure Blob Storage / Data Lake
• Proficiency in Azure SQL Database / SQL Server
• Understanding of data warehousing concepts and data modeling
• Knowledge of DevOps, CI/CD pipelinesfor data workflows

Nice to Have

• Experience with Azure Databricks or Synapse Analytics
• Knowledge of data pipeline optimization and monitoring
• Familiarity with API integrations and data connectors
• Exposure to data governance and security practices
• Azure certifications (e.g., AZ-900, DP-203)
• Experience with real-time data processing frameworks(Event Hub, Service Bus)

Soft Skills

• Strong analytical and problem-solving abilities
• Clear communication and stakeholder management skills
• Ability to work in a collaborative, cross-functional environment
• Attention to detail and commitment to data quality

Responsibilities

Key Responsibilities

• Manage end-to-end data integration pipelinesusing Azure Data Factory (ADF)
• Orchestrate and monitor data workflows, ensuring reliability, performance, and error handling
• Implement\ Manage ETL/ELT processesfor data ingestion, transformation, and loading
• Manage and optimize data storage solutionsusing Azure Blob Storage
• Maintain structured data modelsin Azure SQL Database / Azure DB
• Ensure data quality, validation, and governanceacross pipelines
• Support integration with on-premise and cloud-based systems
• Perform performance tuning and cost optimizationacross the data platform

Qualifications

Lead and Support Engineer

At Zensar, we’re "experience-led everything". We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: "Together, we shape experiences for better futures". Whether for our clients, our people, and the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus.

Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensar and join us to Grow. Own. Achieve. Learn. to be the best version of yourself.

We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.

Requirements: