Snowflake Developer

Tata Consultancy Services; Dallas (TX); On-site; USD 110,000 - 120,000; Full time

Job summary

Tata Consultancy Services Limited in Dallas is seeking a Snowflake Developer to design and optimize data pipelines, transforms, and reporting on Snowflake. You will implement scalable data models and ensure secure, efficient data solutions.

You will collaborate with data engineering, analytics, and architecture teams, write complex SQL, tune queries, manage Snowflake objects, and support governance, CI/CD, and semi-structured data work.

Qualifications

• Strong hands-on Snowflake development experience.
• Excellent SQL skills and Snowflake query performance tuning.
• Experience with Snowflake objects: databases, schemas, tables, views.
• CI/CD pipelines for Snowflake deployments and IaC familiarity.

Responsibilities

• Develop and maintain data pipelines and transformation workflows in Snowflake.
• Write efficient SQL queries, views, stored procedures, and reusable components.
• Load, transform, and manage structured and semi-structured data in Snowflake.
• Support data ingestion using Snowpipe, Streams, and Tasks.
• Optimize query performance, warehouse usage, and job execution.
• Support data modeling activities for analytics and reporting requirements.
• Implement secure data access using roles, grants, masking policies, and secure views.
• Troubleshoot pipeline failures, data quality issues, and production support incidents.
• Participate in code reviews, testing, and deployment activities.
• Collaborate with business and technical teams to translate requirements into implementation.

Skills

Snowflake development

SQL development

Snowpipe/Streams/Tasks

Stored procedures/UDFs/Views

Snowflake security/access control

CI/CD for Snowflake deployments

ETL/ELT data pipelines

Time Travel/Zero-Copy Cloning

Semi-structured data handling

Job description

Snowflake Developer

Roles & Responsibilities

Generic Managerial Skills, If any

Should have strong hands-on experience in building and supporting data pipelines, transformations, and reporting solutions on Snowflake. The ideal candidate should have excellent SQL skills, a strong understanding of Snowflake features, and the ability to develop reliable, efficient, and secure data solutions. This role will work closely with data engineering, analytics, and architecture teams to support business data needs. Day-to-day responsibilities include designing scalable data models, building and maintaining pipelines, improving data governance, and collaborating with cross-functional teams to ensure efficient data workflows. Additional responsibilities will include troubleshooting, addressing performance issues, and implementing best practices for data security and compliance.

Key Responsibilities

• Develop and maintain data pipelines and transformation workflows in Snowflake.
• Write efficient SQL queries, views, stored procedures, and reusable components.
• Load, transform, and manage structured and semi-structured data in Snowflake.
• Support data ingestion and processing using Snowpipe, Streams, and Tasks.
• Optimize query performance, warehouse usage, and job execution.
• Support data modeling activities for analytics and reporting requirements.
• Implement secure data access using roles, grants, masking policies, and secure views.
• Troubleshoot pipeline failures, data quality issues, and production support incidents.
• Participate in code reviews, testing, and deployment activities.
• Collaborate with business and technical teams to translate requirements into implementation.

Mandatory Skills

• Strong hands-on experience in Snowflake development.
• Strong SQL development and debugging skills in Snowflake.
• Experience with Snowflake objects such as databases, schemas, tables, views, virtual warehouse
• Hands-on experience with Snowpipe, Snowspark, Streams, Tasks, Dynamic Tables or Materialized Views.
• Experience in writing and maintaining stored procedures, UDFs, and views.
• Experience with Snowflake data sharing and replication.
• Experience with CI/CD pipelines for Snowflake deployments, Git, DevOps practices, and Infrastructure as Code.
• Experience with ETL/ELT processes, data integration, and building data pipelines.
• Good understanding of query optimization and performance tuning in Snowflake.
• Experience handling semi-structured data such as JSON, Avro, Parquet, or ORC in Snowflake.
• Experience with Snowflake security and access control concepts, including roles, grants, masking policies, and secure views.
• Experience with Time Travel and Zero-Copy Cloning.
• Strong understanding of data loading, transformation, and operational support in Snowflake.
• Ability to troubleshoot and resolve Snowflake-related development issues independently.
• Good communication and collaboration skills.
• Experience working in agile teams.

Salary Range- $110,000-$120,000 a year

Location: Dallas, TX

Function: TECHNOLOGY

Role: Engineer

ID: 434283

Skills: SQL

Salary Range: $110,000 - $120,000