Position: Senior Software Engineer
Location: Boston, MA
Date: April 2019

Phone Screen

Given 2 tables Employees(id, dept_id, salary, name) and department (id, name).
a. find the dept id with the max salary and number of employees
b. find the dept name with max salary and number of employees
c. find the dept name with no employees

Given a phone pad as below. List out all the phone numbers that can be made with 7 digits. The method of generating the numbers would be the movement of a rook. It can move vertically and horizontally by any number of steps.
1 2 3
4 5 6
7 8 9

Onsite

Round 1

design four square or check-in based system.

Round 2

Design Roulette(Object Oriented Desgin) and implement how much a user could win based on previous results. For eg if after 4 reds there will always be a black. How to use this information to determine how much will a user win.

Round 3

Sports league database design. players are employees, belong to multiple teams, team belongs to league, games are played between teams.
Query for all teams and leagues that a player given first and last name belongs to.
Query all players on al teams that play at a particular position
query all players that are not on a team.

Round 4

describe your past projects etc.
describe a time when you had an underperforming colleague.
describe a time when you had to disagree with a colleague.
describe a time when you had to convince a client that your approach is correct.
why wayfair

Result

Rejected offer. The company has an old tech stack and I did not get a good vibe from the people I interviewed with.