Amazon Development Centre India Data Analyst Interview Questions and Answers

Q1. Projects Worked
Ans. 
I have worked on various projects involving data analysis, visualization, and interpretation.
• Developed predictive models using machine learning algorithms

• Performed data cleaning and preprocessing to ensure accuracy

• Created interactive dashboards for stakeholders to easily understand insights
Answered by AI
Add your answer
Q2. SQL functions used in the projects
Ans. 
Common SQL functions used in projects include COUNT, SUM, AVG, MAX, MIN, and GROUP BY.
• COUNT: Used to count the number of rows in a table.

• SUM: Used to calculate the sum of a column.

• AVG: Used to calculate the average value of a column.

• MAX: Used to find the maximum value in a column.

• MIN: Used to find the minimum value in a column.

• GROUP BY: Used to group rows that have the same values into summary rows.
Answered by AI
Add your answer
Q3. Machine learning alogriths
Add your answer

Q1. Tell me about yourself
Add your answer

Q1. Basic to Advanced level of SQL
Add your answer
Q2. Discussed 1 -2 Business Cases studies
Add your answer

Basic questions based on Sql

Group discussion is when a group of people comes together to discuss a certain topic. Many Recruiters use group discussion (GD) to test a candidate's communication skills, leadership skills, test topic knowledge, etc. There are also two other types of GD that test the lateral thinking of a candidate.

Aptitude tests are a great way for a hiring manager to gauge a candidate’s suitability to a role. They are a tool used to see how candidates might deal with the challenges of the role they are interviewing for.

Aptitude tests are usually done via an online platform, however, businesses may invite you into the office to take these tests too. This depends on their recruitment processes.

HR ask some questions for code language in candidates like example c, c++ and java they work solve and get the output in shortway

Q1. Questions are fully based on sql, excel, Python. Questions asked given by a case study.
Add your answer

Q1. Statistics, few asked related to regression, hypothesis, ttest, and also questions on sql, python
Add your answer

Technica questions related to sql

Q1. Some technical questions related to sql and advance excel .
Add your answer

Q1. Some questions related to cars insurance and second cars
Add your answer

Q1. Salary discussion and some hr questions
Add your answer