1st round - online assessment
2nd round - SQL & case study
3rd round - hr, T-sql , Homework asssessment
1st round - online assessment
2nd round - SQL & case study
3rd round - hr, T-sql , Homework asssessment
Interview questions [1]
Question 1
Write an SQL query to find the person_name of the last person who will fit in the elevator without exceeding the weight limit. It is guaranteed that the person who is first in the queue can fit in the elevator.
case study - sudden decrease in gross profit by 50%(GP=revenue - cost ) for only 1 day - normal GP before & after that day .why? GP is shipping, damages & defects
Received coding quiz invite and attempted immediately. Finished SQL Codility quiz, which they gave 2 hours but can be done within 1. Then I received an email just 2 business days after, said my profile seems fit but they have finished hiring for the season, which is unreasonable and a waste of my time. My experience is inconsistent with the others Glassdoor intern review.
I applied through college or university. I interviewed at Wayfair (Boston, MA) in Mar 2020
Interview
Received 3 SQL questions as the initial screening process and moved to first round of 1 hour with live coding challenge and the critical thinking scenarios. I did not receive offer after this round.
Data Solutions Engineer applicants have rated the interview process at Wayfair with 2.7 out of 5 (where 5 is the highest level of difficulty) and assessed their interview experience as 33% positive. To compare, the company-average is 51.5% positive. This is according to Glassdoor user ratings.
Candidates applying for Data Solutions Engineer roles take an average of 60 days to get hired, when considering 3 user submitted interviews for this role. To compare, the hiring process at Wayfair overall takes an average of 22 days.
Common stages of the interview process at Wayfair as a Data Solutions Engineer according to 3 Glassdoor interviews include:
Presentation: 67%
Phone interview: 33%
Here are the most commonly searched roles for interview reports -