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)
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.