HR call, Phone screen, and VO almost 4 loops. signed NDA so cant tell detail, but this role mostly request you have a great fundation of sql and python. and they are not requiring you to know fancy algo but they want you to extremly knowing data structure and how you can use SQL to calculate metrics.
Interview questions [1]
Question 1
LC M Questions but cant use window function to solve.
I applied through an employee referral. The process took 2 weeks. I interviewed at Meta (San Francisco, CA) in Aug 2024
Interview
Had a recruiter call, asked 10 sql and python concepts, second was speed coding round, 5 sql and 5 python, was an elimination round. you have to code at least 3 sql and 3 python to pass with working solutions, its on coderpad.
Typical recruiter screening, followed by phone screen. 3 SQL and 3 python questions. SQL is medium to hard level and python is easy to medium.
Practice SQL on Percentages and aggregations