Snowflake & DBT Data Engineer

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

Job summary

TATA Consultancy Services invites an experienced Snowflake and dbt Data Engineer to join our Bengaluru center. You will design scalable cloud data warehouses, implement dbt models, and optimize ELT pipelines to support enterprise analytics.

Ideal candidates have 6–12 years in data engineering, strong SQL and Python skills, and experience with Snowflake on cloud platforms (AWS/Azure/GCP). The role focuses on performance, governance, and scalable data architecture.

Qualifications

• 6–12 years of experience in data engineering.
• Strong expertise in Snowflake, dbt, SQL and Python.

Responsibilities

• Design scalable data warehouse solutions using Snowflake.
• Build and optimize ELT pipelines for enterprise data platforms.
• Collaborate with analytics teams to gather requirements and ensure data governance.

Skills

Snowflake

dbt

SQL

Python

ETL/ELT

Data Warehousing

Dimensional Modeling

Cloud Data Transformation

Education

BE / B.Tech / MCA / M.Tech or equivalent

Tools

Databricks

Airflow

AWS Glue

Kafka

Terraform

PySpark

Job description

Greetings from TATA Consultancy Services!

About the Role

We are seeking an experienced Snowflake & dbt Data Engineer with 6–12 years of experience in designing and implementing scalable cloud data warehouse solutions. The ideal candidate should possess strong expertise in Snowflake, dbt, SQL, Python, and cloud-based data transformation frameworks. The role involves building data pipelines, transforming data models, optimizing performance, and supporting enterprise analytics and reporting initiatives.

Responsibilities

• Design and develop scalable data warehouse solutions using Snowflake.
• Build and maintain dbt models, macros, tests, and documentation.
• Develop and optimize ELT pipelines for enterprise data platforms.
• Create dimensional models, fact tables, and business data marts.
• Implement data quality checks and automated testing using dbt.
• Optimize Snowflake performance, storage, and compute costs.
• Develop reusable frameworks and standards for data engineering projects.
• Collaborate with business stakeholders, solution architects, and analytics teams to gather requirements.
• Support production deployments, troubleshooting, and performance tuning activities.
• Ensure adherence to data governance, security, and compliance standards.

Qualifications

• BE / B.Tech / MCA / M.Tech or equivalent qualification.

Required Skills

• Hands-on experience with Snowflake Data Cloud
• Advanced SQL programming and query optimization
• Experience in Data Warehousing and Dimensional Modeling
• Experience with ETL/ELT development and optimization
• Knowledge of Snowflake features such as:
• Virtual Warehouses
• Streams & Tasks
• Time Travel
• Snowpipe
• Secure Data Sharing
• Experience working with cloud platforms (AWS/Azure/GCP)

Preferred Skills

• PySpark
• Databricks
• Airflow
• AWS Glue
• Kafka
• Terraform
• Data Governance and Data Quality frameworks

Pay range and compensation package

Experience: 6 – 12 Years

Equal Opportunity Statement

We are committed to diversity and inclusivity.