I applied online. I interviewed at Meta in Sep 2024
Interview
Recruiter round: recruiter might ask some basic fundamental SQL questions.
1st round: 25 minutes for 4 SQL questions (easy). You need to be very fast and get to solution very quickly. communication wasn't priority here.
another 25 minute for 2 programming questions. leetcode easy to medium rated questions.
Interview questions [1]
Question 1
SQL: first 2 question requires some aggregations. later questions requires joining.
Programming: given a number return biggest odd number out of it by rearranging digits.
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.