Snowflake Developer

Role overview

This position is for a Snowflake and dbt-focused data engineer/architect at Tata Consultancy Services in Hyderabad, with the requirement also mentioning Chennai as a possible location. The role centers on enterprise data platform design, modernization of legacy ETL into Snowflake- and dbt-based ELT, and the creation of agent-driven accelerators that connect code, data, metadata, and orchestration.

Required technical stack

The core technology areas called out for this role are Snowflake, dbt, IBM DataStage, and MCP server integration. Strong knowledge of Snowflake architecture, dbt development, and DataStage modernization is expected, along with familiarity with API-driven and secure runtime integration patterns.

Experience and scope

The role calls for at least 5 years of relevant experience. There are 10 requirements in total. The work includes enterprise-grade architecture, modernization of batch and real-time pipelines, and the design of reusable tooling for analytics and automation use cases.

Responsibilities

• Shape and oversee end-to-end enterprise data and AI architecture across Snowflake, dbt, IBM DataStage, and agent-based accelerators that tie together code, data, and orchestration.
• Build data platform architecture and ETL/ELT modernization solutions, including AI-ready agent frameworks using MCP-style server integrations for reusable analytics and automation accelerators.
• Establish enterprise-level architecture for Snowflake-based data platforms and dbt transformation layers, including hybrid modernization patterns that combine DataStage, dbt, and Snowflake.
• Lead migration and modernization efforts from IBM DataStage batch and real-time pipelines to dbt plus Snowflake ELT designs.
• Govern integration patterns across Kafka, API-based ingestion, and batch pipelines wherever needed.
• Design and manage enterprise-grade agents and accelerators that work with code, metadata, data, Snowflake, dbt artifacts, and orchestration tools.
• Architect MCP server-based integrations that support tool-calling agents, data-aware agents, validation, lineage, and impact-analysis workflows.
• Create reusable accelerators for data onboarding and dbt project frameworks.

Requirements

• Deep expertise in Snowflake, including enterprise data architecture, performance tuning, governance, and cost modeling.
• Advanced dbt knowledge, including modeling, macros, CI/CD, and artifacts APIs.
• Working knowledge of IBM DataStage, especially legacy ETL patterns and modernization approaches.
• Familiarity with MCP-style server integrations or similar tool-calling and protocol-based agent frameworks.
• Good-to-have skills include SQL and Python for tooling, automation, and agent logic.
• Experience designing agent-based systems that interact with databases, metadata, and code repositories is preferred.
• Strong understanding of API-driven architectures and secure runtime integrations between AI, data, and code is preferred.
• The role specifies an eligibility of Any Graduate.

Preferred candidate profile

The ideal candidate should be comfortable working across data architecture, modernization, automation, and agentic integration layers, with the ability to translate enterprise data requirements into scalable Snowflake and dbt solutions.

Additional information

Required location of work is Hyderabad, with Chennai also mentioned in the requirement details. The vacancy count listed is 10. No separate perks, stipend, or internship duration were specified in the source. Employment type was not explicitly provided.