Recruiter reached out. Setup a 1 hr screening interview.
This was my 2nd attempt at this position. Although, I could solve all the 4 SQL and 4 Python questions (passed all the test cases) with little help from the interviewer except the last one where the interviewer had to give me the idea to solve it, got an email the next day saying I didn't make it to the next round.
As they don't give feedback after the interview, it is very difficult to judge what went wrong. My understanding is, even though you have the option to run the code and see the output, don't do it until you are 100% sure that your code will pass all the test cases. Although the interviewer said that you can run queries and see data, every run you make is counted against you.
I would suggest don't put your heart and soul into preparing for the interview. It's ultimately a human interacting with another human. Even if you perform well in the interview, a lot of other factors can affect your candidacy.
Interview questions [1]
Question 1
SQL Data schema was provided. SQL to be written that used left joins, nulls in filter, count func., case stmt.
Python
create a histogram from a given list
flatten a list: [1,2,[3,4. [5],[6,7,[8,[9]]]]]
remove duplicates from a list
count words in a sentence
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.
