Data modeler - PAN INDIA

Greetings from Tata Consultancy Services (TCS)

What we are looking for: Data Modeler

Location : PAN INDIA

Interview Mode : Virtual mode (Microsoft Teams)

Experience : 8-15Years

• Understand business processes, KPIs, regulatory requirements, and analytical use cases.
• Collaborate with business stakeholders to identify entities, attributes, relationships, hierarchies, and business rules.
• Translate business requirements into conceptual and logical data structures.
• Participate in workshops, requirements gathering sessions, and data discovery activities.
• Design and maintain:
• Conceptual Data Models (CDM)
• Logical Data Models (LDM)
• Physical Data Models (PDM)
• Build normalized (3NF) operational models and dimensional models (Star/Snowflake) for analytical environments.
• Define:
• Entities
• Attributes
• Relationships
• Cardinality
• Constraints
• Keys (Primary, Foreign, Alternate, Natural, Surrogate)
• Design canonical enterprise models and domain-specific models.
• Develop data models supporting Data Products, MDM, AI/ML, and Regulatory Reporting initiatives.
• Design Fact-Dimension architecture.
• Define grain, hierarchies, slowly changing dimensions (SCD), aggregation strategies, and historical data management.
• Support enterprise reporting, BI, self-service analytics, and AI workloads.
• Optimize structures for query performance and scalability.
• Align models with enterprise data governance policies.
• Maintain business metadata, technical metadata, and lineage information.
• Support data catalog, glossary, and stewardship initiatives.
• Ensure consistency across domains and systems.
• Collaborate with Data Governance teams on standards and model reviews.
• Work with Enterprise Architects and Solution Architects to ensure alignment with target-state architecture.