Report this job

---

What is the problem? *

Incorrect company
Incorrect location
Job is expired
Job may be a scam
Other

Role: Snowflake Module lead / Lead

Location- SFO, CA

Duration: Long term

We are looking for a Snowflake Module lead / Lead, who will be responsible to design, develop various Data Integration & Data warehouse projects in snowflake. Ensure new features and subject areas are modelled to integrate with existing structures and provide a consistent view. Develop and maintain documentation of the data flow and data models of the data warehouse appropriate for various audiences.

Technical Skills:

Primary Skills

• Snowflake

Secondary Skills

• Informatic 10.4

Tertiary Skills

• Python

Process Skills:

• Must have total 8+ yrs. in IT and 3+ years' experience working as a snowflake Databases and 5+ years in Data warehouse, ETL, BI projects.
• 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
• 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)
• Proficiency in RDBMS, complex SQL, PL/SQL, Unix Shell Scripting, performance tuning and troubleshoot
• Should be able to troubleshoot problems across infrastructure, platform and application domains.

Skills:

• Resolve technical issues of projects and Explore alternate designs
• Participates as a team member and inter-group coordination within the modules of the project.
• Effectively collaborates and communicates with the stakeholders and ensure client satisfaction
• Train and coach members of project groups to ensure effective knowledge management activity.

Certification:

• SnowPro (desired)