FB De phone interview
Had my FB DE phone interview today and was able to get thru 2 SQL and 2 python questions and provided algorithm for 1 SQL and 1 Python question as we were running out of time. How many questions should be answered successfuly to get called for onsite?
@dowjones it's 1h normally for 10 questions. Difficulty is easy/medium in SQL (join/aggr/case when) and Python (string/list/dict).
Thank you. Would FB tagged LC questions for string and array type questions suffice?
I would say yes, list/str/dict, but practice at least 100 LC/HR questions. 200 is better to know the answers patterns. So make sure to do (to understand) 2 questions per day and you should be good in few weeks
4 each: python n SQL. Or atleast 3 with acceptable verbal solution for the 4th.
I guess I am screwed. Curious, do you know this because you are an interviewer at Facebook or just from experience?
Minimum 3 as per the recruiter. some of my friends did not make it after solving 4 in both python and sql. depends on the interviewer as well.
Did you hear back from fb? I just had my phone interview. I could solve 3 SQL an 2 python in 1 hour. 3rd python I started, but couldn't finish.
Did they have you type and run all the code? Also, did they provide you sample data for SQL or just the data model?
Yes, interviewer was very helpful and guiding me throughout. Given hints many times if I was going in wrong direction. I could immediately catch his hints and fix the issues. I typed & ran all the code.SQL questions matched with their results, all test cases passed for python as well. Sample data is not given. It's just the schema.
I got a reject. Feedback was that interviewer would like to see more SQL question and python questions answered.
What were the questions in SQL and in Python ?
What is the wait time after phone screen to know the result?
Is Python mandatory? Any other programming language accepted?
Python, Java and some other languages. I just need to choose one.
Thanks
I had phone interview 3 days back. I have answered 4 SQL and 4 python questions. What are my chances moving to VO? The recruiter is delaying the feedback.
Should be good ! What types of Python questions did you have ? Same we can see on Glassdoor ?
How were the Python questions? Leetcode easy?
Hi guys, were the questions similar to the ones posted in glassdoor? or is it any different? any inputs will be really helpful in my preparation for my interview in couple of weeks. Thanks.
Following. People said that you needed at least 5 SQL and 5 Python questions answered. True? How easy could the question be?
How difficult were SQL and Python questions? Also, what was the time allotted to solve 6 questions?
The SQL questions were not difficult. However, all that was provided was the data model so i had to query the tables to understand what each field contains and then write the queries accordingly. That along with postgres giving me some syntax errors which required more debugging took away most of the 30 mins allocated for SQL. Python questions were a little difficult and the interviewer required that all test cases must pass so handling edge cases was a bit time consuming.
How did you know you passed edge cases? From what I know, they allow running the codes. Were the python questions leetcode based or data manipulation based (pandas)?