they asked if I was ok with punishing hours.
Junior Intelligence Analyst Interview Questions
6,982 junior intelligence analyst interview questions shared by candidates
How much excel, SQL, and Python, do I know.
Given and orders table and a products table give me all products that had sales in 2016 and no sales in 2017
Given an orders table and a products table give me a list of all product categories, the number or orders they had and the total revenue.
HR decides if the candidates is able to move to the next round
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
4. What is ETL? what it is used for
SQL - Top 2 highest salaries by department.
Tell me about yourself. Why Amazon?
Define data warehouse? and how you used in your project
Viewing 741 - 750 interview questions