Test Q2: return first name, last name, if first name is john return 10% of salary, roy 20% of salary and everyone 15% of the salary as prorated_salary_column from table 1
Intelligence Analyst Interview Questions
6,935 intelligence analyst interview questions shared by candidates
Test Q1: write a select statement returing emp id, first name, last name and first 3 characters of first name concatenate with a period and first 5 characters of the last name with alias column name modified_name from first table
What are your career aspirations
Amazon Value Question 1. Tell me a time when you had to understand a complex problem
What do you know about the role
Few SQL and python related questions. Other questions were behavioral.
Leadership Principles using the STAR methodology
2. Totals sales by category and having totals greater than $200, sales made in 2018 with status = active merchants only
Define FizzBuzz function in Python
a brief phone call (15-20 min, in English) to learn some basic info like current responsibilities, career plan, salary expectation, etc.
Viewing 2021 - 2030 interview questions