I applied online. The process took 2 months. I interviewed at Meta
Interview
The whole process took 2 months.
Sourcer is super nice, but the recruiter ghosts me after the onsite without giving a rejection.
The two interviewers in ETL rounds are weird and very impolite. They only need the best solution. When I said can I write a basic solution first and they said no.
I would say don't put 100% of your energy on the interview. Everything totally depends on the person who is interviewing you.
Interview questions [1]
Question 1
Don't focus only on Leetcode SQL questions. Their questions are more higher level. Prepare for advanced ETL questions. You should write the best solution immediately instead of just writing the solution down.
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.