Amazon Saving Analyst Interview Questions and Answers

Basic Apititude Questions

Q1. Difference between WHERE and HAVING??
Ans. 
WHERE is used to filter rows before grouping, HAVING is used to filter groups after grouping.
• WHERE is used with SELECT statement to filter rows based on a condition

• HAVING is used with GROUP BY statement to filter groups based on a condition

• WHERE is applied before data is grouped, HAVING is applied after data is grouped

• Example: SELECT * FROM table WHERE column = 'value'

• Example: SELECT column, COUNT(*) FROM table GROUP B
Answered by AI
Add your answer
Q2. Where- Row Level Filters Having-Aggregate Filters
Ans. 
Row level filters are applied before aggregations, while aggregate filters are applied after aggregations.
• Row level filters are used to filter individual rows of data before any aggregations are performed.

• Aggregate filters are used to filter the aggregated results after the data has been grouped and summarized.

• Row level filters are typically applied using WHERE clause in SQL, while aggregate filters are applied using H...read more
Answered by AI
Add your answer

Q1. Why do you wanna join Uber?
Add your answer
Q2. Best Company Ever
Add your answer

Q1. Explain your current role
Add your answer
Q2. How do you analyse the credit metrics of a firm
Ans. 
I analyse credit metrics of a firm by evaluating financial statements, debt levels, profitability, liquidity, and industry trends.
• Reviewing financial statements to assess revenue, expenses, and profitability

• Analyzing debt levels and debt-to-equity ratios to evaluate financial leverage

• Assessing liquidity ratios such as current ratio and quick ratio to determine short-term solvency

• Examining industry trends and economic f...read more
Answered by AI
Add your answer
Q3. Differentiate between contractual and structural obligation
Ans. 
Contractual obligations are legally binding agreements between parties, while structural obligations are inherent responsibilities within a system or organization.
• Contractual obligations are based on agreements between parties, often outlined in contracts or agreements.

• Structural obligations are inherent responsibilities within a system or organization, such as following policies and procedures.

• Contractual obligations ...read more
Answered by AI
Add your answer

Q1. All related to manual testing
Add your answer

Q1. 1. Related to Manual Testing
Add your answer

Q1. Manual testing, java
Add your answer

Q1. All fake build ups
Ans. 
Fake build ups refer to false claims or exaggerations made about a product or service.
• Fake build ups can mislead customers and damage the reputation of a company.

• Examples include exaggerated claims about the effectiveness of a product or false testimonials from supposed satisfied customers.

• Quality analysts play a crucial role in identifying and rectifying fake build ups to ensure transparency and trustworthiness.
Answered by AI
Add your answer

SQL questions were asked

Q1. Chart read, SQL questions on self join, window
Add your answer

The assignment was a data dump and I was asked to find some insights to reduce cost

Q1. Interview with VP Marketing about my previous experience
Add your answer

Q1. Interview with reporting manager about my experience and skills to do that job
Add your answer

Q1. This round was to assess my culture fit
Add your answer

Q1. How to sort ararat
Ans. 
Ararat can be sorted alphabetically or numerically.
• Sort alphabetically: Arrange in ascending order based on the letters in the word.

• Sort numerically: Arrange in ascending order based on the numerical value of each character.
Answered by AI
Add your answer

Q1. Normal verification
Add your answer

Q1. Questions related to sql
Add your answer
Q2. Windows function in sql
Ans. 
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;
Answered by AI
Add your answer

Q1. Interview with stakeholders
Add your answer

Q1. Strenghts/weaknesses
Add your answer