I applied in-person. The process took 4 weeks. I interviewed at Wayfair (Boston, MA) in Apr 2020
Interview
The whole process was really slow. But the interviewers are really nice. The SQL question is about window function. And the case is used to test your logic, business acumen.
I applied online. The process took 3 weeks. I interviewed at Wayfair in Mar 2019
Interview
They started with an online test followed by a video interview. Then moved on to the final onsite. This is by far the worst company I have ever seen. They conduct interviews because the employees get paid for it. They choose candidates internally and the results do not depend on how well you perform.
Please do not waste your time interviewing for Wayfair.
I applied through university. I interviewed at Wayfair (Pittsburgh, PA) in Feb 2019
Interview
Round 1: Resume was shortlisted after applying via Job fair in University
Round 2: Tech round - Codility: Two advanced SQL questions. It involved using window functions to solve
Round 3: Video Interview: Business Case + Quant Questions
Interview questions [1]
Question 1
Q1: Tell me about yourself
Q2: Talk about one of the projects you have worked on
Q3: Quant question on Discount rate and profit