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 pipelines using Azure Data Factory (ADF)
• Orchestrate and monitor data workflows, ensuring reliability, performance, and error handling
• Implement\ 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

 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 pipelines for 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 pipelines using Azure Data Factory (ADF)
• Orchestrate and monitor data workflows, ensuring reliability, performance, and error handling
• Implement\ 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

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, or 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.