Intelligence Analyst Manager Interview Questions

6,928 intelligence analyst manager interview questions shared by candidates

1. Tell me about yourself 2. difference between transactional databased and OLAP 3. pick a field you are strong in and then follow up questions were asked SQL: given a table consisting of routes including source and destination find the sources which are never a destination. (something like that, don't remember exactly)
avatar

Business Intelligence Engineer

Interviewed at Amazon

3.5
Apr 21, 2022

1. Tell me about yourself 2. difference between transactional databased and OLAP 3. pick a field you are strong in and then follow up questions were asked SQL: given a table consisting of routes including source and destination find the sources which are never a destination. (something like that, don't remember exactly)

Order Table OrderID|Merch ID|MerchantID|Category|date|price|quantity|…… MerchantID|ID|Name|Status 1. To find out all merchants with ‘Amazon’ in name and return a column ‘internal customer’ if Upper(Amazon) in name or else ‘3P Seller’. Return Null if the merchant name is null
avatar

Business Intelligence Engineer II

Interviewed at Amazon

3.5
Dec 31, 2020

Order Table OrderID|Merch ID|MerchantID|Category|date|price|quantity|…… MerchantID|ID|Name|Status 1. To find out all merchants with ‘Amazon’ in name and return a column ‘internal customer’ if Upper(Amazon) in name or else ‘3P Seller’. Return Null if the merchant name is null

Viewing 751 - 760 interview questions

Glassdoor has 6,928 interview questions and reports from Intelligence analyst manager interviews. Prepare for your interview. Get hired. Love your job.