Responsibilities
" • Has good knowledge on Snowflake Architecture. • Understanding Virtual Warehouses - multi-cluster warehouse, autoscaling • Metadata and system objects - query history, grants to users, grants to roles, users • Micro-partitions • Table Clustering, Auto Reclustering • Materialized Views and benefits • Data Protection with Time Travel in Snowflake - extremely imp • Analyzing Queries Using Query Profile - extremely important (Explain plan) • Cache architecture • Virtual Warehouse(VW) • Named Stages • Direct Loading • SnowPipe, Data Sharing,Streams, JavaScript Procedures & Tasks • Strong ability to design and develop workflows in Snowflake in at least one cloud technology (preferably, AWS) • Apply Snowflake programming and ETL experience to write Snowflake SQL and maintain complex, internally developed Reporting system. • Preferable knowledge in ETL Activities like data processing from multiple source systems. • Extensive Knowledge on Query Performance tuning. • Apply knowledge of BI tools. • Manage time effectively. Accurately estimate effort for tasks and meet agreed-upon deadlines. Effectively juggle ad-hoc requests and longer-term projects. Snowflake performance specialist - Familiar withzero copy cloningand usingtime travelfeatures to clone table - Familiar in understandingSnowflake query profileand what each step does andidentifying performance bottlenecks from query profile - Understanding of when a table needs to be clustered - Choosing the right cluster keyas a part of table design to help query optimization - Working with materialized views andbenefits vs cost scenario - How Snowflake micro partitions are maintained and what are the performance implications wrt micro partitions/ pruningetc - Horizontal vs vertical scaling. When to do what.Concept of multi cluster warehouse and autoscaling - Advanced SQL knowledge including window functions, recursive queriesand ability to understand and rewritecomplex SQLs as a part of performance optimization"
Technical Requirements
Mandatory skills* Snowflake Desired skills* Teradata/Python(Not Mandatory)
Preferred Skills
Cloud Platform->Snowflake
Technology->OpenSystem->Python - OpenSystem
Additional Responsibilities
Domain* Data Warehousing, Business Intelligence Precise Work Location Bhubaneswar, Bangalore, Hyderabad, Pune
Educational Requirements
Bachelor of Engineering,BCS,BBA,BCom,MCA,MSc
