Company: Snowflake

Location: San Francisco, CA

Role: Data Scientist

Level: Entry Level

Outcome: Rejected

When did you have this interview?: 3 Months Ago

I had a recruiter screen, a hiring manager round, and then a technical round with SQL questions. I was rejected after the technical round.

What kind of technical questions did you get asked?

I was given 2 tables with orders and users and order items. There are many orders to one user and many order items to one order. Order items are total items in an order with quantity and price. I had to find orders placed 6 months back, histogram of users by total orders, and top users by the highest average number of unique items per order.