I applied through an employee referral. I interviewed at Meta
Interview
15 Minutes of HR phone call about our background and 4 basic high-level SQL questions.
Later, a 45 minutes Video Conference interview with 50% Technical (SQL) and 50% Analytical (Business & Products).
I applied through an employee referral. The process took 4 weeks. I interviewed at Meta (San Jose, CA) in Jun 2021
Interview
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.
Interview questions [1]
Question 1
Product Analytic Question: Newsfeed engagement metric down by 10%, Find out why.
I applied through an employee referral. The process took 1 day. I interviewed at Meta (New York, NY) in Nov 2019
Interview
We had a phone interview to talk about my experience and some questions related to my personal interest and detail of projects. They also allow you to ask related questions about the position.
Interview questions [2]
Question 1
Which syntax of SQL is used to slice dataset into several chunks
