Facebook Data Analyst | January 2021
?
•Anonymous••Upvote
2
Downvote
Company: Facebook
Position: Data Analyst
Location: nan
Level: Associate/Entry Level
Outcome: Techncal Screen Rejected
How was the interview process? What was it like?
Be sure to think out loud, the interviewer will help you get to the answer and help clarify. CoderPad was easy to use. I gave myself a 6/10 performance - should have studied SQL more.
What technical questions were asked?
SQL / Analytics, Product Metrics and Analytical, Business Case and Strategy
What was one of your solutions?
#1 SELECT count(r.notif_id)/count(a.notif_id) FROM users LEFT JOIN notifs ON ? = ? - cant remember the answer for sure #2. SELECT COUNT (Distinct notif_id), date FROM notifications WHERE ? = ? GROUP BY date
Facebook
Data Analyst
There's so much more to Interview Query
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.
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
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