I applied through an employee referral. The process took 3 months. I interviewed at Meta (Menlo Park, CA) in Mar 2018
Interview
One phone call and one onsite with 3 technical and 1 behavioral round.
Phone: Prepare and practice medium level algorithm questions (hint : leetcode).
For SQL, practice on multiple sites (Leetcode, HackerRank).
Take as much time as you need to feel confident in either topic. I took a month.
Onsite: The recruiter gives you the format, which is quite precise. Pay very close attention to the prep tips given by your recruiter. Prepare intensely based on that.
The onsite is indeed much harder and requires your basics to be very clear. Be ready to justify whatever you say. Each round can get quite intense, there are a lot of questions asked. Oh, and go prepared with a few questions for EACH person you are going to meet.
Interview questions [1]
Question 1
Data Modeling questions. Prepare many to many data modeling well.
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.