I applied through an employee referral. I interviewed at Meta (Menlo Park, CA) in Oct 2024
Interview
1 Phone screen - 1hour
Final Loop - 3 tech, 1 behavioral
Meta is all about coding and tech, no LP *******.
Phone screen -
Do minimum of 6 questions (3 SQL and 3 python) out of 10 questions
You'll pass if you get 5 right, or else reject. simple as that.
Final loop -
Tech rounds - 2-3 SQL, 1-2 python, and product design / dimensional modeling.
Behavioral - 30mins, don't waste time on stories. be yourself and answer straight to the point.
Interview questions [1]
Question 1
Product design - uber, netflix, youtube, fb videos, whatsapp etc.
CTE, subqueries, full outer join on user session tables, case statements.
Do the stratascratch meta tagged questions and you should be fine.
Python - list and dictionary manipulations.
Starts with a screen, followed by leetcode style SQL+Python questions, Full loop of SQL, Python, SQL plus Python and lastly behavioural round. Every round is also an architecture round in some sense.
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.