Walk-in | DBT/Snowflake

Tata Consultancy Services; Chennai District; On-site; INR 900,000 - 1,200,000; Full time

Job summary

Tata Consultancy Services in Chennai is seeking a DBT/Snowflake specialist to design, develop, and maintain data transformation workflows using DBT and modern data stacks. You will collaborate with data analysts and business teams to translate data requirements into DBT models and enforce data modeling best practices.

Join a role that involves monitoring DBT runs, maintaining documentation, and integrating with Snowflake, BigQuery, Redshift, and Airflow.

Qualifications

• Production DBT experience in a data warehouse environment.
• Strong SQL skills and data modeling knowledge.
• Experience with cloud data warehouses (Snowflake/BigQuery/Redshift).
• Familiarity with version control systems (Git).
• Understanding of ELT/ETL pipelines and modern data stacks.
• Good communication skills and problem-solving ability.

Responsibilities

• Design, develop, and maintain data transformation workflows using DBT.
• Collaborate with data analysts and business teams to understand data requirements and translate them into DBT models.
• Implement and enforce data modeling best practices (e.g., star/snowflake schemas, normalization).
• Monitor and optimize DBT runs for performance and reliability.
• Maintain documentation for DBT models, sources, and tests.
• Integrate DBT with modern data stacks (e.g., Snowflake, BigQuery, Redshift, Airflow).
• Implement data quality checks and testing using DBT’s built-in testing framework.
• Participate in code reviews and contribute to a culture of continuous improvement.

Skills

DBT

SQL

Data modeling

Communication

ELT/ETL pipelines

Problem solving

Tools

Snowflake

BigQuery

Redshift

Airflow

Git

Job description

Mode - F2F

Skill - DBT/Snowflake

Location - Chennai

Role & responsibilities

• Design, develop, and maintain data transformation workflows using DBT.
• Collaborate with data analysts and business teams to understand data requirements and translate them into DBT models.
• Implement and enforce data modeling best practices (e.g., star/snowflake schemas, normalization).
• Monitor and optimize DBT runs for performance and reliability.
• Maintain documentation for DBT models, sources, and tests.
• Integrate DBT with modern data stacks (e.g., Snowflake, BigQuery, Redshift, Airflow).
• Implement data quality checks and testing using DBTs built-in testing framework.
• Participate in code reviews and contribute to a culture of continuous improvement.

Must Have:

• Experience working with DBT in a production environment.
• Strong SQL skills and experience with data modeling.
• Experience with cloud data warehouses (e.g., Snowflake, BigQuery, Redshift).
• Familiarity with version control systems (e.g., Git).
• Understanding of ELT/ETL pipelines and modern data stack tools.
• Strong problem-solving and communication skills.