Wayfair Senior | May 2021
Location: Berlin, MD
Role: Data Analyst
When did you have this interview?: Last Month
I applied through their website with my CV. After 2 days, I received an email to a coding challenge and they asked me to complete the coding challenge in 1 week. You will have to finish the coding challenge in 2 hours and 25 minutes. I completed the coding challenge. It consists of 4 tasks. 1. Python task Simple python coding test, need to use self-defined functions and for loops 2. Machine learning multiple choice questions 3. Data cleaning & Manipulation task. somehow this task is only allowed to do it in R, but they didn’t specify that prior to the challenge 4. SQL task - complex SQL query questions that requires cte and window functions.
What kind of technical questions did you get asked?
Create a function that with an input S as a date, and input K as number of says, return the day of week of the desired date (example: s =20210604 is today (Friday), k = 2, then the function should return Sunday