Snowflake + DBT Developer

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

Job summary

Tata Consultancy Services in Chennai, Pune, and Bangalore seeks a data engineering professional with strong DBT and Snowflake expertise to design, develop, and optimize data models and ELT pipelines. The role requires deep SQL skills and experience with cloud platforms, Git, and data warehousing concepts.

You will collaborate with data engineers and analysts to ensure data quality, performance, and cost optimization in a multi-cloud environment.

Qualifications

• Must-Have DBT and Snowflake.
• Experience in data engineering with Snowflake and DBT.
• Strong hands-on DBT experience and ability to build data models using DBT commands, Jinja macros, and configurations.
• Proficiency in developing and managing DBT projects, testing, and documentation.
• Strong SQL proficiency including advanced concepts.
• Experience with Snowflake architecture and optimizing SQL for the platform.
• Understanding of data warehousing architectures and ETL/ELT processes, data transformation and quality.
• Proficiency with cloud platforms (AWS/Azure/GCP) and Git.

Responsibilities

• Design, develop, and optimize data models and transformations using DBT.
• Build and manage ELT pipelines using DBT and other tools.
• Ensure data quality and integrity through testing and validation.
• Collaborate with data engineers, analysts, and other stakeholders.
• Optimize Snowflake performance and cost.

Skills

DBT

Snowflake

SQL

ELT/ETL

Data warehousing

Git

Cloud platforms (AWS/Azure/GCP)

Tools

DBT

Snowflake

Git

AWS

Azure

GCP

Job description

Location of Requirement- Chennai, pune, Bangalore

Desired Competencies (Technical/Behavioral Competency)

Must-Have DBT and Snowflake

Experience and Skills

• Experience in data engineering, specifically with Snowflake and DBT.
• Key skills required are strong hands-on experience with DBT
• expertise in building and managing data models using DBT commands, Jinja macros, and configurations, and proficiency in developing and managing DBT projects, testing, and documentation.
• Strong SQL proficiency, including advanced concepts, is essential.
• Experience with Snowflake's architecture and optimizing SQL queries for the platform is also necessary. A solid understanding of data warehousing architectures and ETL/ELT processes, data transformation, and quality is expected.
• Proficiency with cloud platforms like AWS, Azure, or GCP and experience with version control systems like Git are often required.

Roles and Responsibilities

• Design, develop, and optimize data models and transformations using DBT
• Build and manage ELT (Extract, Load, Transform) pipelines using DBT and other tools
• Ensure data quality and integrity through testing and validation
• Collaborate with data engineers, analysts, and other stakeholders
• Optimize Snowflake (or other data warehouse) performance and cost
• Drive data architecture decisions and implement best practices