Snowflake DBT developer

Tata Consultancy Services; Pune District, Kolkata District; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Tata Consultancy Services is seeking a data engineering professional in Pune with hands-on DBT experience. You will design modular data pipelines, model data using star/snowflake schemas, and integrate DBT with Snowflake/BigQuery/Redshift. The role requires governance, testing, and good documentation of data lineage.

Exposure to AWS services, Matillion or Airflow, and CI/CD practices is expected, along with strong collaboration in an Agile delivery environment.

Qualifications

• Strong hands-on experience in DBT for developing modular and maintainable data transformation pipelines.
• Proficiency in SQL and data modeling using star/snowflake schemas.
• Experience integrating DBT with data warehouses such as Snowflake, BigQuery, or Redshift.
• Good understanding of data governance, testing, documentation, and lineage tracking using DBT features.
• Familiarity with AWS cloud services (S3, Glue, Lambda, Step Functions).
• Knowledge of Matillion, Airflow, or similar orchestration tools.
• Exposure to CI/CD and version control (Git) for DBT project deployments.
• Strong communication and collaboration skills with a focus on Agile delivery.

Responsibilities

• Develop modular data transformation pipelines using DBT.
• Model data using star and snowflake schemas in data warehouses.
• Integrate DBT with Snowflake, BigQuery, or Redshift.
• Ensure data governance, testing, and proper documentation of data lineage.
• Leverage AWS services for data workflows and orchestration.
• Utilize Matillion or Airflow for orchestration tasks.
• Implement CI/CD practices and version control for DBT projects.
• Collaborate with cross-functional teams to support Agile delivery.

Skills

DBT

SQL

Data modelling

Data pipeline

Data governance

Documentation

Git

CI/CD

Agile delivery

Tools

Snowflake

BigQuery

Redshift

Matillion

Airflow

Job description

DBT (Data Build Tool), SQL, Data Modelling (Star/Snowflake schemas), Data Pipeline Development, Data Governance & Documentation, Git, CI/CD pipelines, Data Warehousing (Snowflake/BigQuery/Redshift)

Key Responsibilities and Qualifications

• Strong hands‑on experience in DBT for developing modular and maintainable data transformation pipelines.
• Proficiency in SQL and data modeling using star/snowflake schemas.
• Experience integrating DBT with data warehouses such as Snowflake, BigQuery, or Redshift.
• Good understanding of data governance, testing, documentation, and lineage tracking using DBT features.
• Familiarity with AWS cloud services (S3, Glue, Lambda, Step Functions).
• Knowledge of Matillion, Airflow, or similar orchestration tools.
• Exposure to CI/CD and version control (Git) for DBT project deployments.
• Strong communication and collaboration skills with a focus on Agile delivery.