Snowflake Administrator

Must have a total of 6+ yrs. in IT and 3+ years' experience working as a Snowflake Developer/Admin

•  Must have experience at least one end to end implementation of Snowflake cloud data warehouse and 3 end to end data warehouse implementations on-premise preferably on MS SQL server.

•  Expertise in Snowflake – data modelling, ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL concepts

•  Expertise in 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

•  Expertise in deploying Snowflake features such as data sharing, events and lake-house patterns

•  Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, Big Data model techniques using Python

•  Experience in Data Migration from RDBMS to Snowflake cloud data warehouse

•  Deep understanding of relational as well as NoSQL data stores, methods and approaches (star and snowflake, dimensional modelling)

•  Experience with data security and data access controls and design

•  Hands-on data modeling capability for BI reporting

•  Experience with AWS or Azure data storage and management technologies such as S3 and ADLS

•  Build processes supporting data transformation, data structures, metadata, dependency, and workload management

•  Proficiency in RDBMS, complex SQL, T-SQL, performance tuning and troubleshoot

•  Provide resolution to an extensive range of complicated data pipeline related problems, proactively and as issues surface

•  Must have expertise in AWS or Azure Platform as a Service (PAAS)

•  Must have strong communication skills