Data Modeller

Ambiquest Hyderabad; Hyderabad, Pune District, Bengaluru; Hybrid; INR 2,500,000 - 4,000,000; Full time

Job summary

Ambiquest Hyderabad is seeking a Senior Data Modeler with 8+ years of experience in data modeling, data architecture, and cloud modernization. The role focuses on Databricks Delta Lake, Lakehouse patterns, and Oracle-to-cloud migrations for enterprise data platforms.

You will design conceptual to physical models, optimize data structures, and collaborate with data architects, engineers, DBAs, and analysts to deliver scalable, governed datasets across Bronze to Gold layers.

Qualifications

• Hands-on experience with enterprise data modeling and database architecture.
• Strong knowledge of Databricks Delta Lake/Lakehouse architecture.
• Proficiency in relational and dimensional modeling using Oracle databases.
• Strong SQL with performance tuning and large-volume analytics.
• Experience migrating on-premises Oracle to cloud platforms like Databricks, Snowflake, Azure SQL/Synapse, or PostgreSQL.

Responsibilities

• Design conceptual, logical, and physical data models for enterprise data platforms.
• Create scalable models using Delta Lake and Lakehouse architecture.
• Translate business requirements into structured data models for analytics and AI/ML use cases.
• Develop data models across Bronze, Silver, and Gold layers; implement Data Vault, Star and Snowflake schemas.
• Support Oracle-to-cloud migration and define source-to-target mappings and transformation rules.

Skills

Data Modeling

Databricks Delta Lake

Oracle Database

SQL

Data Architecture

Lakehouse Architecture

Cloud Migration

Databricks Lakebase

Unity Catalog

Snowflake

Azure SQL

Azure Synapse

PostgreSQL

Oracle-to-Cloud Migration

Tools

Databricks Lakebase

Unity Catalog

Snowflake

Azure SQL

Azure Synapse

PostgreSQL

Job description

Dear Candidates,

We have an urgent opening for Data Modeler role with one of our reputed clients.

Job Title: Senior Data Modeler Databricks Delta Lake & Oracle Migration

Experience: 8+ Years
Primary Skills: Data Modeling, Databricks Delta Lake, Oracle Database, SQL, Data Architecture, Lakehouse Architecture
Preferred Skills: Databricks Lakebase, Unity Catalog, Cloud Migration

Job Summary

We are looking for an experienced Senior Data Modeler with strong expertise in enterprise data modeling, database architecture, and cloud data platform modernization.

The ideal candidate should have hands-on experience designing conceptual, logical, and physical data models, with strong knowledge of Databricks Delta Lake, Lakehouse architecture, and relational and dimensional modeling.

The candidate should also have experience supporting migration initiatives from on-premises Oracle databases to modern cloud-based data platforms such as Databricks, Snowflake, Azure SQL, Synapse, or PostgreSQL.

Key Responsibilities

• Design, develop, and optimize conceptual, logical, and physical data models for enterprise data platforms.
• Create scalable and performance-optimized data models using Databricks Delta Lake and Lakehouse architecture.
• Translate business requirements into structured data models supporting analytics, reporting, operational, and AI/ML use cases.
• Design and implement data modeling patterns across Bronze, Silver, and Gold layers.
• Develop dimensional models, Data Vault models, Star Schema, and Snowflake Schema.
• Design curated data marts and operational and analytical data stores.
• Support migration initiatives from on-premises Oracle databases to cloud-based data platforms.
• Analyze legacy Oracle schemas, tables, views, indexes, constraints, partitions, PL/SQL, and stored procedures.
• Define source-to-target mappings, transformation rules, and target-state data models for cloud migration.
• Optimize data structures for performance, scalability, maintainability, and cost efficiency.
• Work closely with data architects, data engineers, DBAs, business analysts, and application teams.
• Establish data modeling standards, naming conventions, metadata definitions, and documentation practices.
• Review existing data models and recommend improvements for performance, usability, governance, and business alignment.
• Collaborate with engineering teams to optimize Delta tables using partitioning, clustering, Z-Ordering, and other performance optimization techniques.
• Support data governance, data lineage, metadata management, and data quality initiatives.
• Participate in architecture reviews and provide recommendations on database modernization and cloud migration best practices.

Mandatory Technical Skills

• Strong experience in Data Modeling and Data Architecture.
• Hands-on experience with Databricks Delta Lake / Lakehouse architecture or similar modern cloud data platforms.
• Strong knowledge of Relational Data Modeling and Dimensional Modeling.
• Experience designing conceptual, logical, and physical data models.
• Strong understanding of Oracle databases, including schemas, tables, views, indexes, constraints, partitions, PL/SQL, and stored procedures.
• Experience supporting Oracle-to-Cloud Database / Data Platform Migration.
• Strong knowledge of:
  
• Star Schema and Snowflake Schema
• Data Vault Modeling
• Normalized and Denormalized Data Structures
• Slowly Changing Dimensions (SCD)
• Bronze, Silver, and Gold Layer Architecture
• Data Lakehouse Design Patterns
• Strong SQL knowledge, including performance tuning and query optimization.
• Experience with large-volume datasets and enterprise analytics workloads.

Good-to-Have Skills

• Experience with Databricks Lakebase.
• Knowledge of Databricks Unity Catalog and Delta Sharing.
• Experience with cloud platforms such as Azure, AWS, or GCP.
• Exposure to 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 Oracle databases to:
  
• Databricks Delta Lake
• Snowflake
• Azure SQL Database
• Azure Synapse
• PostgreSQL
• MongoDB
• Knowledge of data quality, data lineage, metadata management, and Master Data Management (MDM).
• Experience in healthcare, banking, financial services, or insurance domains.
• Exposure to AI/ML-ready data products and feature engineering models.

Required Experience & Competencies

• Minimum 8+ years of experience in Data Modeling, Data Architecture, or Database Design.
• Proven experience designing enterprise-scale logical and physical data models.
• Experience working with large-scale batch and near-real-time data processing environments.
• Ability to analyze existing data models and recommend modernization and optimization strategies.
• Strong documentation skills, including:
  
• Entity Relationship Diagrams (ERDs)
• Data Dictionaries
• Source-to-Target Mapping Documents
• Data Modeling Standards
• Excellent communication and stakeholder management skills.
• Ability to collaborate with technical and business teams and participate in architecture-level discussions.