Facebook Data Analyst | January 2021
Position: Data Analyst
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