I applied online. I interviewed at Meta (New York, NY) in Oct 2020
Interview
Through HR,
First-round is as usual, SQL and Coding(Python I chose)
The interviewer gave some tips to solve both SQL and coding parts.
I was a little nervous initially and came out of it as she was talking nicely
Interview questions [1]
Question 1
SQL ==> Sales, promotions, products DB I was able to complete only 3 questions.
Python ==> solved only 3 questions.
find giving letter in a string
Replace None with previous element from List, there was some challenges
[None]
[None,1,2] ==> [None,1,2]
[1,None,2] ==> [1,2,2]
[1,4,None,None,3]===> [1,4,4,4,3]
Forgot one question
In the SQL part, please make sure you learn how to calculate %
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.
