I applied through a recruiter. I interviewed at Meta (Menlo Park, CA) in Jul 2020
Interview
Recruiter(reached me over linkedin) called me to understand my work experience and how comfortable I am with SQL and Python.Asked some 5 sql and 5 python question to qualify for next round.Then He forgot to schedule my telephone interview for 3 days. I had to chase him over linkedin. finally it got scheduled after 3 weeks of time. I was able to solve 4 SQL /3 coding will all cases passed. It is been more than a week , the recruiter is no longer responding and I have no idea what happened .(I am assuming I am rejected but no formal email). I am really surprised with Facebook interview structure or may be I was out of luck.
Interview questions [2]
Question 1
SQL : questions are already on glassdoor can be solved using AVG, COUNT , LEFT JOIN , MULTI table join. Mostly focus on %age type questions
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.