I applied through a recruiter. I interviewed at Meta (San Francisco, CA) in Sept 2020
Interview
Initially contacted by a DS recruiter, but asked to be referred to a DE recruiter instead.
Did call with DE recruiter who gave me a briefing for the phone screen, then did the phone screen a couple of weeks later. Pretty easy interview - as other posts say, it's 10 questions - 5 in SQL and 5 in Python/Java (and all were the same/similar to those listed in other reviews).
Got news I'd be moving to the next round a couple of days later, then was referred to another recruiter who would be leading me through the virtual onsite process. Did an initial hour long call to talk through the next round of interviews, then scheduled it for a few weeks later. Interview was not too difficult - 4 rounds: 3 technical with some product sense/SQL/Python questions and 1 behavioral.
A week later, was contacted by my recruiter who asked me to do a follow up behavioral interview because there were doubts about whether I was more interested in DE than DS. Scheduled that interview for a couple of days later. Got the final decision about 10 days after the follow up interview.
Overall, very good experience! Everyone was super helpful and friendly and the interviews were as expected after the calls with the recruiters.
Interview questions [1]
Question 1
See other posts - mine were similar/the same for the phone screen.
Had to sign an NDA for the virtual onsite, so can't give details.
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.