Snowflake Interview Questions

Note: ensure you read the disclaimer on the previous page reading the accuracy and sourcing of these problems.

Find Duplicate Words

A very common interview challenge is to determine how often words appear in a given string or set of strings. Here's a version of this: return a list of duplicate words in a sentence. For example, given 'The dog is the best' , returns "the" . Likewise, given 'Happy thanksgiving, I am s...

Difficulty: 4/10

Detect An Undirected Graph Cycle

Can you detect a cycle in an undirected graph? Recall that an undirected graph lessons simple reference to graphs is one where the edges are bidirectional. A cycle is one where there is a closed path, that is, the first and last graph lessons simple reference to graphs vertices can be the...

Difficulty: 9/10

Fibonacci Sequence

Implement a function that returns the Fibonnaci number for a given integer input. In a Fibonacci sequence, each number is the sum of the two preceding ones. The simplest is the series: 1, 1, 2, 3, 5, 8, etc. This is because: fibonacci 0 0 fibonacci 1 1 fibonacci 2 1 fibonacci 3 ...

Difficulty: 4/10

Array Intersection

As we ease our way into the course, we'll want to start with the basic data structures and their operations. However, don't be fooled how fundamental these things are! Interviewers will often test you on things that are deceptively easy. We saw this in Reverse a String challenges reverse a stri...

Difficulty: 2/10

Grab a Random Node

Given a linked list, can you write a method to get a random node within it? Let's assume you're given a random node generator. The linked list will have at least 2 nodes, and may look something like this: 1 2 3 4 The odds of getting any number between 1 and 4 inclusive should b...

Difficulty: 4/10

Serialize and Deserialize a Binary Tree

Given a binary tree representation, can you come up with a method to serialize the tree and then deserialize it to get the exact same tree? What is Serialization and Deserialization? Serialization is a process that converts a data structure to a suitable format that can be stored either ...

Difficulty: 8/10

Balanced Brackets

As a software engineer, you'll often be asked to optimize programs. One of the easiest ways to do so is by the introduction of an additional data structure. Here's another classic problem along the same vein. We're provided a string like the following: " " that is inclusive of the following ...

Difficulty: 5/10

Course Prerequisites

Here's a classic challenge that comes up in real life interviews surprisingly often. Interviewers like it as a way to assess your ability to find the right data structure for a non obvious and non trivial use case. The prompt is as follows: you're a university student currently trying to plan th...

Difficulty: 8/10

Targets and Vicinities

You're playing a game with a friend called **Target and Vicinity**. *Target and Vicinity* consists of one person thinking up a number in their head, and the other guessing that number. Sounds simple enough the caveat is that we also want to credit close guesses. To estimate the proximity of the ...

Difficulty: 6/10

Introduction to Data Engineering

What is Data Engineering? Data Engineering is a field that focuses on the design, development, and maintenance of the technological infrastructure required to efficiently manage data within an organization. Data Engineers play a crucial role in ensuring that data is available, accessible, and p...

Difficulty: 5/10

Data Modeling and Design

Introduction to Data Modeling Data modeling is a crucial aspect of data engineering that involves designing the structure of a database and defining the relationships between different data entities. It serves as a blueprint for storing, organizing, and manipulating data efficiently. In the fi...

Difficulty: 5/10

Data Monitoring and Performance Optimization

Introduction to Data Monitoring Data monitoring is a critical aspect of the data engineer's role. It involves tracking, analyzing, and managing data to ensure its accuracy, reliability, and timeliness. By monitoring data, engineers can identify potential issues, detect anomalies, and take proact...

Difficulty: 5/10

Interview Reports

Life at Snowflake | Snowflake Careers...

Life at Snowflake - Values, Culture, Benefits, and more! Our values aren’t just words on a wall; we choose to live these values every single day. We’re passionate about our people, our customers, our ...

Life at Snowflake: My internship experience...

Hi! I am Amogh, and I’d like to share my internship experience with Snowflake. Before I begin, let me quickly tell you about myself.

Snowflake Interview Questions | Glassdoor...

Snowflake interview details: 145 interview questions and 126 interview reviews posted anonymously by Snowflake interview candidates.

People at Snowflake Say

This information was sourced from reviews originally posted on Glassdoor.

Criticism is generally welcomed and people are consensus oriented

I like that there are so many interesting engineering problems to solve. And the culture is very open. Also the leadership is focused on growing the product while not compromising on usability, security and performance.

the engineering team consists of many bright people which gives an employee to learn a lot. as this is still a relatively small company, everyone can make an impact. work culture is great and people treat each other with respect. employees also her enough freedom to have a great work-life balance. management typically reacts very well to negative feedback.