Join Deloitte's Technology & Transformation practice as a Data Modeler in Mumbai. This role focuses on assessing, rationalizing, and modernizing Data Warehouse platforms. You will analyze source systems and existing data structures to create enterprise-aligned data models that support migration and future architecture initiatives.

Our practice helps clients unlock value from data by providing strategic guidance and implementation services. We manage data from diverse sources, converting it into actionable information for informed decision-making. Our expertise spans business intelligence, data management, performance management, and advanced analytics including big data and cloud technologies.

Key responsibilities include analyzing source systems and existing data assets, developing and maintaining conceptual, logical, and physical data models. You will identify enterprise entities, attributes, and relationships, supporting data model rationalization by detecting redundancies. Collaborate with SMEs to grasp business rules and data requirements, and work closely with ETL, database, and architecture teams for validation.

Additionally, review source-to-target mappings and transformation logic, and support Enterprise Data Model development. Prepare detailed documentation like data dictionaries and entity catalogs. Participate in data model reviews and stakeholder workshops, ensuring adherence to security and governance standards. Support Agile delivery processes, including sprint planning and technical decision-making.

We are looking for a Data Modeler with strong experience in Data Warehousing concepts and dimensional modeling. Proficiency in Conceptual, Logical, and Physical Data Modeling is essential, alongside strong SQL knowledge and understanding of relational databases. Experience developing scalable data warehouse solutions using Oracle databases (11g/12c/19c, Exadata) is required.

Familiarity with data lineage, STTM, and business rule documentation, as well as ETL processes and data integration concepts, is crucial. Analytical and documentation skills are highly valued. Experience with large-scale Data Warehouse modernization or migration projects is a plus. A Bachelor's degree in Computer Science or Information Technology is preferred.