Status: MS CS Top 120 CS school
Position: BIE at Amazon
Location: Seattle, WA
Date: August 13, 2020
I) Phone screen : 1 Hour (3 LPs + SQL scripts)
1) Write an SQL script to find out the missing numbers - 2, 5, 8, 17, 20, 23, 29, 41
ans - 11, 14, 26, 32, 35, 38
2) Write an SQL script to find out the ranges of numbers that are monotonically increasing - 2, 3, 5, 1, 4, 2, 7, 8
ans - 2-5, 1-4, 2-8
3) Another question based on Employee-Manager table. Forgot the exact question.II) Phone screen : 1 Hour (3 LPs + Technical questions)
1) What is the difference between snowflake schema and star schema?
2) What is slowly changing dimension? what are it's types from 0 - 7?
3) How would you design a data warehouse for Uber eats?
4) For Uber eats, what metrics would you use to identify a city that is performing well?
5) Difference between delete and truncate?
6) Difference between rank() over() and dense_rank() over()?
III) Virtual Onsite :
1) Bar Raiser:
i) Tell me about a time you made a bad decision? What did you learn from it? What would you do differently?
ii) Tell me about a time you took an unpopular stance in a group meeting? What was their reaction? What would you do differently?
iii) Tell me about a time you received a critical feedback from your peers/manager? Did you take any action regarding their feedback? How did you react?
iv) Why Amazon? Why this BIE role?
2) Discussion with Hiring Manager
i) Tell me about a time you took risk when speed was critical. What decision did you make? What were the results?
ii) Tell me about a time you changed something that was fine according to the status quo. Were you successful?
iii) Tell me about a time you took an initiative. What was it's impact?
3) Another one:
i) 2 SQLs regarding the sale of products. One was to find the top 5 store_ids with maximum sale. Other was to find the top 5 products of the top 5 store_ids that have maximum sale.
ii) Tell me about a time where you had to dig several layers to solve a problem.
iii) Tell me about a time where you simplified something for a customer.
4) Another one:
i) How do you lead adoption of your views and ideas? Give me an example.
ii) Tell me about a time where you went above and beyond.
iii) WAP to find if a given string is palindrome in Python.
iv) WAP to find the words in a sentence that are repeated more than twice.
v) WAP to find all the direct/indirect reports of a given manager_id in an employee-manager table schema.
5) Last one: (phew)
i) Tell me about a time where you took responsibility of something outside your area of work? Why was it important?
ii) Tell me about a time where you worked with tight deadlines.
iii) Tell me about a time where you had a committment which you considered was risky to fulfill. What did you do?
iv) Tell me about a time where you had to figure out an obstacle.
v) One dashboarding/visualization question.