I applied through a recruiter. The process took 2 weeks. I interviewed at Meta (San Francisco, CA) in May 2016
Interview
A recruiter reached on linkedin and set up an initial call to discuss about background.
Next was two phone screens - 1) SQL 2) Any preferred language (I picked Python)
Each phone screen is 45 minutes and you are asked about 6-7 questions. The questions are relatively straightforward if you are comfortable with basics.
In coding interview, they are trying to see if you can approach the same program in two different ways - one using inbuilt methods and one without using in built methods
Interview questions [2]
Question 1
SQL questions -
A table schema with tables like employee, department, employee_to_projects, projects
1) Select employee from departments where max salary of the department is 40k
2) Select employee assigned to projects
3) Select employee which have the max salary in a given department
4) Select employee with second highest salary
5) Table has two data entries every day for # of apples and oranges sold. write a query to get the difference between the apples and oranges sold on a given day
Python Questions -
1) Print Max element of a given list
2) Print median of a given list
3) Print the first nonrecurring element in a list
4) Print the most recurring element in a list
5) Greatest common Factor
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.
I had Python and SQL round for 30 minutes each. The interview was for 1 hour 30 minutes for SQL and 30 mins for python coding.
Completed 5 questions each but still got rejection email the next day.
