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
Begins with an application review and recruiter screening, followed by a technical phone interview that assesses SQL, data modeling, data warehousing, ETL processes, and coding skills in languages such as Python or Java. Successful candidates then proceed to onsite or virtual interviews, which include multiple rounds covering coding, system design, data architecture, problem solving, and behavioral questions.
Interview questions [1]
Question 1
Tell us about yourself and why you want to work for us
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.
