Snowflake Data Engineer

Tata Consultancy Services Limited; Hyderabad; On-site; INR 2,000,000 - 3,500,000; Full time

Job summary

Tata Consultancy Services Limited in India is seeking an experienced Data Warehouse professional specializing in Snowflake. The role requires hands-on design, implementation, and migration of enterprise workloads to Snowflake DWH, with strong SQL and data modeling skills and exposure to Cortex features.

The candidate will work as an individual contributor, collaborating with business and IT teams, handling data ingestion via IICS, and leveraging Snowflake features like Streams, Time Travel, and

Qualifications

• 5+ years of relevant work experience in any Data Warehouse Technologies.
• 2+ years of experience in designing, implementing, and migrating Data/Enterprise/Engineering workloads on to snowflake DWH.
• Should be able take the requirements from Business , co-ordinate with Business and IT Teams on clarifications, dependencies and status reporting
• Experience on latest snowflake features like Cortex and other new features
• Should have experience taking source data from S4 HANA and load to snowflake
• As an individual contributor, should be able Create, test, and implement business solutions in Snowflake
• Strong in writing snowflakes stored procedures, views, UDF's etc.
• Hands on experience in Data Modeling
• Expert in SQL and Performance tuning techniques of queries
• Experience on ingestion techniques using ETL tools (IICS) and Snowflake's COPY/Snowpipe/StreamLit Utility
• Good exposure of handling CDC using Streams, TimeTravel
• Proficient in working with Snowflake Tasks, Data Sharing, Data replication

Skills

Snowflake

SQL

Data Modeling

Performance Tuning

CDC & TimeTravel

DevOps CI/CD

Tools

Azure DevOps

GitLab Actions

Snowpipe

Snowflake Tasks

Streams

Job description

MUST HAVE

• At least 5+ years of relevant work experience in any Data Warehouse Technologies
• At least 2+ years of experience in designing, implementing, and migrating Data/Enterprise/Engineering workloads on to snowflake DWH.
• Should be able take the requirements from Business , co-ordinate with Business and IT Teams on clarifications, dependencies and status reporting
• Experience on latest snowflake features like Cortex and other new features

• * Should have experience taking source data from S4 HANA and load to snowflake
• * As an individual contributor, should be able Create, test, and implement business solutions in Snowflake

• Strong in writing snowflakes stored procedures, views, UDF's etc.
• Experience in implementing Devops/CICD using Azure Devops / GITLAB Actions is preferred.
• Hands on experience in Data Modeling
• Expert in SQL and Performance tuning techniques of queries
• Experience on ingestion techniques using ETL tools (IICS) and Snowflake's COPY/Snowpipe/StreamLit Utility
• Good exposure of handling CDC using Streams, TimeTravel
• Proficient in working with Snowflake Tasks, Data Sharing, Data replication