Data Modeller - S

Tata Consultancy Services; Chennai District; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

Tata Consultancy Services in Chennai seeks a seasoned Data Modeler to lead enterprise data modeling across conceptual, logical, and physical layers. You will translate business requirements into robust data structures while collaborating with architects, engineers, and analysts to ensure data quality and governance.

The role emphasizes hands-on SQL, experience with major RDBMS, and proficiency in modeling tools such as ERwin, ER/Studio, and PowerDesigner.

Qualifications

• Bachelors degree in CS/IS/Engineering/Math or related field.
• Strong experience in data modeling and database design.
• Expertise in conceptual data models, logical data models, and physical data models.
• Strong understanding of data modeling principles, normalization/denormalization, dimensional modeling, ER modeling, and data warehousing concepts.
• Proficiency in SQL and relational database management systems.
• Experience with data modeling tools such as ERwin, ER/Studio, PowerDesigner, Lucidchart, Visio.
• Experience with databases such as SQL Server, Oracle, PostgreSQL, MySQL, Snowflake.
• Strong analytical and problem-solving skills.

Responsibilities

• Design and develop conceptual, logical, and physical data models for enterprise applications and data platforms.
• Analyze business requirements and translate them into effective data modeling solutions.
• Define data entities, relationships, attributes, and business rules.
• Develop and maintain data dictionaries, metadata repositories, and data lineage documentation.
• Collaborate with Data Architects, Data Engineers, Business Analysts, and application teams to ensure data consistency and quality.
• Support database design, optimization, and performance tuning initiatives.
• Implement data governance standards, naming conventions, and best practices.
• Conduct data profiling and impact analysis for system enhancements and migrations.
• Assist in data warehouse, data lake, and master data management initiatives.
• Participate in Agile/Scrum ceremonies and contribute to project planning and delivery.

Skills

Data modeling

Database design

SQL

ERwin

ER/Studio

PowerDesigner

Lucidchart

Visio

SQL Server

Oracle

PostgreSQL

MySQL

Snowflake

Dimensional modeling

Star schema

Education

Bachelor's degree in Computer Science, Information Systems, Engineering, Mathematics, or related field

Tools

ERwin

ER/Studio

PowerDesigner

Lucidchart

Visio

Job description

Key Responsibilities

• Design and develop conceptual, logical, and physical data models for enterprise applications and data platforms.
• Analyze business requirements and translate them into effective data modeling solutions.
• Define data entities, relationships, attributes, and business rules.
• Develop and maintain data dictionaries, metadata repositories, and data lineage documentation.
• Collaborate with Data Architects, Data Engineers, Business Analysts, and application teams to ensure data consistency and quality.
• Support database design, optimization, and performance tuning initiatives.
• Implement data governance standards, naming conventions, and best practices.
• Conduct data profiling and impact analysis for system enhancements and migrations.
• Assist in data warehouse, data lake, and master data management initiatives.
• Participate in Agile/Scrum ceremonies and contribute to project planning and delivery.

Required Skills & Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, Mathematics, or a related field.
• Strong experience in data modeling and database design.
• Expertise in creating:
  • Conceptual Data Models
  • Logical Data Models
  • Physical Data Models
• Strong understanding of:
  • Data Modeling Principles
  • Data Normalization and Denormalization
  • Dimensional Modeling (Star Schema, Snowflake Schema)
  • ER Modeling
  • Data Warehousing Concepts
• Proficiency in SQL and relational database management systems.
• Experience with data modeling tools such as:
  • ERwin
  • ER/Studio
  • PowerDesigner
  • Lucidchart
  • Visio
• Experience working with databases such as:
  • SQL Server
  • Oracle
  • PostgreSQL
  • MySQL
  • Snowflake
• Strong analytical and problem-solving skills.