I applied through other source. I interviewed at Meta in Apr 2020
Interview
There was one phone screen. The on-site was remote and I had three coding interviews and a system design interview. I almost got the offer (successful interviews) but did not pass hiring committee.
Several stages, professional process, several technical questions. communication was done via email and phone calls. Multiple interviews both in person and via zoom. I would say that the process in general was positive.
The first round was HR discussion, the second round was technical coding, we jumped right into coding without any discussion. Time was limited, I did have a couple of approaches to solve but was not able to complete it in the given time of 30 minutes
Interview questions [1]
Question 1
Given a string “SELECT c1,… FROM (SELECT c2,… FROM (…) WHERE c2=v2,…) WHERE c1=v1,…”, format to the following by inserting "\n" and "\t":
“SELECT
c1,…
FROM
(
SELECT
c2,…
FROM
(
…
)
WHERE
c2=v2,…
)
WHERE
c1=v1,…