i
Amazon
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
I applied via campus placement at Vellore Institute of Technology (VIT) and was interviewed in Sep 2024. There were 3 interview rounds.
SQL Joins, Python functions
I applied via LinkedIn and was interviewed in Jul 2024. There were 3 interview rounds.
I applied via Company Website and was interviewed in Mar 2024. There were 2 interview rounds.
What people are saying about Amazon
I applied via campus placement at Vellore Institute of Technology (VIT) and was interviewed before Aug 2022. There were 4 interview rounds.
It consisted of logical reasoning, SQL snippet questions Excel data modelling quant questions ,data warehouse and cloud computing questions
Amazon interview questions for designations
I applied via Approached by Company and was interviewed before May 2023. There was 1 interview round.
I applied via Recruitment Consulltant and was interviewed in Nov 2024. There was 1 interview round.
Rank assigns unique ranks to each distinct value, while Dense Rank assigns consecutive ranks to each distinct value.
Rank does not skip ranks when there are ties, while Dense Rank does
Rank will have gaps in ranks if there are ties, while Dense Rank will not
Rank function is used to assign a unique rank to each distinct row, while Dense Rank function is used to assign consecutive ranks to each distinct row
posted on 9 Jul 2024
I applied via Company Website and was interviewed in Jun 2024. There was 1 interview round.
I have implemented various technical improvements in codes to enhance performance and functionality.
Implemented caching mechanisms to reduce load times
Optimized database queries for faster retrieval of data
Introduced error handling techniques to improve code reliability
Utilized design patterns to make the codebase more maintainable
Refactored legacy code to adhere to best practices
I was interviewed in Oct 2023.
Python, SQL, Quant, Statistics, Numpy
I applied via Recruitment Consulltant and was interviewed before Feb 2023. There were 3 interview rounds.
The Windows function in SQL is used to perform calculations on a specific subset of rows in a result set.
The Windows function is used with the OVER clause to define the subset of rows to perform calculations on.
Common Windows functions include ROW_NUMBER, RANK, DENSE_RANK, and NTILE.
Example: SELECT ROW_NUMBER() OVER (PARTITION BY department ORDER BY salary DESC) AS row_num FROM employees;
I applied via Approached by Company and was interviewed before Apr 2022. There were 8 interview rounds.
This is literally a live coding test. For analytics expect SQL, python, R.
Some of the top questions asked at the Amazon Business Analyst Intern interview -
based on 6 interviews
Interview experience
based on 2 reviews
Rating in categories
Customer Service Associate
4.2k
salaries
| ₹0.6 L/yr - ₹6.8 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.9 L/yr |
Senior Associate
2.5k
salaries
| ₹2 L/yr - ₹10.1 L/yr |
Program Manager
2.3k
salaries
| ₹9 L/yr - ₹36 L/yr |
Flipkart
TCS
Netflix