I applied online. The process took 2 weeks. I interviewed at Meta (San Francisco, CA) in Apr 2020
Interview
Applied online. Got call from initial recruiter who asked me a few general questions about my interests, asked me to describe myself etc - the usual. Setup initial remote interview
Initial phone interview conducted over coderpad screen sharing with interviewer on phone:
5 Python/Algorithm Questions
5 SQL Questions
Algo questions just a basic test to see if you know Python
SQL questions a little harder
Interview questions [1]
Question 1
5 Python questions e.g
Count number of possible substrings in a given string
5 SQL questions of medium/hard difficulty
I applied through an employee referral. I interviewed at Meta (Menlo Park, CA) in Jun 2020
Interview
phone screen followed by onsite Database and SQL data modeling , product sense python coding dictionaries lists
product sense analytics, various kind of graphs SQL joins aggregations medium complex questions on python coder's pad
Interview questions [1]
Question 1
Python replace the none value with last non null value
I applied through a recruiter. I interviewed at Meta (Palo Alto, CA) in May 2021
Interview
Two technical rounds. First was SQL/pyhton which was 1 hour. 3-4 python questions and 3-4 SQL question. Next round was pure SQL and also past experience. Last round with hiring manager which was technical, 1 python and 1 SQL question.
Interview questions [1]
Question 1
SQL question: given a table find the most recent transaction in the table.