I applied online. The process took 3 weeks. I interviewed at Meta in Dec 2021
Interview
Scheduled 45 minute interview with current data engineer. Asked two basic SQL question but used Python + Pandas to answer. Asked a few “product sense” questions to gauge approach to answering data science questions. Heavily suggest going to the pre-interview data science interview prep session.
Interview questions [1]
Question 1
Given a table of users and whom they sent friend requests to, what is the average number of friend requests sent in the last week?
I applied through a recruiter. I interviewed at Meta
Interview
Contacted by recruiter a month back. Phone screen last week. Some SQL, some Python coding. Onsite is in 2 weeks. Will include data modelling and SQL/ETL as well as behavioral round. Very helpful recruiter.
Interview questions [3]
Question 1
Write a function to count the number of times each character appears in a string and rewrite the string in that format. Eg. "I am back." should become "i1 2a2m1b1c1k1.1"
I applied through a recruiter. I interviewed at Meta (Seattle, WA) in Oct 2021
Interview
Phone screen a week go.
I was able to complete 3 SQL and the 4th one I was able to get the pseudo code done, the interviewer was ok.
I was able to complete 3 python.
I got an email later to set up the onsite.
I did not get any questions from glassdoor. But the questions were not that difficult, but not as straightforward too. Even thought I was able to complete only 3 questions SQL/Python I was able to explain my thought process and debug the code when there was an error and the interviewer was very helpful and friendly.
I don't think they expect you to solve all 5 from each and neither to write one line codes for all the problems. Be clear and have a discussion with the interviewer and listen to the hints.
Good luck, will update this after my onsite.
Interview questions [1]
Question 1
Easy to medium SQL/Python questions. lists/strings manipulation.