I applied through a recruiter. The process took 3 weeks. I interviewed at Meta (Menlo Park, CA) in May 2015
Interview
There were 2 Telephonic round(1 coding+1 sql)(45 mins each with a break of 15 mins in between)
You will be asked to code. Interviews would start with basic introduction and they would ask you to code in your preferred language(but Python is preferred). sql questions are My sql based. Regular questions but answers expected are the most optimized way. They would expect simple questions to be answered in a particular way.
Interview questions [1]
Question 1
1) Given a number and a array.
Python code to find sum of any 2 numbers in a list is equal to a given number.
2) sql question mostly on case when, joins
ex: Q3: delete all dupliactes from a table in one query
3) Mostly the interviewer was cornering me by asking not to use regular ways, so he was expecting the answers in a particular way, ex: can't use joins, sub query etc which made very simple questions tough
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.
