Hi there, I think I’ve read most of the recent posts on this, but nothing is super up to date. Are there any specifics to know about FB onsite for DE positions? I know there will be SQL/Python/modeling, but do they also follow a similar track of SWE with system design or product design? Thanks in advance! TC 165 (east coast)
No, FB De onsite is completely different. First round-> They will take one product and ask you if there is any way you can improve that product or if there is an issue in that product how can you fix it. Basically they are looking for KPI you will use to figure out the root cause of the problem and then they will ask you to write queries related to that problem. Second part is one programming problem LC medium should be more then enough. Second round -> Question on ETL process. You will be asked to write a sql query to do an ETL process, you might have to use some staging tables to complete the task. Second part, Python problem to do build a simple query from a json data or some simple transformation. Third round-> Will ask you a problem related to a product and then you need to design a data model to solve that problem and then they will ask you to write queries from that model if you are not able to write query from that model, fix the model and then write query this will go on untill you write all the queries. Fourth round—> behavior round which I think FB doesn’t have much importance.
Thank you so much.
How long is each round?
Is it the same for a DE manager role?
Don’t know
When they say design don’t take it as system design round.. For DE role it is data model design.
Can you please share your experience with the phone screening ?
🤔
?