I applied through a recruiter. I interviewed at Meta in Mar 2021
Interview
1. I got a call from FB Recruiter who found me through linkedin, and had first discussion of general experience and also asked 5 basic SQL and python questions.
2. Next round is 1hr technical interview, where code will be written in coderpad. Interviewer is very helpful and it is more like a conversation, rather than interview. Some basic hints for python coding is also there which you can refer in case you stuck somewhere. The questions are all available in Glassdoor here. Please refer them and practice well.
Interview questions [1]
Question 1
Python questions:
1. Replace None value with previous value present in a list.
2. Given a ´dictionary, print the key for nth highest value present in the dict. If there are more than 1 record present for nth highest value then sort the key and print the first one.
3. Given two sentences, you have to print the words those are not present in either of the sentences.(If one word is present twice in 1st sentence but not present in 2nd sentence then you have to print that word too)
4. Forgot another question
you have to pass all the cases, specially on edge cases.
SQL questions:
1. Mostly % calculation, also refer the questions available here in Glassdoor.
Next will be my Onsite Interview of 3.30hr. If anyone can help me on that or else I will update later on that interview as well.
Starts with a screen, followed by leetcode style SQL+Python questions, Full loop of SQL, Python, SQL plus Python and lastly behavioural round. Every round is also an architecture round in some sense.
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.