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,…
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.
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.