I applied through a recruiter. I interviewed at Meta
Interview
Phone internerview, they asked three question, statistics, sql and programming . The recruiter was very nice and helpful thru out the process, no problems at all, it was lite.
Interview questions [1]
Question 1
Explain A/B testing, explaining WHERE statements and things like that. For programming they asked basic questions such how revert a string and etc..
I applied online. I interviewed at Meta (New York, NY) in Mar 2020
Interview
A recruiter contacted me over email and set up a phone interview for the following week for a 15-minute call. I guess next round would have been with a hiring manager
Interview questions [1]
Question 1
PLEASE DON'T TAKE THE PHONE SCREENING LIGHTLY! I did and got rejected. I was expecting SQL questions and in general talk about my resume but she asked me a question on product sense and I was completely unprepared for it. Creation of Facebook user groups has gone down by 20%, what will you do? sounds simple but I messed it up so badly. I was just blabbering anything in an unstructured way, I sounded so stupid and not even fit for a small company forget Facebook. The recruiter was nice and she did not say anything but I were to hear my own answer, I would reject myself on spot. I regret it so much wish I could have prepared for it. I hope someone sees this and it helps them.
The SQL questions were easy and I did answer them correctly- what kind of joins to get only common rows, what the natural sorting order etc.
I applied through an employee referral. The process took 2 months. I interviewed at Meta (Londres, Inglaterra) in Mar 2019
Interview
As it often happens, the interviewer was late about 6 minutes (it was a online call). We had a shared screen and I was given some tables for me to query from.
There was no compiler I could see, meaning that if something wasn't right I couldn't really know unless he would tell me. He did for the first one, and I corrected it but he didn't tell me anything about the second query not being right. I agree that I should've corrected it by taking a second look at it, but since the interviewer didn't point out any mistake in the second query, why should I bother while I very well knew I was under time pressure for further questions.
Interview questions [4]
Question 1
Given a table containing date, post_id, relationship (e.g. Friend, Group, Page), interaction (like, share etc.) and a table containing poster id and post id, calculate: how many likes were made on friend posts yesterday