The interview takes about 15 minutes, which I found fast compared to how much I prepped for it
What happened in the phone interview:
Recruiter first asked me to make a high-level description of the last 2 jobs on my resume , specifically what my core responsibilities were. She only let me talk for about a minute on each and interrupted me if I went long. I think she just wanted the high level info.
She then told me about the specific role, how it interacts with product and leaned heavily on how crossfuntional/ collaborative the role is and that I should expect that.
She then asked me a product/ DS question:
How would you determine who a person’s best friend is on Facebook?
She expected a very quick answer and asked me to give her the 3 most important factors/ metrics I would use here without unpacking the question fully.
Then there are 5 sql questions that are quick to ask and answer. What is the default order of Order by, what is the output of inner join, count(distinct), null + 1, and union.
After I finished answering the SQL questions, the recruiter directly told me I would go on to the video screen and to wait for details.
Has anyone done the video screen?