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.
Interview questions [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
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.
It was a contractual job , so the contractors reached out , they needed only SQL & Python proficiency. They explained the requirement and arranged the interview based on my availability.They were pretty efficient.I
Top companies for "Compensation and Benefits" near you
