JD: Data Modeler – Databricks Delta Lake / Lakebase & Oracle Cloud Migration

Role Overview

We are seeking an experienced Data Modeler with strong expertise in designing, optimizing, and governing enterprise data models for modern cloud data platforms. The ideal candidate will have hands-on experience creating scalable and performance-optimized data models in Databricks Delta Lake, Lakehouse architectures, and/or Lakebase databases, along with experience migrating data platforms from on-premises Oracle databases to cloud-based databases and analytics platforms.

This role requires a strong understanding of data architecture, dimensional modeling, relational modeling, data lakehouse design patterns, and performance optimization techniques for large-scale data processing and analytics workloads

Key Responsibilities

- Design, develop, and optimize conceptual, logical, and physical data models for enterprise data platforms.
- Create scalable and high-performance data models in Databricks Delta Lake, Databricks Lakehouse, and/or Lakebase database environments.
- Translate business requirements into well-structured data models that support analytics, reporting, operational, and AI/ML use cases.
- Optimize data structures for performance, scalability, maintainability, and cost efficiency.
- Design and implement modeling patterns for:

o Bronze, Silver, and Gold layers o Curated data marts o Dimensional models o Data vault models o Star and snowflake schemas o Operational and analytical data stores o Support migration initiatives from on-premises Oracle databases to cloud platforms such as Databricks, Snowflake, Azure SQL, Synapse, PostgreSQL, or other cloud-native databases.

o Analyze legacy Oracle schemas, stored procedures, views, indexes, constraints, and data relationships to support modernization and migration planning.





o Define mapping specifications, transformation rules, and target-state models for cloud migration.

o Work closely with data architects, data engineers, DBAs, business analysts, and application teams to ensure data models align with enterprise standards.

o Establish data modeling standards, naming conventions, metadata definitions, and documentation practices.

o Review existing data models and recommend improvements for performance, usability, governance, and business alignment.

o Partner with data engineering teams to ensure models are implemented efficiently using Delta tables, partitions, clustering, Z-ordering, indexing alternatives, and other optimization techniques.

o Support data governance, data lineage, metadata management, and data quality initiatives.

o Participate in architecture reviews and provide recommendations on database modernization, cloud migration, and lakehouse modeling best practices.

Required Qualifications

- 8+ years of experience in data modeling, data architecture, or database design.
- Strong experience designing enterprise-scale logical and physical data models.
- Hands-on experience with Databricks Delta Lake, Lakehouse architecture, or similar modern cloud data platforms.
- Experience designing optimized models for large-volume datasets and analytics workloads.
- Strong understanding of Oracle database structures, including schemas, tables, views, indexes, constraints, partitions, PL/SQL,



and stored procedures.
- Experience supporting migration from on-premises Oracle databases to cloud databases or cloud data platforms.
- Solid knowledge of:

o Relational modeling o Dimensional modeling o Normalized and denormalized data structures o Star and snowflake schemas o Slowly changing dimensions o Data lakehouse design patterns o Experience with SQL performance tuning and query optimization.

o Ability to analyze existing data models and recommend modernization or optimization strategies.

o Experience working with large-scale batch and near-real-time data pipelines.

o Strong documentation skills, including data dictionaries, entity relationship diagrams, source-to-target mappings, and modeling standards.

o Strong communication skills with the ability to engage both technical and business stakeholders.

Preferred Qualifications

- Experience with Databricks Unity Catalog, Delta Sharing, and metadata governance.
- Experience with Databricks Lakebase or cloud-native transactional/operational database capabilities.
- Experience with cloud platforms such as Azure, AWS, or GCP.
- Experience with Azure Data Factory, dbt, Informatica, Fivetran, or other ETL/ELT tools.
- Experience with data governance tools such as Microsoft Purview, Collibra, Alation, or Informatica EDC.
- Experience migrating workloads from Oracle to:

o Databricks Delta Lake o Snowflake o Azure SQL Database o Azure Synapse o PostgreSQL o MongoDB or other modern databases o Knowledge of healthcare, financial services, insurance, or other highly regulated industries is a plus.

o Familiarity with data quality, lineage, master data management, and metadata management practices.

o Experience supporting AI/ML-ready data products and feature engineering models.

📌 JD: Data Modeler – Databricks Delta Lake / Lakebase & Oracle Cloud Migration (Hyderabad)
🏢 HCL INDIA
📍 Hyderabad