Data Warehouse Developer – Databricks (Residential & MSR Domain)

Role Overview

An experienced Data Warehouse Data Engineer with solid expertise in Databricks Lakehouse architecture to join the Mphasis Data Platform team.

The role focuses on designing, developing, and optimizing data pipelines, data models, and governance frameworks for Residential (Resi) & Mortgage Servicing Rights (MSR) data warehouse initiatives. The ideal candidate combines strong Databricks engineering skills with valuable to have on mortgage data domain knowledge, and can collaborate with cross-functional teams to deliver high-quality, governed, and scalable solutions. Note that the Databricks flavor used in Azure Databricks

Key Responsibilities

Data Ingestion & Processing
Develop scalable, metadata-driven ingestion pipelines using PySpark / Spark SQL in Databricks.
Automate batch and streaming ingestion from servicer files and internal systems.
Handle structured/unstructured data (loan tapes, CSV, JSON, parquet, Delta Lake).
Data Modeling & DWH Build




Design and implement canonical data models aligned to MISMO standards.
Build fact and dimension tables in Delta Lake with SCD handling, partitioning, Z-ordering, and performance tuning.
Ensure model extensibility for multiple servicers and future MSR enhancements.
Optimization & Performance
Optimize pipelines for performance and cost (DBU management, caching, cluster configs, partition strategies).
Implement job monitoring, logging, and ing for proactive issue resolution.
Collaboration & Delivery
Work with Data Architects, Governance Officers, and Business Analysts to align technical delivery with business rules.
Follow CI/CD practices (Dev → QA → Prod migration) using Databricks Repos, GitHub, and Azure DevOps.
Participate in code reviews, design walkthroughs, and audits to ensure compliance with standards.

Technical skills
5–10+ years of experience in Data Engineering / DWH development.
Hands-on experience with Databricks (PySpark, Delta Lake

📌 Module Lead (Hyderabad)
🏢 Mphasis
📍 Hyderabad