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.
I applied through an employee referral. The process took 3 weeks. I interviewed at Meta in Oct 2021
Interview
I got the call from recruiter soon after I got referred by FB Employee. The recruiter asked basic questions about my self and later told me the interview process at FB. The recruiter didn’t ask me any technical questions, as said by others in other reviews. Soon after my initial discussion with recruiter they gave me a Phone Screening date which was 2 weeks later. The recruiters provided all the preparation material in order to get success in the screening.
The Phone Screening interview was on Python (45mins) and SQL (45 mins) on same day. The questions were easy though a word of advice to all, Don’t rely only on LeetCode/Hacker Rank previously asked questions. No questions were repeated in my case. Understand the Data Structures concept throughly and their application.
2 Python - 50% success rate.
4 SQL - 100% success rate, All answered within 10 mins, excluding timings for questions asked Such as This V/S That.
Awaiting results, though I don’t expect I would make it to next round due to my Python Success Rate.
Try to be cool during coding round.
Balance the string., i.e., How many additional literals needed to evenly balance the string.
String is made of a-j and 0-9 where alphabets marks the opening and numbers as closing.
For e.g., ab00a. This is unbalanced since it requires pair of b with 1, and additional 0 occurs before “a” ie., missing opening pair and later “a” without its closing number pair.. Result : 3
E.g., bj19 is balanced so result 0.
I applied online. The process took 4 weeks. I interviewed at Meta (New York, NY) in Oct 2021
Interview
I did python 4+sql 3.5. pass phone interview;
hr reply in 5 days.
interviewer don't want more explain, only want to see result;
make sure the question is most important.
make sure you can work with codepad successfully
Interview questions [1]
Question 1
question same as others. none; %
, is_low_fat_flg ENUM('1', '0'), is_recyclable_flg ENUM('1','0'));