Data Modeller

Tata Consultancy Services; Bengaluru; On-site; INR 1,500,000 - 2,300,000; Full time

Job summary

Tata Consultancy Services in Bengaluru seeks an experienced Data Modeling Specialist to design conceptual, logical, and physical data models and to manage metadata, lineage, and governance across banking data assets.

The role requires strong SQL and data warehousing knowledge, hands-on with ERwin, and experience with cloud platforms like AWS, Snowflake, and Databricks. Agile delivery and stakeholder management are essential.

Qualifications

• 5+ years of experience in Data Modeling with conceptual, logical, and physical models.
• Hands-on experience with ERwin.
• Strong proficiency in SQL, database design, and Data Warehousing concepts.
• Experience in Source-to-Target Mapping, data profiling, and data analysis.
• Deep understanding of Metadata Management, Data Lineage, and Data Governance practices.
• Experience with OpenMetadata, Collibra, Informatica EDC/Axon, or similar tools.
• Exposure to AWS, Snowflake, Databricks, or modern cloud data platforms.
• Knowledge of Data Governance, Data Quality, and Data Observability frameworks.
• Experience with Data Lineage, Impact Analysis, and Business Glossary Management.
• Understanding of API/JSON schema modeling and integration patterns.
• Familiarity with Data Lake, Big Data, and Analytics architectures.
• Awareness of Agile methodologies and stakeholder management in large-scale data programs.
• Relevant certifications in Data Management, Cloud Technologies, or Banking Domain.

Responsibilities

• Design and maintain Conceptual, Logical, and Physical Data Models aligned to standards.
• Collaborate with stakeholders to translate requirements into scalable data models.
• Develop and maintain source-to-target mappings, data dictionaries, metadata, and business glossaries; perform profiling and lineage assessments.
• Ensure adherence to data governance, data quality, and regulatory standards across banking data assets.
• Review and optimize database schemas for performance and scalability; promote best practices in modeling and documentation.
• Work with Agile teams to deliver data solutions that meet business and regulatory requirements.

Skills

Data Modeling

ERwin

SQL

Data Warehousing

Data Lineage

Metadata Management

Data Governance

Data Profiling

API/JSON schema modeling

AWS

Snowflake

Databricks

Agile

Stakeholder Management

Tools

OpenMetadata

Collibra

Informatica EDC/Axon

Job description

• Required Technical Skill Set Conceptual, Logical & Physical Data Modeling, ERWIN Tool,SQL & Database Design Data Analysis & Data Profiling |Data Dictionary & Metadata Management Data Lineage and Impact Analysis Normalization & Data Modeling Best Practices
• Desired Experience Range : 5 - 15 years
• Location of Requirement : Hyderabad, Pune , Bangalore, Chennai

Desired Competencies (Technical/Behavioral Competency)

• 5+ years of experience in Data Modeling with expertise in Conceptual, Logical, and Physical Data Models
• Hands-on experience with ERwin,
• Strong proficiency in SQL, database design, and Data Warehousing concepts.
• Experience in Source-to-Target Mapping, data profiling, and data analysis
• Deep understanding of Metadata Management, Data Lineage, and Data Governance practices.

• Experience with OpenMetadata, Collibra, Informatica EDC/Axon, or similar metadata management tools.
• Exposure to AWS, Snowflake, Databricks, or modern cloud data platforms.
• Knowledge of Data Governance, Data Quality, and Data Observability frameworks.
• Experience with Data Lineage, Impact Analysis, and Business Glossary Management.
• Understanding of API/JSON schema modeling and integration patterns.
• Familiarity with Data Lake, Big Data, and Analytics architectures
• Exposure to Agile delivery methodologies and stakeholder management in large-scale data transformation programs.
• Relevant certifications in Data Management, Cloud Technologies, or Banking Domain.

Responsibility of / Expectations from the Role

• Design and maintain Conceptual, Logical, and Physical Data Models aligned to business and enterprise data architecture standards.
• Collaborate with business stakeholders, data architects, analysts, and engineering teams to translate business requirements into scalable data models.
• Develop and maintain source-to-target mappings, data dictionaries, metadata, and business glossaries. Perform data analysis, profiling, lineage, and impact assessments to support data integration and transformation initiatives.
• Ensure adherence to data governance, data quality, and regulatory compliance standards across banking data assets. Support enterprise metadata management and data catalog initiatives to improve data discoverability and usability.
• Review and optimize database schemas for performance, scalability, and maintainability. Drive best practices in data modeling, documentation, and standards across project teams.
• Work closely with cross-functional teams in an Agile environment to deliver data solutions that meet business and regulatory requirements.