Amazon-related R questions
Business Intelligence Engineer Interview Questions
1,082 business intelligence engineer interview questions shared by candidates
Tell me about a time you failed
Being primarily a behavioral interview the questions were primarily focused on questions where I needed to relay situations I had worked through that demonstrate my abilities and knowledge of the leadership principles. The technical questions were relatively simple regarding setting up SQL statements, creating joins, thinking critically/technically about challenges in extracting data, etc. Probably the most difficult technical question was during the phone interview when I had to, off the top of my head, tell the interviewer how to write a SQL statement without being able to type or write it out myself. This was only difficult in that all of it had to happen in my head and it included multiple tables, a sub-query, and a union.
a lot of case questions, theory questions and SQL questions. SQL self join, three table join etc.
how would you scale up a product
Tell me about a time where you had to choose between multiple solutions to a problem. Tell me about a time where you went above and beyond for a customer Have you ever had an experience where you proposed a solution that you faced resistance in implementing? Have you ever had an experience where you didn't know how to solve a problem? Say your are ingesting near real-time data from JSON outputs, how would you set up the process to optimize both read and write from your destination table? Write a SQL query to return the top 2 customers with highest sales volume for each product from a sample dataset/tables Write a SQL query to return only customers who ordered both Product A and B but not Product C from a sample dataset/tables
Given some data, what are the potential analysis?
What is the difference between Union and Union All
A large number of behavioral questions centered around AMZN LPs. In terms of technical questions, there are simple SQL questions and one case study question about whether to have a data center in a new location. There are also questions about data visualization (asking you what are good data via practices, what mistakes people make when they are making data visualization etc).
Tell me about a time when you faced a technical challenge.
Viewing 541 - 550 interview questions