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.
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
I applied through 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.