Wayfair Interview Questions and Answers

Q1. SQL question ( window functions) dense_rank
Add your answer
Q2. SQL question(window function) aggregation, there were 5 tables and you had to do some joins
Add your answer
Q3. Some question on spark optimisations
Add your answer

There were there question total one on dp one on string and the last one was simple on arrays.

Q1. Data base desgin of car rental system
Add your answer
Q2. Sql qustions mainly on goupby , having and natural joins
Add your answer

Q1. Why do you want to join waifair and what do you konw about it.
Add your answer
Q2. Given a situation of confilct and how will you handle it.
Add your answer

This was a Take Home test. I got a coding assignment where in I had to make a simple iOS app which can fetch data from an API and display it as a list on the screen. I used SwiftUI as its faster to code there. It was not complicated at all if you know youur stuff and they asked me to include tests (both Unit and UI). I already had my code snippets ready (for example for a Network class) so I could write a lot more code quite easily. It was taken on Hackerrank and I had 120mins to complete it. I read the instructions carefully and did as asked. I added comments to everything and made it extremely neat and structured using all the best coding practices of a large scale iOS project. Submitted it and that was it.

This was a discussion of my assignment. Take Home Follow Up. It was taken by an SDE 3 from US and he asked all sorts of questions about my code. I explained everything in great detail and told him what all things I would do better if i had more time. Simple round. Be ready to explain everything, every word and line.

Q1. Design a Order and Cart Page in iOS. The user should be able to order an item, see it in cart, the limit of each item is set to 1. Show the various classes, network requests, APIs, information flow, etc. N...read more
Ans. 
Design an Order and Cart Page in iOS with limit of 1 item per order.
• Create classes for Order, Cart, Item

• Implement network requests to fetch item details

• Use APIs to add item to cart and place order

• Design information flow from selecting item to placing order
Answered by AI
Add your answer

Q1. Mention a time where your had to deal with a challenging or difficult colleague and how did you deal with it?
Ans. 
I had to deal with a challenging colleague by addressing the issue directly and finding common ground.
• Communicated openly and honestly with the colleague about the issue

• Listened to their perspective and tried to understand their point of view

• Found common ground and worked towards a solution together
Answered by AI
Add your answer
Q2. Mention a time where you had a conflict with your manager regarding a technical matter in your project? Where you had a different approach to a problem and had to come to a conclusion?
Add your answer

Q1. A general discussion about the project and my interests. Discussing my roles and responsibilities and whether I'm comfortable with the location, commute and tech stack.
Add your answer

Develop iOS app based on given use case

Q1. IOS and assignment related questions
Add your answer

Q1. LLD round - design book library
Add your answer

Q1. Questions based on prev projects, work experience and scenario based behavioural questions
Add your answer