Job highlights

- 8-12 years experience in Enterprise Data Architecture with advanced SQL, Dimensional Modeling, Lakehouse design, and API/event-driven integrations
- Design and implement Data Lakes, Warehouses, Lakehouse architectures, batch and real-time data pipelines, and ensure data governance and metadata management

Role

Database Architect

Required Technical Skill Set

Advanced SQL development and performance tuning Experience with ETL/ELT design and implementation Hands-on experience with Databricks, Snowflake, Microsoft Fabric, Synapse, or similar enterprise data platforms Experience designing and implementing Data Lakes, Data Warehouses, and Lakehouse Architectures Knowledge of batch and real-time data processing frameworks Experience with API-based integrations, CDC, and event-driven architectures

Experience Range : 8-12 years

Location of Requirement Kolkata, Chennai, Lucknow

Desired Competencies

Must-Have Strong experience in Enterprise Data Architecture and Data Modeling Expertise in Dimensional Modeling, Star Schema, Snowflake Schema,



and Data Vault concepts Hands-on experience designing Lakehouse and Medallion Architectures (Bronze, Silver, Gold layers) Strong SQL and database design experience (PostgreSQL, SQL Server, Oracle, etc.) Experience building batch and real-time data pipelines Strong understanding of Data Governance, Data Quality, Data Lineage, and Metadata Management Experience defining canonical data models and enterprise data standards Knowledge of API-based integrations and event-driven architectures Experience working with Cloud Data Platforms and modern data ecosystems Robust stakeholder management and solution design skills

- Good-to-Have

Experience with Data Lake, Data Warehouse, and Lakehouse implementations Knowledge of Kafka, Event Streaming, and CDC frameworks Exposure to AI/ML and GenAI-ready data architectures Experience with Master Data Management (MDM) Understanding of Data Fabric and Data Mesh concepts Retail, Supply Chain, Logistics, or Manufacturing domain experience Experience with Data Security, Privacy, and Compliance frameworks.

📌 Database Architect (Kolkata)
🏢 Tata Consultancy Services
📍 Kolkata