I applied online. The process took 2 weeks. I interviewed at Wayfair (Boston, MA) in Sep 2016
Interview
I got the invitation 2 months before, and the overall experience was not too bad. The first interview was by phone, and the others were at their office in Boston.
Interview questions [1]
Question 1
What's the difference between left join and right join in SQL
I applied online. The process took 3 weeks. I interviewed at Wayfair (Boston, MA) in Oct 2016
Interview
I had 2 phone interviews, one with the recruiter, and one with the hiring manager. I then had a Skype interview with the Sr. manager. From there i did not receive an offer.
Interview questions [1]
Question 1
How would you decide where to put a new warehouse?
I applied online. The process took 1 week. I interviewed at Wayfair
Interview
Contacted by a recruiter for an HR screening. The HR interview consisted of explaining my experience and two questions to gauge my Excel/SQL skills. A second phone interview was set up with two Operations managers. The interview consisted of a brief discussion about my interest in the position, the role, and my experience. They then jumped into a mini-case. The second interview was very abrupt and one of the managers seemed totally disinterested. Did not receive an invite to the third step in the interview process but the recruiter contacted me about a different position.
Interview questions [1]
Question 1
HR Interview:
1. What macros would you use to calculate revenue if given two sheets of data; Sheet 1=skus, price, sheet 2=skus, amount sold.
2. Same question as above, with SQL.
Case Interview:
1. What costs go into quoting a shipping price?
2. With excel, how would you go about verifying and identifying discrepancies in shipping data?