YOE:13+
Current: Technical Architect/Senior DE
Referred by Friend.
Had an initial call with recruiter where very basic questions were asked:
select 1+null, where vs having, union vs union all, left join what happens
python: list vs dict, counter , etc etc
Got my phone screen scheduled:
Facebook phone screen is one of the easiest to crack.
25 mins SQL, 25 mins Python.
Sql Qstns: Same schema of sales,transactions,products and promotions see glassdoor.
Very very easy and basic questions, top 5 sales, percent product with low fat and recyclable, percent of products sold at promotion start and end date.
The first two qstns I completed in 4mins. The 3rd qstn killed me. It was an easy one, however I assumed that all sales didn't have promotions for which I used a left join and messed up. Then postgres doesn't allow the syntax
select (select * from table A/select * from table B), the / is not supported. This led to debugging time and finally with interviewer hint I queried sales and noticed al sales have transactions so an inner join was fine and could do in one case statement. So only 3 qstns. I could have easily done 5 in 25 mins at the rate I was going, but luck /coder pad/overthinking ..what more can I say.
Python: Find specific char in string(Use Counter), Find uncommon words in two strings, [None, 1,2,None,None]-->[None,1,2,2,2] fill all nuls with prev. This I did in place and interviewer was happy, sort dict based on value. Each qstn had 4-5 test cases which sometimes took time to run and pass. I tried to cover all edge cases. 4 qstns out of 5 is max I can do in 25 mins.
Got a call for onsite. Recruiter have shared ton of materials so will take a month for it.
To all people out there preparing, facebook phone interview is really easy(phone screen) only thing is you can't fumble then ur gone, the time factor is pretty much it. All the best to you!!