Snowflake
Cloud data platform enabling data warehousing, data lakes, and data sharing.
4 Rounds
~21 Days
Hard
The Interview Loop
Recruiter Screen (30 min)
Standard fit check, behavioral questions, and resume overview.
Technical Loop (3-4 Rounds)
Deep dive into domain knowledge, coding, and system design.
Interview Question Bank
Software Engineer
•
Coding
•
hard
Implement a function that supports wildcard string matching with '?' and '*'. '?' matches any single character, and '*' matches any sequence of characters. Optimize it for large strings, simulating how a database engine might evaluate a complex LIKE clause.
#Dynamic Programming
#String Manipulation
#Greedy Algorithms
Software Engineer
•
Coding
•
hard
Write an algorithm to serialize and deserialize an N-ary tree. Assume this tree represents a SQL query execution plan where nodes are operators (Scan, Join, Filter) and edges are data flows.
#Trees
#Serialization
#Depth-First Search
Software Engineer
•
Coding
•
medium
Given a list of materialized views and their dependencies on other views or base tables, write a function to determine a valid build order. If a circular dependency exists, detect and report it.
#Graph Theory
#Topological Sort
#Breadth-First Search
Software Engineer
•
Coding
•
medium
Implement an algorithm to merge K sorted iterators. Assume this is part of an external sort operation where data exceeds available RAM, and you are merging sorted runs from disk.
#Heaps
#Pointers
#Sorting
Difficulty Radar
Based on recent AI-sourced data.
Meet Your Interviewers
The "Standard" Interviewer
Senior EngineerFocuses on core competencies, system constraints, and clear communication.
SimulateUnwritten Rules
Think Out Loud
Always explain your thought process before writing code or drawing architecture.