I applied through a recruiter. The process took 2 weeks. I interviewed at Meta
Interview
Recruiter Phone Screen, Online test in MySQL, and Coding in a language (Java, Scala, Python) of your choice, and 5 hr in-person interview (4 1 hr interviews and 1 hr lunch provided by company).
Interview questions [1]
Question 1
Phone: SQL qs are pretty basic on equi joins, outer joins, and self joins. Coding exercises are pretty basic like word search, etc. Time is a crunch (1hr). You have to keep explaining while coding so that the interviewer online understands your thought process. In Person: Some live coding exercise, tougher than phone qs, product sense, visualization.
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.