This is the first round of interview I'm writing about. The result is yet to come, so I'll update my progress later. I was contacted in the past regarding the interview and my old recruiter connected me to this new recruiter. She was pretty friendly and walked me through the life at FB and patterns. She scheduled for a phone interview. Based on my recruiter answering 3-4 questions of SQL (Postgre not MySQL) and Programming problems each in a total of 50 minutes should put you ina good spot , though you're asked to prepare for 5 each in 50 minutes.
I'd recommend medium level SQL (questions on Leet Code and Easy - Medium Programming questions. I chose Java.
Questions d'entretien [2]
Question 1
SQL - I was given 4 tables Sales, Product, Promotion and something else (Never had to use it).
1. Which product had the highest sales with promotions and sales ( basically a where clause on 2 flags)
2. What % of sales happened on the first and last day of promotion.
I don't remember the rest.. I'd say your ability to translate regular english statements into SQL is tested very well
J'ai postulé en ligne. J'ai passé un entretien chez Meta (New York, NY)
Entretien
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.
J'ai postulé en ligne. J'ai passé un entretien chez Meta
Entretien
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.
