I have a facebook onsite coming up in next 2 weeks. I'm concerned about the system design preparation. Does facebook ask to design the ER Diagram, DB Tables, SQL queries in the system design interview. I'm quite comfortable in building the large scale design but suck at designing API contracts and Low level design. It would be great if you guys can share your own experience of the design interview. If I'm supposed to know the low level design too then I'll probably push the interview by a week or so. YOE: 2.5 years Interview level: E4/E3 Org: Enterprise Engineer Thanks in advance!
In my experience they asked about data models, API contracts, distributed systems, caching, infrastructure, resiliency, fault tolerance, scalability, etc. I would advise to cover more breadth than depth for FB interviews.
Thanks. I'm planning to focus on grokking the system design now
I got a lot out of mock interviews once I got comfortable with Leetcode. Sites like Pramp.com and PracticeCodingInterview.com we’re super helpful. Yes, Facebook will ask low level system design questions. I found this useful http://www.practicecodinginterview.com/blog/2018/8/18/the-system-design-interview as well as https://www.educative.io/courses/grokking-the-system-design-interview
Thanks a ton. Do you think the data contract in grokking the system design will suffice or they can go in much more depth?
I assume you are SDE at Microsoft. Any reason for trying for Enterprise Engineer role?
I'm under the impression that Enterprise engineer are also SDEs. It's just that they work on the internal tools and infrastructure.
I would focus more on product design. Your recruiter should give you a prep guide. Since you are interviewing for an enterprise engineering role, don’t worry to much about inner in and out of database system, compute, etc. Know what to use, when and how efficiently is good enough. The point is to be able have a conversation with the interviewer where you can go to a solution, a reasonable one.
Thanks for the above pointer. Really appreciate