Tell me about a time that you have conflicts with others? How did you deal with that
Business Intelligence Engineer Interview Questions
1,083 business intelligence engineer interview questions shared by candidates
Customer obsession, ownership, have backbone
Tell me about a time you had to teach yourself something new
3 sql quiz and 1 python quiz
Tell me a time where you deep dive into a problem
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?
Screening - 2-3 behavioral questions. 2-3 SQL questions. Loop interview - 3 were pure behavioral and 2 were behavioral + technical
What experience you have in statistical analysis.
What factors need to be considered for setting up a new data centre in a new market.
Amazon’s 14 leadership principles were largely the focus of the questions asked.
Viewing 741 - 750 interview questions