I applied through an employee referral. The process took 3 weeks. I interviewed at Meta in Aug 2024
Interview
The interview process was smooth but I wasn't fast enough to crack it. There ain't much resources available to know for sure which topics to omit and which ones not to. Phone screen happens in two sections. 25 minutes for SQL and 25 minutes for coding. Always listen to the hints provided by the interviewer. Keep a calm head. For practice, leet code is the best source though you wouldn't find the exact questions there. For SQL, there ain't any good ones. Don't waste your money on Stratascratch premium.
Interview questions [1]
Question 1
SQL questions focusing aggregations, sub query with varying difficulties. For coding, make sure you have the foundation set.
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.