I applied through a recruiter. I interviewed at Meta in May 2017
Interview
Recruiter reached out to me for initial phone screen. Then set up a 1 hr phone screen with Data Engineer that covered SQL and Python. Got all of the questions correct, but needed help on the final Pythin question. Recruiter reached out to me again, and I had to do a second coding screen, similar to the first. This time it was strictly on Python. I got all correct, but I stumbled on the final python problem. Recruiter reached back out to me a couple days later with feedback, some positve and some mediocre. I needed more experience and a better though process basically. So I did not move to the onsite interview. I enjoyed interviewing though, the interviewers were nice.
Interview questions [1]
Question 1
Python
-Count distinct words in a sentence
-Count the number of times a word appear in a sentence using a Hash Map
-Return tuples of a list, matching each item to another item
-Count the number of times a substring appear in a string
SQL
-Return min and max age of male/female who bought a product
-Count the number of stores in a state with grand total ? 25000 sq feet
I had a Technical Screening where I was asked to code some SQL and Python questions. They are of medium difficulty. I thought I did decent, but still didn't get through .. :P
Interview questions [1]
Question 1
Python Coding involving data structures
SQL coding
I applied online. The process took 4 weeks. I interviewed at Meta in Feb 2022
Interview
They had a website that does a good job at showing you every step of the process and tells you what prep your required. I would higly reccomend being very comfortable with solving alot algorithim based interviews and being fast.
Interview questions [1]
Question 1
Write a function that returns the elements on odd positions (0 based) in a list
There is a phone screen followed by two interviews. Phone consists of basic DSA and database questions with a behavioral question or two. After the phone screen there will be a coding focused round, and a database focused round separately.
Interview questions [1]
Question 1
Study Python Data Structures( Lists, Dictionaries, Sets, Tuples etc.), and SQL.
