I applied through university. I interviewed at Wayfair in Feb 2017
Interview
Focus on tech questions and case study questions, won't thoroughly go through your resume. They will let you introduce your past experience and ask a lot about the projects you've done before and then go directly into tech questions.
Interview questions [1]
Question 1
What is the difference between union and union all
what is the difference between left outer join and inner join
If we used to promote our products by small catalogs and we want to change to larger ones, how can we decide our target consumers
Given the former transaction rate, profit and cost, what will be the number of large catalogs if we want to create the same profit
I applied online. The process took 3 weeks. I interviewed at Wayfair (Berlin) in July 2023
Interview
I could not complete all the steps due to unprofessional interview process management. Two different HRs contacted me. After I shared my availability for the next interview, they sent me 2 different emails which were not related to my interview process. I asked for clarification about the process and send me the correct slot, but I did not get an answer for 4 days. In the end, HR call me and said all of a sudden they decided to hold the hiring process for this position. I spent 2 days on the case study and this is really unprofessional. I had concerns about the company because of having a low rating on Glassdoor but now understood why people are complaining that much. 1- Codility Challenged -- passed 2- HR screening call -- passed 3- Hiring Manager -- passed 4- Case Study -- delivered but the position on hold
Interview questions [1]
Question 1
How did you manage a difficult customer? Some typical HR questions Nothing special
I applied online. The process took 2 weeks. I interviewed at Wayfair (Boston, MA) in Oct 2019
Interview
Codility first use either python or sql to solve the problem
one round for phone interview, a business case question with several questions, with simple calculation
three rounds of onsite including behavior, free presentation and an inventory case
I applied online and received a request to complete an analytics challenge containing SQL, open ended question containing business acumen and an analytics exercise which required manipulation of a dataset.
Interview questions [1]
Question 1
The question contained simple question involving SQL queries, analyzing a business situation and providing recommendation and a simple data analysis set.