Snowflake Developer || Chennai

HCL Tech is hiring for Snowflake developers || Chennai || Immediate joiners

Experience: 3 to 9 Years

Notice period : Immediate to 30 days

Cloud Basics

Basics of Cloud Computing, IaaS, PaaS, SaaS

Required

Competent - Has Good understanding in the subject area, Observed Good Hands-on/Troubleshooting skills, Good Coding/Scripting Skills, design understanding

Data warehousing concepts

Understanding about the data warehousing, SCD, Multidimensional Analysis.

Required

Proficient - Has Deep understanding in the subject area, Excellent Hands-on/Troubleshooting/Coding skills, Good Understanding of Framework, solution focused approach

Snowflake Web UI and ecosystem

Use of Classic Web UI or Snowsight, snowsql, connectors/integration with other tools or technologies

Required

Proficient - Has Deep understanding in the subject area, Excellent Hands-on/Troubleshooting/Coding skills, Good Understanding of Framework, solution focused approach

Snowflake Architecture

Expert understanding about 3-layer artchitecture, Micro Partition & Clustering, Cache Management, Virtual Warehouse, Metering

Required

Competent - Has Good understanding in the subject area, Observed Good Hands-on/Troubleshooting skills, Good Coding/Scripting Skills, design understanding

Snowflake

Usage of most widely used features like Tables, Views, MV, Functions, Procedures, TT/FS, DDM, PIPE, STREAM, TASK, Bulk Loading and Real-time Data handling, SQL Queries, Handling of structured and Semi-structured data and Unstructured data, Dynamic Tables, Different types of Sharing, Creation/Use of different integrations like Storage, Notification, Applications etc for External Storage, External Functions etc. Performance tuning

Required

Proficient - Has Deep understanding in the subject area, Excellent Hands-on/Troubleshooting/Coding skills, Good Understanding of Framework, solution focused approach

Unit and Integration Testing

Unit and Integration test cases and test run of Snowflake jobs

Required

Competent - Has Good understanding in the subject area, Observed Good Hands-on/Troubleshooting skills, Good Coding/Scripting Skills, design understanding

Industry best practices

Reusable code/functionality creation, error handling, testing, code review, etc.

Required

Competent - Has Good understanding in the subject area, Observed Good Hands-on/Troubleshooting skills, Good Coding/Scripting Skills, design understanding

Project Description

End-to-end design and implementation, Code Migration strategy, Production bug fix strategy

Required

Competent - Has Good understanding in the subject area, Observed Good Hands-on/Troubleshooting skills, Good Coding/Scripting Skills, design understanding