Data Architecture and Modeling

Tata Consultancy Services; Chennai District, Bengaluru, Hyderabad; On-site; INR 1,500,000 - 2,800,000; Full time

Job summary

Tata Consultancy Services seeks a Data Architect and Modeling professional in India to drive enterprise data architecture strategy, data models, and governance across systems. You will own scalable data pipelines, integration solutions, and compliance with security and privacy standards.

The role covers ETL/ELT design for batch and real-time data, using modern cloud platforms and governance tools to enable robust analytics capabilities across the organization.

Qualifications

• Relational, dimensional, and NoSQL data modeling expertise.
• Strong data warehousing concepts and BI tools knowledge.
• Familiarity with Data Mesh, Medallion Architecture, and Data Fabric concepts.

Responsibilities

• Develop enterprise-wide data architecture strategy and roadmap.
• Create and maintain data models, schemas, and data flow diagrams.
• Design scalable solutions for data storage, integration, and retrieval.
• Establish data governance frameworks and enforce standards.
• Ensure compliance with data security, privacy, and regulatory requirements.
• Design ETL/ELT processes for batch, real-time, and streaming data.
• Optimize data pipelines for performance and cost efficiency.

Skills

SQL

Python

Data Modeling

Data Warehousing

ETL/ELT

Data Governance

Data Pipelines

Batch/Real-time

Spark/PySpark

Tools

Collibra

Alation

Informatica

Databricks

Snowflake

BigQuery

MS Fabric

AWS Redshift

Airflow

ADF

GCP Dataflow

Job description

Role: Data Architecture and Modeling

Experience Range: 6-10 Years

Location: India

Role Overview

A Data Architect and Modeling is responsible for designing and implementing scalable, secure, and efficient data architecture frameworks that align with business objectives. In addition to defining enterprise data models and governance policies, this role also includes data engineering responsibilities to ensure robust data pipelines and integration across systems.

Key Responsibilities

• Develop enterprise-wide data architecture strategy and roadmap.
• Create and maintain data models, schemas, and data flow diagrams.
• Design scalable solutions for data storage, integration, and retrieval.
• Establish data governance frameworks and enforce standards.
• Ensure compliance with data security, privacy, and regulatory requirements.
• Design ETL/ELT processes for batch, real-time, and streaming data.
• Optimize data pipelines for performance and cost efficiency.

Required Technical Skills

• Expertise in relational, dimensional, and NoSQL modeling.
• Strong knowledge of data warehousing concepts and BI tools.
• Familiarity with Data Mesh, Medallion Architecture, and Data Fabric concepts.
• Experience in data governance tools and metadata management (Collibra, Alation, informatica)
• Hands on experience in modern Cloud native Data Platforms (Databricks, Snowflake, Google BigQuery, MS Fabric, AWS Redshift)
• Proficiency in ETL tools and frameworks (ADF, GCP Dataflow, AWS Glue, Airflow).
• Experience with batch and real-time data ingestion (lambda architecture)
• Strong SQL skills
• Familiarity with Python, Spark, or PySpark for data processing.