I applied through an employee referral. The process took 4 weeks. I interviewed at Meta in Jan 2017
Interview
I got the call via employee referral. HR contacted me through phone for initial screening. General interview like my background and interest. Then a few weeks later, SQL Coding and Python Coding rounds was conducted. Each coding round were of 45 minutes each back to back with 15 minutes break. The coding was conducted on coder pad. I was able complete the 5 SQL coding questions but could only complete 1 Python coding question. I found the python questions difficult.
Interview questions [1]
Question 1
SQL Coding:
5 questions
4 tables were given and questions were mostly on joins, aggregate functions, sub queries.
Python Coding: I guess there were total 5 questions but could reach only till second question.
Count the number of words in a sentence.
Count the frequency of words from the list and store the results in a hash map.
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.
