Company: Wayfair

Location: Berlin, MD

Role: Data Analyst

Level: Senior

Outcome: Rejected

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