I applied online. The process took 2 weeks. I interviewed at Meta (San Francisco, CA) in May 2020
Interview
I did first phone screen interview, half an hour for python coding and half an hour for sql. The python coding questions was fairly easy, just make sure to review python built in data structures and their method. However the sql questions was not that easy. The schema kept changing for each question and it was hard to do the queries in such a short time, 5 min for each question. I did not get selected for the next round
Interview questions [2]
Question 1
python data structures such as sets, dictionary, list, string, etc
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.