Snowflake & dbt Data Engineer

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

Job summary

Tata Consultancy Services Limited in Bengaluru, Karnataka seeks an experienced Data Engineer to design and develop scalable Snowflake-based data warehouse solutions. You will build dbt models, optimize ELT/ETL pipelines, and create dimensional models to support business insights.

The role requires 6–12 years IT experience with Snowflake and dbt, and exposure to cloud platforms (AWS/Azure/GCP). Agile environment experience and data governance awareness are preferred.

Qualifications

• 6–12 years of overall IT experience.
• Minimum 3+ years of hands-on Snowflake experience.
• Minimum 2+ years of dbt implementation experience.
• Experience in cloud migration and data warehouse modernization projects.
• Experience working in Agile environments.

Responsibilities

• Design and develop scalable cloud-based data warehouse solutions using Snowflake.
• Build and maintain dbt models, macros, tests, and documentation.
• Develop and optimize ELT/ETL pipelines for enterprise data platforms.
• Create dimensional models, fact tables, and business data marts.
• Implement data quality checks and automated testing frameworks.
• Optimize Snowflake performance, storage, and compute utilization.
• Collaborate with business and technical stakeholders to deliver data solutions.
• Support production deployments, troubleshooting, and performance tuning.
• Ensure adherence to data governance, security, and compliance standards.

Skills

Snowflake

dbt

Advanced SQL

Data Warehousing

Dimensional Modeling

ETL/ELT

Cloud Platforms

Education

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

Tools

dbt

Job description

Key Responsibilities

• Design and develop scalable cloud-based data warehouse solutions using Snowflake.
• Build and maintain dbt models, macros, tests, and documentation.
• Develop and optimize ELT/ETL pipelines for enterprise data platforms.
• Create dimensional models, fact tables, and business data marts.
• Implement data quality checks and automated testing frameworks.
• Optimize Snowflake performance, storage, and compute utilization.
• Collaborate with business and technical stakeholders to deliver data solutions.
• Support production deployments, troubleshooting, and performance tuning.
• Ensure adherence to data governance, security, and compliance standards.

Required Skills

• Strong hands-on experience with Snowflake
• Experience in dbt (Data Build Tool)
• Advanced SQL development and query optimization
• Data Warehousing and Dimensional Modeling
• ETL/ELT development and optimization
• Experience with Snowflake features such as:
• Virtual Warehouses
• Streams & Tasks
• Time Travel
• Snowpipe
• Secure Data Sharing
• Exposure to cloud platforms such as AWS, Azure, or GCP

Preferred Skills

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

Desired Experience

• 6-12 years of overall IT experience
• Minimum 3+ years of hands-on Snowflake experience
• Minimum 2+ years of dbt implementation experience
• Experience in cloud migration and data warehouse modernization projects
• Experience working in Agile environments

Education

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