I applied online. I interviewed at Meta in May 2018
Interview
I applied for a contractor position through a recruiter. Had the phone interview with hiring manager after a week. Didn't hear from them after that.
the interviewer was friendly and it was a good discussion.
Interview questions [2]
Question 1
SQL:
1.Name few analytical functions 2. how to display id, next_id from <table>
General:
1. Tell me about yourself 2. challenges faced and how to overcome.
Data Modelling:
how do you calculate unique logins by a user in facebook.com
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.