Facebook Senior Data Scientist | September 2021
Location: Remote, OR
Role: Data Scientist
When did you have this interview?: Last Week
2 SQL questions and 1 product sense
What kind of technical questions did you get asked?
SQL: Given 2 tables, find the number of users that accepted friend requests in the past 4 weeks
Within the same table and given another table of user id and age group , find the avg number of requests sent per age group within the last week.
The friend acceptances have dropped by 15%. How would you investigate this and what report will you provide to management. Say that they decide to change the algorithm ranking to uprank friend suggestions, how would you evaluate if this works?