Meta Data Scientist, Analytics University Grad interview questions

Fairly transparent interview process. If you give yourself enough time to prepare using their official material, you can easily qualify and get an offer. First Round[ Recruiter call ]: Asked Questions like data project, past experience, SQL basic MCQs like joins, distinct, where, having and product analytics question. i.e. identify the best friend of a Facebook user and customize the newsfeed for him. Second Round [Technical round]: 2 SQL queries based on joins and wheres and case when - Interaction count on the relation of a friend for newsfeed, avg interaction count for a user ABC. Product Analytic Question: Newsfeed engagement metric down by 10%, Find out why.