Snowflake Performance Engineer

Immediate need for a talented Snowflake Performance Engineer. This is a 02 Months Contract opportunity with long-term potential and is located in Sunnyvale, CA (Hybrid). Please review the job description below and contact me ASAP if you are interested.

Job ID:25-91327

Pay Range: $78 - $80/hour.  Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).
 
Key Responsibilities:

• Familiar with zero copy cloning and using time travel features to clone table
• Familiar in understanding Snowflake query profile and what each step does and identifying performance bottlenecks from query profile
• Understanding of when a table needs to be clustered
• Choosing the right cluster key as a part of table design to help query optimization
• Working with materialized views and benefits vs cost scenario
• How Client micro partitions are maintained and what are the performance implications wrt micro partitions/ pruning etc
• Horizontal vs vertical scaling. When to do what. Concept of multi cluster warehouse and autoscaling
• Advanced SQL knowledge including window functions, recursive queries and ability to understand and rewrite complex SQLs as a part of performance optimization

Key Requirements and Technology Experience:

• Skills-[Metadata, Teradata, Python, Virtual Warehouse (VW)]
• 8 Years of experience
• Strong ability to design and develop workflows in Client in at least one cloud technology (preferably, AWS)
• Apply Client programming and ETL experience to write Client SQL and maintain complex, internally developed Reporting system.
• Preferable knowledge in ETL Activities like data processing from multiple source systems.
• Extensive Knowledge on Query Performance tuning.
• Apply knowledge of BI tools.
• Manage time effectively. Accurately estimate effort for tasks and meet agreed-upon deadlines. Effectively juggle ad-hoc requests and longer-term projects.
• Has good knowledge on Client Architecture.
• Understanding Virtual Warehouses - multi-cluster warehouse, autoscaling
• Metadata and system objects - query history, grants to users, grants to roles, users
• Micro-partitions
• Table Clustering, Auto Reclustering
• Materialized Views and benefits
• Data Protection with Time Travel in Client - extremely imp
• Analyzing Queries Using Query Profile - extremely important (Explain plan)
• Cache architecture
• Virtual Warehouse (VW)
• Named Stages
• Direct Loading
• SnowPipe, Data Sharing, Streams, JavaScript Procedures & Tasks

Our client is a leading IT Industry and we are currently interviewing to fill this and other similar contract positions. If you are interested in this position, please apply online for immediate consideration.
 
Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

By applying to our jobs you agree to receive calls, AI-generated calls, text messages, or emails from Pyramid Consulting, Inc. and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy . J2W:CB3