I applied through a recruiter. The process took 2 weeks. I interviewed at Meta in Oct 2017
Interview
Interviewed two times in last two years. Both times same experience and same disappointments and same type of questions and same mistakes by me.
Initial recruiter interview. She asked a rapid round of 5-6 SQL and programming questions and scheduled technical phone Interview which consisted 30 Min SQL and 30 min programming sessions. They use coderpad.io throughout a telephonic interview.
Questions were not too difficult not too easy but the expectations were high that you keep talking and keep explaining your thought process and make it interactive session. You stumble little or not sure about something or little uncertain about a particular concept and you are gone. You are not going to make to an onsite interview. This is what happened to me. I was nervous during the start of my SQL rounds and stumbled a couple of times on easiest join problems.Beacuse of nervousness, I couldn't even think of simple join for which I write queries every day 100 times at my job. Later for programming, I recovered but I already had done damage. Interestingly I got all my answers right in both SQL and programming but still, I couldn't make to onsite. They want perfection in typing, coding, thinking. Little here and there and you miss the train. They want you to give solutions within one attempt without rewriting or rerunning solutions. So if you have that perfection then you can make it to onsite. Questions were just average and even college graduates can get solutions
Interview questions [1]
Question 1
Questions were exactly similar to what discussed here by other users. 3-4 SQL and 2-3 programming problems based on your speed in 30-30 minute sessions
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.