Candidate should have proven experience of working in Snowflake SQL
Candidate should be well versed with basic and advanced SQL e.g. join types, SQL performance tuning, recursive CTEs, Variables, Windows functions, Procedures, User Defined Functions
Candidate should have good understanding of Snowflake core concepts such as Micro Partitioning, Three tier Architecture, Virtual Warehouse, Auto Clustering, Data Protection, Data Encryption etc
Candidate should posses hands on experience for creating Snowflake objects such as Storage Notification integration, external stage, secure views, tags, row access policies, procedures, shares, pipes, streams, tasks
Snow Pro Core Certification is good to have
Good to have Basic understanding of Python / PySpark Pandas libraries would help