I applied through a recruiter. The process took 4 weeks. I interviewed at Meta in Nov 2018
Interview
I had a phone interview and then a video chat coding challenge. I use CoderPad on my laptop and someone is also video chatting with me and can see what I code. It was using SQL. He first asked me, using a dataset, how I would define an "active user". After I gave my definition, he asked me to create the metric using SQL. Unfortunately for me, I gave a complicated way of defining an active user instead of just saying "someone who clicked 5 times". It's as if they ask you to run a mile, then after the mile, ask you to beat that time by running a second mile. Why not just evaluate the time you run the mile in? It made no sense to me
Interview questions [1]
Question 1
How would you define an active user using this dataset?
I applied through an employee referral. The process took 2 weeks. I interviewed at Meta (Tel Aviv-Yafo) in Dec 2018
Interview
FB Recruiter held a 30-min call describing the job, the interview process and what I am expected to encounter. Then, someone contacted me to get times possible for the first interview with the team leader. Afterwords, I was contacted to get my impression from the interview and describe how the process will continue next.
Interview questions [1]
Question 1
How, from this data, you'd identify certain types of users
I applied through an employee referral. The process took 2 months. I interviewed at Meta in Dec 2018
Interview
behavior + SQL, I was referred in early Oct and got response on Dec for phone screen. I got all answers correctly and clearly but failed, never understand. The referral system asked me to contact them if I didn't receive response within 2 weeks, and I contacted after 2 weeks of no response, and never heard back from referral system any more but got response together with online applicants after another two weeks.