I applied online. The process took 3 months. I interviewed at Meta (Menlo Park, CA) in Jan 2024
Interview
Recruiter call for brief introduction
First round technical that was for one hour, 30 mins sql, 30 mins python
Follow up for my python coding
Final round for 4 hours (leadership, technical)
Interview questions [1]
Question 1
first round of technical interview passed then did not hear back after I gave the final round.
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 through a recruiter. The process took 2 months. I interviewed at Meta in Aug 2024
Interview
Phone Screening - 1 hr (3 SQL, 3 Python)
Onsite:
Behavioral (Ownership) (1 Round) - Why, When, What, How (Related to Past Experience)
Technical Interview (3 Round) - Product Sense, Data Model & SQL based on the same theme, Python related to a Streaming Problem (Dict, Set, List)
Easy Questions with a lot of pressure
Interview questions [1]
Question 1
1. Tell me the time,
2. Act like Product Manager and think for product
3. SQL (Joins, Aggregated, SubQuery)