I applied online. The process took 2 weeks. I interviewed at Meta (Menlo Park, CA) in Apr 2020
Interview
It was a great process. Applied through a recruiter who contacted me on Linkedin then we set up a call to chat about my experience and the interview process. We scheduled a technical round and I was able to answer 3 SQL and 2.5 python . Looks like need at least 4 and 4 to get to next round so my journey ended here.
Question 2:
What are the top five (ranked in decreasing order)
single-channel media types that correspond to the most money
the grocery chain had spent on its promotional campaigns?
# Question 3:
# -- % Of sales that had a valid promotion, the VP of marketing
# -- wants to know what % of transactions occur on either
# -- the very first day or the very last day of a promotion campaign.
Question 1:
# Complete a function that returns the number of times a given character occurs in the given string
# For example:
# - input string = "mississippi"
# - char = "s"
#
# - output : 4
"""
"""
# Question 2:
# Fill in the blanks
#
# Given an array containing None values fill in the None values
# with most recent non None value in the array
#
# For example:
# - input array: [1,None,2,3,None,None,5,None]
#
# - output array: [1,1,2,3,3,3,5,5]
#
# Question 3:
# Complete a function that returns a list containing all the mismatched words (case sensitive) between two given input strings
# For example:
# - string 1 : "Firstly this is the first string"
# - string 2 : "Next is the second string"
#
# - output : ['Firstly', 'this', 'first', 'Next', 'second']
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.