03 Sep
|
Tata Consultancy Services
|
Bengaluru
03 Sep
Tata Consultancy Services
Bengaluru
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.
📌 Data modeler - PAN INDIA (Bengaluru)
🏢 Tata Consultancy Services
📍 Bengaluru