I applied through a recruiter. The process took 6 weeks. I interviewed at Meta (New York, NY) in May 2018
Interview
Phone interview was quite easy. Standard sql and some basic python problems. On-site interview was pretty intense but not too grueling. 3 technical 1-hour interviews consisting of python, sql, and dimensional modelling. An hour long lunch meet and greet with a FB DE . Also one hour qualitative interview with a PM.
Interview questions [2]
Question 1
given some sample web UI log data, write a SQL query to answer various questions
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.