About this role
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.