I applied through a recruiter. The process took 6 weeks. I interviewed at Meta in Sep 2021
Interview
Was reached out by a recruiter, after that had an initial phone conversation with them.
1st Technical Interview, was able to answer 4 SQL and 5 Python in the allotted time. For SQL, focus on percent calculations (everything else is everyday SQL), and Python practice easy Leetcode/what you see here on Glassdoor. Also, awesome turnaround time here, found out I passed within an hour of interviewing.
Virtual-Onsite was more difficult, and asked you questions related to Data Engineering. My advice is to know how to work as a Data Engineer, prepping with Leetcode and refreshing SQL will only get you so far. Also, you don't have to be perfect with your answers, just explain your thought process and work with the interviewers, they're there to help. Even if you get something wrong explain your logic, and then confirm why there might be a better solution when you aren't 100% confident yours is the optimal one.
Interview questions [1]
Question 1
Can't remember most or had to sign an NDA for On-Site Questions. Expect some behavioral and product sense questions.
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.