I applied online. The process took 2 months. I interviewed at Meta in Apr 2022
Interview
Recruiter called, spent about 2 months prepping really hard SQL questions and easy python questions. Phone screening went really quick. Some questions were not very clear, so that required more time for clarification. I explained my scripts, but that didnt seem to matter since they did not move me on to onsite. Questions were very easy SQL , they were not the ones on the career site or glassdoor, which are a little bit harder.
Interview questions [4]
Question 1
SQL Questions asking for groups having certain counts.
Python Question: function that pulls list and compares to parameter with amount. Display the total # of elements in the list with a total value less than the amount.
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.