Add office photos
i
Amazon
CompareProud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Amazon Analyst Interview Questions, Process, and Tips
Top Amazon Analyst Interview Questions and Answers
- Q1. tell me the difference between having and group by sql
- Q2. Why python language is so popular?
- Q3. sql problems regarding joins and window function
Amazon Analyst Interview Experiences
11 interviews found
Devesh Tiwari
I applied via Naukri.com and was interviewed in Apr 2024. There were 3 interview rounds.
General assesment, grammar, vocabulary
(2 Questions)
- Q1. SQL and Python basic level
- Q2. Sql problems regarding joins and window function
- Ans.
Understanding SQL problems related to joins and window functions
Ensure you understand the different types of joins (inner, outer, left, right)
Know how to use window functions like ROW_NUMBER(), RANK(), and PARTITION BY
Practice writing queries that involve multiple tables and window functions
(1 Question)
- Q1. Normal questions
Interview Preparation Tips
Skills evaluated in this interview
Anonymous
Hacker rank test having sql questions
(1 Question)
- Q1. Do not remember the question
Selected
I applied via Walk-in and was interviewed before Jul 2023. There were 3 interview rounds.
Ok .first time asked me to write a code
(2 Questions)
- Q1. Name of you hdu
- Q2. Okay. It's all right
(2 Questions)
- Q1. Asked some questions
- Q2. Okay.its all right
Interview Preparation Tips
Questions about python, r language, sql, c language, c++ are asked..
(2 Questions)
- Q1. What is hight level programming language
- Ans.
High level programming languages are designed to be easily understood by humans and are closer to natural language.
High level languages are more abstract and do not require knowledge of the computer's hardware.
They are easier to read, write, and maintain compared to low level languages.
Examples include Python, Java, C++, and Ruby.
- Q2. Why python language is so popular?
- Ans.
Python is popular due to its simplicity, readability, versatility, and strong community support.
Easy to learn and use, with simple syntax and readability.
Versatile language used in web development, data analysis, artificial intelligence, etc.
Strong community support with a large number of libraries and frameworks available.
Cross-platform compatibility allows code to run on different operating systems.
Dynamic typing and...
Skills evaluated in this interview
Amazon interview questions for designations
(1 Question)
- Q1. What are shortterm liabilities.
- Ans.
Short-term liabilities are debts or obligations that are due within one year.
Short-term loans
Accounts payable
Accrued expenses
Short-term portion of long-term debt
Interview Preparation Tips
Get interview-ready with Top Amazon Interview Questions
Selected
I applied via Company Website and was interviewed before Sep 2023. There were 3 interview rounds.
Assessment was difficult
(2 Questions)
- Q1. Tell me the difference between having and group by sql
- Ans.
GROUP BY is used to group rows that have the same values into summary rows, while HAVING is used to filter groups based on a specified condition.
GROUP BY is used with aggregate functions to group the result-set by one or more columns.
HAVING is used to filter groups based on a specified condition after the GROUP BY clause.
HAVING is used with aggregate functions to filter the result-set based on a condition.
Example: SELE...
- Q2. What are the variables?
- Ans.
Variables are factors that can change or be manipulated in a scientific experiment or study.
Variables can be independent (manipulated by the researcher) or dependent (affected by the independent variable).
Control variables are kept constant to ensure they do not affect the outcome of the study.
Examples of variables include age, gender, temperature, time, and dosage.
(2 Questions)
- Q1. Behavioral round
- Q2. Same again questions
Skills evaluated in this interview
Analyst Jobs at Amazon
Selected
I applied via Walk-in and was interviewed before Jun 2023. There was 1 interview round.
(2 Questions)
- Q1. Introduction to myself
- Q2. Softskill and communication
Interview Preparation Tips
I applied via Company Website and was interviewed in Feb 2022. There were 2 interview rounds.
(3 Questions)
- Q1. Why Amazon ? What makes you motivated to join it?
- Q2. What is your biggest mistake and what did you learn from it?
- Q3. Which Leadership principle do you follow in your life?
Interview Preparation Tips
I applied via NA and was interviewed before Apr 2023. There were 2 interview rounds.
Coding round for testing the critical Coding skills in SQL and othe programming language.
(1 Question)
- Q1. More of database, SQL and analytical questions
I was interviewed before Apr 2023.
Coding round for analysing programming capabilities and skills.
(1 Question)
- Q1. Technical round comprise of SQL, Database and Analytics related scenario based questions.
Top trending discussions
Amazon Interview FAQs
Tell us how to improve this page.
Amazon Interviews By Designations
- Amazon Software Developer Interview Questions
- Amazon Customer Service Associate Interview Questions
- Amazon Transaction Risk Investigator Interview Questions
- Amazon Customer Service Executive Interview Questions
- Amazon Software Developer Intern Interview Questions
- Amazon Associate Interview Questions
- Amazon Seller Support Associate Interview Questions
- Amazon Software Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
Amazon Analyst Interview Process
based on 7 interviews in last 1 year
2 Interview rounds
- Coding Test Round
- Technical Round
People are getting interviews through
Analyst Interview Questions from Similar Companies
Fast track your campus placements
Amazon Analyst Reviews and Ratings
based on 41 reviews
Rating in categories
|
Customer Service Associate
4.1k
salaries
|  ₹0.6 L/yr - ₹6 L/yr |
|
Transaction Risk Investigator
3.1k
salaries
| ₹2.3 L/yr - ₹6.5 L/yr |
|
Associate
2.8k
salaries
| ₹0.8 L/yr - ₹6.8 L/yr |
|
Senior Associate
2.4k
salaries
| ₹2 L/yr - ₹10.1 L/yr |
|
Software Development Engineer
2k
salaries
| ₹16.1 L/yr - ₹33.2 L/yr |
Flipkart
TCS
Netflix
Calculate your in-hand salary
- Home >
- Interviews >
- Amazon Interview Questions >
- Amazon Analyst Interview Questions
