Technology and Transformation - Engineering - Manager - Data Modelling - Mumbai

Deloitte & Touche GmbH Wirtschaftsprüfungsgesellschaft; Mumbai; Hybrid; INR 2,000,000 - 3,500,000; Full time

Job summary

Deloitte Touche Tohmatsu India LLP in Mumbai invites a Manager - Data Modelling to lead enterprise data modeling efforts. You will analyze source systems, develop conceptual/logical data models, and collaborate with ETL, DB and architecture teams to support DWH modernization.

The role requires strong SQL/PL-SQL skills, experience with Oracle databases (11g/12c/19c) and EDM development, plus familiarity with Informatica PowerCenter and data governance.

Qualifications

• Education aligned to computer science or IT with relevant data modeling focus.
• Strong SQL/PL-SQL skills and experience with data warehouses.
• Experience with enterprise data modeling and data governance concepts.

Responsibilities

• Analyze source systems, existing DWH, and data assets.
• Develop CDM and LDM, identify entities and relations.
• Collaborate with ETL, DB, and architecture teams to validate data structures.
• Review mappings, lineage, and transformation logic; support EDM
• Create data dictionaries and architecture documentation.

Skills

Data modeling

SQL

PL/SQL

Documentation

Analytical skills

Education

B. tech / BE in Computer Science or Information Technology

Tools

Informatica PowerCenter

Oracle Database

Qlik Replicate

SAP IQ

Job description

Select how often (in days) to receive an alert:

Job Title: Technology and Transformation - Engineering - Manager - Data Modelling - Mumbai

Technology and Transformation - Engineering - Manager - Data Modelling - Mumbai
Job requisition ID : 110805
Location: Mumbai
Entity: Deloitte Touche Tohmatsu India LLP

The Team

Deloitte’s Technology & Transformation practice can help you uncover and unlock the value buried deep inside vast amounts of data. Our global network provides strategic guidance and implementation services to help companies manage data from disparate sources and convert it into accurate, actionable information that can support fact-driven decision-making and generate an insight-driven advantage. Our practice addresses the continuum of opportunities in business intelligence & visualization, data management, performance management and next-generation analytics and technologies, including big data, cloud, cognitive and machine learning.

We are seeking a Data Modeler to support the assessment, rationalization, and modernization of DWH platforms. The role involves analyzing source systems, existing data warehouses, business rules, and transformation logic to develop enterprise-aligned data models that support migration and future-state architecture initiatives.

• Analyze source systems, existing DWH, and existing data assets.
• Develop and maintain Conceptual Data Models (CDM) and Logical Data Models (LDM).
• Identify and define enterprise entities, attributes, and relationships.
• Support data model rationalization by identifying redundancies and gaps across data layers.
• Work with SMEs to understand business rules and data requirements.
• Collaborate with ETL, database, and architecture teams to validate data structures.
• Review source-to-target mappings, lineage, and transformation logic.
• Support Enterprise Data Model (EDM) development and migration initiatives.
• Prepare data dictionaries, entity catalogues, and relationship documentation.
• Participate in data model reviews and stakeholder workshops.
• Strong experience in Data Warehousing concepts and dimensional modeling.
• Experience with Conceptual, Logical, and Physical Data Modeling.
• Strong SQL knowledge and understanding of relational databases.
• Develop scalable and high-performance data warehouse and data mart solutions using Oracle databases (11g/12c/19c, Exadata).
• Experience analyzing Oracle/Sybase data models and database objects.
• Understanding of data lineage, STTM, and business rule documentation.
• Familiarity with ETL processes and data integration concepts.
• Strong analytical and documentation skills.
• Ensure adherence to security, compliance, and governance standards
• Create and maintain detailed technical documentation and architecture diagrams.
• Support Agile delivery processes, including sprint planning, estimations, and technical decision-making.
• Deep understanding of ETL/ELT architectures, data warehousing, Data lakehouse concepts.
• Ability to lead technical discussions and provide architectural guidance.
• Experience in large-scale Data Warehouse modernization or migration projects.
• Exposure to Informatica PowerCenter and enterprise data platforms.
• Experience working with Customer, Policy, Claims, or similar business domains.
• Knowledge of data governance and metadata management concepts.
• Knowledge of Customer 360
• Exposure experience with SAP IQ . Informatica PowerCenter
• Advanced SQL and PL/SQL development and performance tuning skills.
• Exposure / Knowledge to near real-time Data capture tools(like CDC - Oracle Golden Gate or Qlik Replicate etc.)

Preferred Qualifications

• Education - B. tech / BE in Computer Science or Information Technology.

Success Metrics

• Strong experience in Data Warehousing concepts and dimensional modeling.
• Experience with Conceptual, Logical, and Physical Data Modeling.
• Strong SQL knowledge and understanding of relational databases.
• Develop scalable and high-performance data warehouse and data mart solutions using Oracle databases (11g/12c/19c, Exadata).
• Collaborate with ETL, database, and architecture teams to validate data structures
• Experience analyzing Oracle/Sybase data models and database objects.
• Understanding of data lineage, STTM, and business rule documentation.
• Familiarity with ETL processes and data integration concepts.

Location and way of working:

• Work Model:Hybrid – Mandatory 3 days/week from client office