Data Modeling

Infosys; Bengaluru; On-site; INR 900,000 - 1,300,000; Full time

Benefits offered by this job

ERP/Analytics tooling credits

Job summary

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.

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.

Skills

SQL

Data Warehousing

ETL Concepts

Data Governance

Metadata Management

Education

BTECH/MTECH/MCA/MSC

Job description

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.