Hello,
Please check the below position and reply back with the below details and updated resume if you are comfortable.
Title: Python & Snowflake Lead
Location: SFO, CA
Duration: Long Term
Who are we looking for?
We are looking for a 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
· Python
Secondary Skills
· Snowflake
Tertiary Skills
· Informatic 10.4
Process Skills:
· Must have total 8+ yrs. in IT and 3+ years' experience working as a Python Databases and 5+ years in Data warehouse, ETL, BI projects.
· Expertise in Python – data modelling, ELT using 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.