Wayfair Interview Questions, Process, and Tips

Q1. SQL question ( window functions) dense_rank
Add your answer
Q2. SQL question(window function) aggregation, there were 5 tables and you had to do some joins
Add your answer
Q3. Some question on spark optimisations
Add your answer

There were there question total one on dp one on string and the last one was simple on arrays.

Q1. Data base desgin of car rental system
Add your answer
Q2. Sql qustions mainly on goupby , having and natural joins
Add your answer

Q1. Why do you want to join waifair and what do you konw about it.
Add your answer
Q2. Given a situation of confilct and how will you handle it.
Add your answer

Develop iOS app based on given use case

Q1. IOS and assignment related questions
Add your answer

Q1. LLD round - design book library
Add your answer

Q1. Questions based on prev projects, work experience and scenario based behavioural questions
Add your answer

Q1. Tell me about yourself
Ans. 
Experienced engineering manager with a background in software development and team leadership.
• Over 10 years of experience in software engineering

• Managed cross-functional teams to deliver projects on time and within budget

• Strong communication and problem-solving skills

• Led the development of a new product that increased revenue by 20%
Answered by AI
Add your answer
Q2. Discribe your roles and responsibility
Ans. 
As an Engineering Manager, I oversee team projects, mentor engineers, set goals, and ensure project deadlines are met.
• Oversee team projects and ensure they are completed on time and within budget

• Mentor and coach engineers to help them grow and develop their skills

• Set goals and objectives for the team to achieve

• Collaborate with other departments to ensure project success

• Handle any conflicts or issues within the team

• Stay
Answered by AI
Add your answer