Amazon Transportation Services Data Entry Operator and Cashier Interview Questions and Answers

Talk to the head hunter. General phone screening

Q1. Talk to the hiring manager and another manager from BI. Asked about work experience and gave me a SQL test
Add your answer

Shared a dataset and wanted me to provide some insights and also build some slides to present

Q1. Difference between mutual and hedge funds
Ans. 
Mutual funds pool money from multiple investors to invest in a diversified portfolio, while hedge funds are more exclusive and use more aggressive strategies.
• Mutual funds are open to all investors, while hedge funds are typically only available to accredited investors.

• Mutual funds are regulated by the SEC, while hedge funds have more flexibility in their investment strategies.

• Mutual funds are more diversified and have ...read more
Answered by AI
Add your answer

Python, SQL, Aptitude

Q1. SQL - A table EmployeeSkills was given having two columns EmpID & Skills. There can be multiple for an employee id with skills he possess. You need to find the EmpID having skills in Python and SQL
Add your answer
Q2. PowerBI - Create Bookmarks in Power BI
Ans. 
Bookmarks in Power BI allow users to save the state of a report, including filters, slicers, and visuals.
• Bookmarks can be created by selecting 'View' and then 'Bookmarks' in the Power BI toolbar.

• Users can add bookmarks by selecting 'Add' and then naming the bookmark.

• Bookmarks can be applied by selecting the desired bookmark from the 'Bookmarks' pane.

• Bookmarks can be used to save different views of a report for easy acc
Answered by AI
Add your answer
Q3. SQL - Find cumulative Profit sum in a given table.
Ans. 
Use SQL query with window function to find cumulative profit sum in a given table.
• Use window function like SUM() with ORDER BY clause to calculate cumulative profit sum.

• Example: SELECT date, profit, SUM(profit) OVER (ORDER BY date) AS cumulative_profit FROM table_name;

• Ensure the table has a column for date and profit to order and calculate cumulative sum.
Answered by AI
Add your answer

SQL, Python and Power BI

First round was aptitude test,duration is of 25 minutes involves SQL,PowerBI,Python, Qunatitative Aptitude,SAS skillset

Q1. About process and self introduction
Add your answer
Q2. All process KPI'S
Ans. 
Process KPIs are key performance indicators that measure the effectiveness and efficiency of a process.
• Process KPIs help identify areas for improvement and monitor progress towards goals.

• Examples of process KPIs include cycle time, error rate, customer satisfaction, and productivity.

• Process KPIs should be specific, measurable, achievable, relevant, and time-bound (SMART).

• Regularly tracking and analyzing process KPIs ca...read more
Answered by AI
Add your answer

Q1. Discussed on salary
Add your answer
Q2. About expectation
Add your answer