Tell me a time where you deep dive into a problem
Intelligence Interview Questions
6,938 intelligence interview questions shared by candidates
They asked a lot of behavioral questions.
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?
Test Q3; return first name, last name, salary from table 1 and full incentive amount from table 2 for all employees
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.
Straight - experience based questions. No technical or "ISTQB"-BS questions, which is a good thing.
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.
Tell me about a time when...
Viewing 4491 - 4500 interview questions