Data Modeler

Tata Consultancy Services; Pune District; On-site; INR 1,800,000 - 3,200,000; Full time

Job summary

Tata Consultancy Services in Pune is seeking an experienced Data Modeler / Lead to design, develop, and maintain data models that support BI and analytics initiatives. The ideal candidate should have a strong background in data modeling, data warehousing, and data governance.

You will collaborate with data architects and business stakeholders to implement data warehousing, governance, and data quality checks, employing dimensional and relational modeling techniques, and using ERwin, Informatica

Qualifications

• In-depth knowledge of data modeling concepts including entity relationship modeling, dimensional modeling, and data vault modeling.
• Strong understanding of data warehousing concepts including ETL, data marts, and data lakes.
• Familiarity with data governance frameworks including data quality, data security, and data compliance.
• Excellent communication and collaboration skills.
• Proficiency in data modeling tools such as ERwin, Informatica PowerDesigner, or IBM InfoSphere Data Architect.

Responsibilities

• Design, develop, and maintain conceptual, logical, and physical data models.
• Design and implement data warehousing solutions with data architects and stakeholders.
• Develop and maintain data governance policies, procedures, and standards.
• Apply dimensional and relational modeling techniques for data warehouses.
• Collaborate with cross-functional teams to ensure data quality.
• Develop data quality checks and validation rules.

Skills

Data Modeling

Data Warehousing

Data Governance

Communication

Tools

ERwin

Informatica PowerDesigner

IBM InfoSphere Data Architect

Job description

Job Summary

An experienced Data Modeler / Lead to design, develop, and maintain data models that support business intelligence and data analytics initiatives. The ideal candidate should have a strong background in data modeling, data warehousing, and data governance.

Responsibilities

• Data Modeling: Design, develop, and maintain conceptual, logical, and physical data models.
• Data Warehousing: Work with data architects and business stakeholders to design and implement data warehousing solutions.
• Data Governance: Develop and maintain data governance policies, procedures, and standards.
• Data modeling techniques for data warehouses primarily include dimensional modeling (star, snowflake schemas) and relational modeling (3NF)
• Collaboration: Work with cross-functional teams to identify and prioritize project requirements, provide technical guidance, and ensure data quality.
• Data Quality: Develop and implement data quality checks and data validation rules.

Required Skills

• Data Modeling: In-depth knowledge of data modeling concepts, including entity relationship modeling, dimensional modeling, and data vault modeling.
• Data Warehousing: Strong understanding of data warehousing concepts, including ETL, data marts, and data lakes.
• Data Governance: Familiarity with data governance frameworks, including data quality, data security, and data compliance.
• Communication: Excellent communication and collaboration skills.
• Tools: Proficiency in data modeling tools, such as ERwin, Informatica PowerDesigner, or IBM InfoSphere Data Architect.

Preferred Skills

• Certifications: Relevant certifications, such as Certified Data Modeler (CDM) or Certified Data Warehouse Architect (CDWA).
• Big Data: Experience with big data technologies, such as Hadoop, Spark, or NoSQL databases.
• Cloud Experience: Experience with cloud-based data platforms, such as AWS, Azure, or Google Cloud.
• Programming: Experience with programming languages, including SQL, Python, or R