Reached out by a facebook recruiter in linkedin and did the phone screen - basic questions on SQL and python. The phone screen went fine and got scheduled for a coding interview with a data engineer. Pattern is 5 mins intro, 25 mins for SQL (Postgres) and 25 mins for programming (python/Java) of your choice and closing discussion is for 5 mins.

Recruiter sent lot of materials for interview prep and was very helpful. I think the first question that i got in SQL is to find percentage of products of some categories out of total products, very simple and i was practicing these type of questions using mysql platform. Interestingly in mysql the typecast is taken care automatically whereas in postgres we need to explicitly cast the output both in denominator and numerator in order to get the output. Things went wrong after this and simply 25 mins flew very fast. My advice is to practice as much as possible in postgres for the interview and dont use other SQL platforms.

Python programming is very simple, count the number of times a character appears in a string, fill None with last encountered not None value and reverse each word in an array etc., Again 25 mins flies so fast and time management is the key here. My advice is to practice with arrays and strings type of questions in leetcode.

All the best for those going to take the interview.