Hi, I have a technical phone interview for Data Engineer position at Fb, Menlo Park. Can anyone please guide/help me in preparing for it? Will leetcode be fine? How tough are the questions for SQL and Python? Thanks. PS: Posting for the first time. Not aware of the rules so please let me know nicely if I have not followed any. Thanks. #facebook #dataengineer #dataengineerinterview
I was told by the recruiter that I have to code in Postgresql and I dont have much experience on that.. any tips to prepare for the interview in terms of learning postgres? Thanks.
Learn how data type conversions work in Postgres - int to float, etc. Apart from that, there is probably nothing else that you can not solve with ANSI SQL.
Pgexercises.com and windowfunctions.com or download postgres docker container and pgadmin and load practice data
Usually 3 sql and 3 programming questions. Sql should be easy one, programming would be in low medium
Are you expected to solve all 6 correctly? Just working solution is fine or should it be optimized?
I think working solution should be fine. I solved 6 and last one programming question, interviewer guided little bit to solve. I had to produce correct output for each question before moving on to next question