Questions asked:- 1. What factors would you consider before doing a regression analysis? 2. What are some of the statistical methods you have used in the past? 3. What are some ways in which data visualizations can be used to mislead or misinform ?
Business Intelligence Engineer Interview Questions
1,082 business intelligence engineer interview questions shared by candidates
What factors need to be considered for setting up a new data centre in a new market.
Give an example of a time where you needed to ‘think outside the square’ to come up with a solution to a challenging problem?
Amazon’s 14 leadership principles were largely the focus of the questions asked.
Tell me why you wrote the query in this format for the project you worked on.
- leetcode medium level SQL questions - tablueu questions - questions on project - linkedlist question in Round 1
SQL coding and behavioral questions
Tell me about yourself? Why amazon? Time when you had a disagreement with somebody at work? What's your biggest accomplishment in your career? Tell me a situation where you had issues delivering a project? Tell me a time when you failed at work?
explain Primary key and sql join in layman terms. The interviewer asked to describe scenarios for 3 amazon leadership principles (do not remember which ones now)
Round1: partioning/indexing? adding column in a table without taking table offline? types of joins? cross join? write sql queries on rank over partition by, having count(*)>1, count(distinct ), SQL intersect star schema? what is upsert? delete/truncate difference? Round2: more and more details on partitioning? partition keys? partition pairing? partitioning with merge concept? diff btw primary keys and partition keys? upsert concept..whats required for upsert? how does it work? how to update primary key in a table with upsert? SQL Intersect concept whats cartesian product.. when are cross joins used? Table A has 2 rows; Table B has 3.. whats the cartesian result? Have you designed star schema?
Viewing 691 - 700 interview questions