Snowflake Data Engineer- DBT

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

Job summary

Tata Consultancy Services in Chennai is seeking an experienced Data Engineer with 5+ years of hands-on experience in Snowflake, SQL, and DBT to design and optimize data pipelines and warehouses.

You will work across AWS/Azure/GCP clouds, implement ETL processes, and ensure data quality and reliability for cross-functional teams. This on-site role demands strong collaboration and problem-solving skills to manage scalable data architectures.

Qualifications

• 5+ years of experience in data engineering or similar.
• Proficiency with Snowflake and SQL for data manipulation.
• Experience with ETL tools such as Informatica or DBT.
• Strong knowledge of data warehousing concepts and architecture.

Responsibilities

• Build and maintain scalable data pipelines for extracting, transforming, and loading data from multiple sources into Snowflake.
• Design Snowflake architecture and optimize data storage for performance and cost.
• Collaborate with cross-functional teams to ensure data quality and reliability.
• Implement data migration processes and validate data across environments.
• Monitor ETL pipelines and resolve performance or data integrity issues.

Skills

Snowflake

SQL

PL/SQL

ETL

DBT

Data warehousing

Cloud platforms

Data pipelines

Tools

Snowflake

DBT

Informatica

Azure

AWS

GCP

Job description

Role: Snowflake, DBTDesired Experience Range: 5+ years

Location: , Chennai,

Roles Responsibilities-

• Proficiency with AWS/Azure/GCP, Snowflake, PL/SQL
• Strong experience in Snowflake, SQL for data manipulation and engineering tasks.
• Strong Expertise in SQL and Snowflake architecture
• Experience in ETL tools Informatica / DBT
• Experience in one or more cloud platforms Preferably Azure /AWS/GCP
• In-depth knowledge of data warehousing concepts and experience in building and managing data warehouses.
• Knowledge in ETL concepts - needs to manage data migration into Snowflake. This includes extracting data from various sources, transforming it into a usable form, and loading it into the Snowflake platform.
• Design, develop, and maintain scalable data pipelines for extracting, transforming, and loading data from various sources to ensure seamless data flow and accessibility.
• Collaborate with cross-functional teams to integrate data from multiple disparate sources, ensuring consistency, accuracy, and reliability of data.
• Optimize data processing workflows and storage solutions for performance, scalability, and cost-efficiency
• Implement data quality checks and validation processes to ensure the accuracy, completeness, and consistency of data throughout the data lifecycle.
• Monitor the performance of data pipelines and infrastructure, identifying and resolving issues to maintain system stability and reliability.