Role: Software Engineer
College: Not Specified
Interview Date: May 13, 2024
Interview Type: Full-Time
Result: Not Specified
Difficulty: Medium
Rounds: 5 rounds (Technical Phone Interview + 4 On-site rounds)
Topics Asked: Data Structures, Algorithms, SQL, Cultural Fit, Object-Oriented Design, System Design, Database Design
Experience:
This candidate interviewed for the Supply Chain and Engineering Team (Transportation team). The process included a Technical Phone Interview followed by four on-site rounds in Boston, MA.
Technical Phone Interview:
- Coding Question: Given an array of weights and a target weight, find if the array contains two values that are equal to the target weight (e.g., `[1 2 5 6 9]`, Target `10`: true).
- Follow-up Questions: What are some other ways to solve this problem? Could you write some test cases for your logic? How can you get the input if it is too large?
- SQL Questions: 5-7 SQL questions on topics like JOINS (different types), GROUP BY & HAVING CLAUSE on sample data provided by the interviewer.
On-site Interview (Boston, MA):
- First Round: Cultural Fit. Questions included: "Tell me a situation where you have developed a scrappy solution." "Why Wayfair and what do you know about Wayfair?" "Tell me a difficult technical problem that you have faced in your career and how did you solve it."
- Second Round: Object-Oriented Design. Not explicitly detailed in the snippet, but focused on OOD.
- Third Round: System Design. Asked to design a check-in application similar to Instagram, where users could tag places. This tested the ability to design scalable and efficient systems.
- Fourth Round: Database Design. Not explicitly detailed in the snippet, but focused on database design.