Data Modeling

Infosys; Bengaluru; Sur place; INR 900 000 - 1 300 000; Plein temps

Avantages offerts par ce poste

ERP/Analytics tooling credits

Résumé du poste

Infosys is seeking a data modeling expert to design and govern enterprise analytics models. You will translate business requirements into robust conceptual, logical, and physical data models, and collaborate with BI and engineering teams.

Responsibilities include Star Schema dimensional modeling, documentation, and governance practices to ensure data quality and reuse across analytics use cases. Prior experience in data warehouses is preferred.

Qualifications

• Experience in data modeling for analytics, reporting, or data platform initiatives.
• Hands-on expertise in Star Schema, Logical Data Modeling, and Physical Modeling.
• Strong understanding of relational concepts and dimensional modeling.

Responsabilités

• Gather and analyze business requirements to design robust conceptual, logical, and physical data models.
• Create and maintain dimensional models using Star Schema to support analytics and reporting use cases.
• Develop and refine logical data models with clear entities, relationships, and business definitions.
• Produce physical models aligned to target platforms, considering performance, storage, and scalability needs.
• Define keys, constraints, normalization/denormalization strategies, and data standards to ensure consistency and quality.
• Partner with engineering and BI teams to validate models, resolve data issues, and support implementation handoffs.
• Maintain documentation, data dictionaries, and model versioning to ensure traceability and reuse.
• Participate in design reviews and contribute to best practices for enterprise data modeling and governance.

Connaissances

SQL

Data Warehousing

ETL Concepts

Data Governance

Metadata Management

Formation

BTECH/MTECH/MCA/MSC

Description du poste

Good to have skills: SQL, Data Warehousing, ETL Concepts, Data Governance, Metadata Management

Key Responsibilities

• Gather and analyze business requirements to design robust conceptual, logical, and physical data models.
• Create and maintain dimensional models using Star Schema to support analytics and reporting use cases.
• Develop and refine logical data models with clear entities, relationships, and business definitions.
• Produce physical models aligned to target platforms, considering performance, storage, and scalability needs.
• Define keys, constraints, normalization/denormalization strategies, and data standards to ensure consistency and quality.
• Partner with engineering and BI teams to validate models, resolve data issues, and support implementation handoffs.
• Maintain documentation, data dictionaries, and model versioning to ensure traceability and reuse.
• Participate in design reviews and contribute to best practices for enterprise data modeling and governance.

Minimum Qualifications

• Education: BTECH, MTECH, MCA, MSC (or equivalent).
• 3-5 years of experience in data modeling for analytics, reporting, or data platform initiatives.
• Hands‑on expertise in Star Schema, Logical Data Modeling, and Physical Modeling.
• Strong understanding of relational concepts, entity-relationship modeling, and dimensional modeling principles.
• Ability to translate business requirements into clear, implementable data structures and documentation.

Preferred Qualifications

• Experience modeling for enterprise data warehouses/lakes and supporting multiple downstream consumers (BI, analytics, data science).
• Proven ability to optimize models for performance and usability, balancing normalization and denormalization trade-offs.
• Familiarity with data governance practices such as naming standards, metadata management, and stewardship collaboration.
• Strong stakeholder communication skills, including facilitating requirement workshops and presenting model designs.
• Experience working in Agile delivery teams and contributing to iterative model evolution and change management.