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 through a recruiter. I interviewed at Meta in Dec 2017
Interview
The Hr reached me out through the email. I first thought that it was some spam email so I double checked the Hr's details and then contacted her back. Soon enough there was a small 15-20 min call with her and we got to know each other during the call. She was very interested in knowing if I use SQL on a daily basis. Since i didnt use it daily i told her and she asked me to prepare for it for the interview. Next she emailed me a bunch of study material for both sql and python. I didnt make it to an onsite interview since I was slow. There were 30-30 minute sessions for python/sql and the interviewer was quite particular with the time.
I could solve 2 python and 2 sql questions in the given time. Though I struggled in the second sql question a little bit.
The overall experience was good as the interviewer helped me with my thought process throughout.
tips:
1.Please communicate your thoughts to the interviewer
2. once you build a rough algorithm , just start executing it without too much thought. you will get to know the errors in the compiler and u can change the syntax, or logic accordingly. This will save you a lot of time.
3.Try to complete more questions in less time (ofcourse they should show the correct output)
4. be confident in whatever you are doing. If you cant figure out a way to write a logic by yourself, just ask the interviewer quickly. They will definitely help
Interview questions [1]
Question 1
Python
1.given an ip address as an input string, validate it and return True/False
2.count the neighbors of each node in a graph. input graph is a multi dimensional list
SQL
1. Display the most common name in the table
2. a case statement related question. pretty straightforward
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.
