I applied through an employee referral. I interviewed at Meta (Phoenix, AZ) in Oct 2018
Interview
This is a phone call interview for HR screen. It is scheduled for 15-20 minutes. I thought they will ask some behavior questions and ask about my resume. But they didn't, they directly ask me SQL and database questions. They asked very short question, sometimes I just need to answer Yes or no, True or False, sometimes I just need to tell them the SQL command. I was very surprised that it's in this type of format.
Interview questions [1]
Question 1
1. the ORDER BY command in SQL is automatically set in what format if you didn't set it? Ascending or Descending?
Answer: Ascending
2. When you want to delete or add a column of a table in a database, what command you will use?
Answer: ALTER
3. this question about about LEFT JOIN, they ask what command you want to use if you want to keep all the info of the left table?
Answer: left join
4. You want to combine two column after removing two duplicates, use UNION or UNION ALL?
Answer: UNION
I applied online. I interviewed at Meta (New York, NY)
Interview
Prepare technical concepts, and practice previously asked questions as much as you can find online. 4 rounds in the total process. It's easy as long as you just practice a LOT.
I had Python and SQL round for 30 minutes each. The interview was for 1 hour 30 minutes for SQL and 30 mins for python coding.
Completed 5 questions each but still got rejection email the next day.