Amazon Transportation Services Catalogue Specialist Interview Questions and Answers

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. Asked to create a power bi dashboard
Add your answer

Q1. Had coding test on SQL and Python
Add your answer

Three sections are there 1) Aptitude Test 2) SQL 3) DSA

Q1. What is DSA , sorting , difference between array and linked list
Ans. 
DSA stands for Data Structures and Algorithms. Sorting is the process of arranging data in a particular order. Array is a data structure that stores elements of the same data type in contiguous memory locations, while linked list is a data structure that stores elements in nodes with pointers to the next node.
• DSA stands for Data Structures and Algorithms

• Sorting is the process of arranging data in a particular order

• Arra...read more
Answered by AI
Add your answer
Q2. Written a SQL query
Add your answer

Q1. Coding question like add numbers
Add your answer
Q2. Experience on your project
Ans. 
I have experience working on various data analysis projects, including market research, customer segmentation, and predictive modeling.
• Developed predictive models to forecast customer behavior and optimize marketing strategies

• Conducted market research to identify trends and opportunities for growth

• Performed customer segmentation analysis to target specific demographics with personalized marketing campaigns
Answered by AI
Add your answer

SQL, Python Coding & MCQ test

Behavioural questions mostly, they tey ro find approach.

Q1. Salary negotiations
Add your answer
Q2. Location preference
Add your answer

Q1. SQL Joins and remove duplicates
Add your answer
Q2. Function to create a transaction bin column
Ans. 
Create a function to generate a transaction bin column based on transaction amounts.
• Create bins based on transaction amounts (e.g. $0-$100, $101-$200, etc.)

• Use pandas cut() function in Python to create bins

• Assign bin labels to the transactions based on the bin ranges
Answered by AI
Add your answer