Amazon Interview Question for Software Development Managers

Country: United States
Interview Type: In-Person

Comment hidden because of low score. Click to expand.
of 2 vote

I was asked this question while getting interviewed for product manager position at google.

think about database design, what all information you would store in addition to news message
- news text
- data & time
- location
- reporter
- likes
- views ..etc

how would you store them in database efficiently for fast retrieval. how would you order/index them so that user sees the most relevant ones at the top.

These days almost real time updates would be required hence an effective caching strategy would also be required.

- compskiguy October 01, 2016 | Flag Reply
Comment hidden because of low score. Click to expand.
of 1 vote

Use the observer pattern here.

Have a list of pages (friends, trending etc) that a user follows
In order of priority list the most recent posts according to time stamps
Refresh the feed every 2 mins or so

- confused_coder August 21, 2016 | Flag Reply
Comment hidden because of low score. Click to expand.
of 0 vote

A relational database and real time updates with -
- news content (text, date, location, related entities, type of news)
- Location (regional personalization)
- Areas of news (sports, national, economic, political)
- User profile connectivity and area of interest

- Mystery_coder November 26, 2016 | Flag Reply

Add a Comment

Writing Code? Surround your code with {{{ and }}} to preserve whitespace.


is a comprehensive book on getting a job at a top tech company, while focuses on dev interviews and does this for PMs.

Learn More


CareerCup's interview videos give you a real-life look at technical interviews. In these unscripted videos, watch how other candidates handle tough questions and how the interviewer thinks about their performance.

Learn More

Resume Review

Most engineers make critical mistakes on their resumes -- we can fix your resume with our custom resume review service. And, we use fellow engineers as our resume reviewers, so you can be sure that we "get" what you're saying.

Learn More

Mock Interviews

Our Mock Interviews will be conducted "in character" just like a real interview, and can focus on whatever topics you want. All our interviewers have worked for Microsoft, Google or Amazon, you know you'll get a true-to-life experience.

Learn More