Zensar

Global IT services for digital transformation

Data Engineer

Data EngineeringConfirmed live in the last 24 hours

Full-timeIndiaNo salary listedIn-person

About the Job

Requirements

At least 6 years of hands-on data engineering experience in SQL-heavy or enterprise data environments.
Deep expertise in Microsoft SQL Server and advanced T-SQL development, including query optimization.
Practical experience with Microsoft Fabric, Lakehouse architecture, and Delta Lake.
Proficiency in Spark, preferably PySpark, and Python notebooks for distributed data transformation.
Experience with Azure Data Factory, Databricks, Azure Analysis Services, ADLS Gen2, and Purview.
Strong knowledge of dimensional modeling (Kimball) and semantic model design for Power BI.
Proven ability to implement incremental loading and CDC patterns in hybrid environments.
Familiarity with CI/CD pipelines, testing frameworks, monitoring, and data governance principles.
Background in financial services, banking, or capital markets.
Microsoft certifications in Azure Data Engineer or Fabric.
Excellent facilitation, presentation, and influencing skills.

Responsibilities

Build and maintain bronze, silver, and gold lakehouse layers in Microsoft Fabric and Databricks.
Develop ingestion and transformation pipelines using notebooks and PySpark.
Implement incremental loading and change data capture from on-premises SQL to Fabric or Databricks.
Optimize Delta tables for performance and cost efficiency.
Create and sustain Azure Data Factory pipelines and Azure Analysis Services cubes.
Own data products as managed assets through version control, testing, monitoring, and continuous improvement.
Ensure datasets comply with defined data contracts, governance, and platform standards.
Collaborate with business stakeholders, analysts, and the central Data Platform team.
Design and optimize semantic models for enterprise analytics platforms such as Power BI.
Mentor junior engineers and champion architectural standards and modern technologies.

Zensar Technologies Limited is seeking a highly skilled Data Engineer to engineer and deliver Finance (Capital & Tax) domain‑aligned data products within a centrally governed Microsoft Data Platform. You will modernize legacy SQL workloads into scalable Spark‑based Lakehouse datasets, manage ADF pipelines, Databricks notebooks, and Azure Analysis Services cubes, and ensure data products are version‑controlled, tested, monitored, and continuously improved.

6+ years of hands‑on data engineering experience in SQL‑heavy or enterprise data environments.
Deep expertise in Microsoft SQL Server and advanced T‑SQL development, including query optimization.
Practical experience with Microsoft Fabric, Lakehouse architecture, and Delta Lake.
Proficiency in Spark (PySpark preferred) and Python notebooks for distributed data transformation.
Experience with Azure Data Factory, Databricks, Azure Analysis Services, ADLS Gen2, and Purview.
Strong knowledge of dimensional modeling (Kimball) and semantic model design for Power BI.
Proven ability to implement incremental loading and CDC patterns in hybrid environments.
Familiarity with CI/CD pipelines, testing frameworks, monitoring, and data governance principles.
Background in financial services, banking, or capital markets.
Microsoft certifications (Azure Data Engineer, Fabric) and excellent facilitation, presentation, and influencing skills.

Build and maintain bronze, silver, and gold lakehouse layers in Microsoft Fabric and Databricks.
Develop ingestion and transformation pipelines using notebooks and PySpark.
Implement incremental loading and change data capture (CDC) from on‑prem SQL to Fabric/Databricks.
Optimize Delta tables for performance and cost efficiency.
Create and sustain Azure Data Factory pipelines and Azure Analysis Services cubes.
Own data products as managed assets: version control, testing, monitoring, and continuous improvement.
Ensure datasets comply with defined data contracts, governance, and platform standards.
Collaborate with business stakeholders, analysts, and the central Data Platform team.
Design and optimize semantic models for enterprise analytics platforms such as Power BI.
Mentor junior engineers and champion architectural standards and modern technologies.

About the Company

Zensar

Global IT services for digital transformation

Digital solutions and IT services company that partners with global organizations to drive digital transformation. Its offerings include intelligent automation, analytics, hyperconverged infrastructure, and digital application development and maintenance, delivered through long-term contracts, project-based engagements, and managed services. Indigo Slate handles virtual event creation. Zensar’s Living AI integrates artificial intelligence into business processes to boost outcomes. Unlike many competitors, it emphasizes reducing capital expenditure (Capex) and operating expenditure (Opex), simplifying vendor management, and improving efficiency through automation. The overall goal is to help clients adapt to the digital landscape, optimize technology infrastructure, and achieve higher operational efficiency.

Company size: 10,001+
Company stage: IPO
Headquarters: Pune, India
Founded: 1991

Recently Posted Jobs

Explore more opportunities at Zensar

See more jobs