Any tips on preparing for the design interviews at Airbnb? Do they focus on overall system design or dive deep into a smaller component? From what I've read so far, the focus is more on scaling the DB layer and getting the data model right. Running low on prep time, highly appreciate some tips on this :)
Both. I got asked to define the schema (tables and fields), write queries and also the high level stuff.
Did you interview for swe or data analyst type position?
swe
There're no tricks to it. They want you to come up with a sensible approach that would work, no BS.
Would you recommend brushing up on SQL queries, primary key, foreign key design etc.? How about schema definitions for NoSQL DBs of different kinds?
I didn't get NoSQL questions but I wonder if that's because I didn't suggest NoSQL for the solution. But I do recommend brushing up on sql stuff
Tech Industry
Yesterday
610
The new Tesla Model 3 P goes from 0-60 in 2.9 seconds
India
Yesterday
515
How to save India from destruction?
India
Yesterday
300
Indian PM 2024: who gets your vote?
Tech Industry
Yesterday
1845
TESLA UP 14% AFTER HOURS ππππ
Tech Industry
Yesterday
4386
11 offers to laid off[UPDATE]: 5 offers
Yeah I got the same. Given a simple app, design it's data structure. Then they keep adding feature requests and you modify it. Then they increase the scale and ask you to improve it. It was all about the DB.
Thanks for your response. By DB, is it the regular SQL/NoSQL, sharding etc. Or are you required to come up with actual schemas in the chosen DB? What kind of questions were you grilled on? @hustla