Snowflake Entry Level Data Scientist | August 2021

?
AnonymousNovember 26, 2021, 02:54 AM
Upvote
3
Downvote

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.

Snowflake
Data Scientist
I
Ichimoku
Top comment
Lorem ipsum dolor sit amet, consectetur adipiscing elit
sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.

Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.

Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.
F
Fibonacci
Sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et

quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est
I
Ichimoku
Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium 😀
F
Fibonacci
Sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et

quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est

Interview Guide

View the full Snowflake Data Scientist interview guide

Related posts

Amazon Manager Business Intelligence Manager | June 2021
Bristol Myers Squibb Senior Research Scientist | March 2021
UBS Senior Quantitative Analyst | April 2021
Amazon Entry Level Cloud Support Engineer Analytics | August 2022
There's so much more to Interview Query! Sign up to access hundreds of interview questions, expert coaching and a flourishing data science community.