Experience in Snowflake Data warehouse - data modeling, ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL concepts
Have created flexible and scalable snowflake model
Experience with Snowflake utilities, SnowSQL, SnowPipe and Big Data model techniques using Python
Have experience at least two end-to-end implementation of Snowflake cloud data warehouse.
Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel and understand how to use these features
Should have good understanding of 3NF and Star schema
Preferred to have expertise in any one of the programming language Python/Java/Scala
Able to develop and maintain documentation of the data architecture, data flow and data models of the data warehouse appropriate for various audiences. Provide directions on adoption of Cloud technologies (Snowflake) and industry best practices in the field of data warehouse architecture and modeling.
Certified SnowPro (Desirable).
Able to troubleshoot problems across infrastructure, platform and application domains.
Should be able to provide technical leadership to large enterprise scale projects.