Skip to contentSkip to footer

Intelligence Research Specialist Interview Questions

Salaries
Interviews

1,455 intelligence research specialist interview questions shared by candidates

Round 1: Telephonic (Datawarehousing and SQL) (Questions on indexing, star schema vs snowflake schema , sql code to run a cumulative sum using window function , etc . (Level- Moderate to tough) Round 2: Onsite round with Senior Analyst, SQL codes after understanding through an ER diagram for the test . (Level- Moderate) Round 3: Hiring Manager round (Onsite round), questions on CRM software tool and its benefits , questions were focused on increasing sales . Round 4: Cross check round with another manager (Video chat), guesstimate, data interpretation from a chart , metrics required to understand the health of business and how to generate derived metrics as per business requirements . Round 5: (with Business Head) questions on past projects, majorly focused on the insights layer (data,information,insights,decisions being the 4 layers).
avatar

Business Intelligence Analyst II

Interviewed at Zeta

3.3★
Sep 16, 2019

Round 1: Telephonic (Datawarehousing and SQL) (Questions on indexing, star schema vs snowflake schema , sql code to run a cumulative sum using window function , etc . (Level- Moderate to tough) Round 2: Onsite round with Senior Analyst, SQL codes after understanding through an ER diagram for the test . (Level- Moderate) Round 3: Hiring Manager round (Onsite round), questions on CRM software tool and its benefits , questions were focused on increasing sales . Round 4: Cross check round with another manager (Video chat), guesstimate, data interpretation from a chart , metrics required to understand the health of business and how to generate derived metrics as per business requirements . Round 5: (with Business Head) questions on past projects, majorly focused on the insights layer (data,information,insights,decisions being the 4 layers).

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
avatar

Business Intelligence Engineer

Interviewed at Amazon

3.5★
Oct 1, 2022

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

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).
avatar

Business Intelligence Engineer Intern

Interviewed at Amazon

3.5★
Apr 18, 2023

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).

Viewing 1201 - 1210 interview questions

Glassdoor has 1,455 interview questions and reports from Intelligence research specialist interviews. Prepare for your interview. Get hired. Love your job.