Alibaba Interview Questions

Alibaba Interview Guides

Click or hover over a slice to explore questions for that topic.
SQL
(53)
Data Structures & Algorithms
(50)
Machine Learning
(44)
Probability
(26)
A/B Testing
(22)

Alibaba Interview Questions

Practice for the Alibaba interview with these recently asked interview questions.

QuestionTopicDifficulty
SQL
Medium

An electronics retail company tracks its sales and wants to run a performance analysis. They’re hoping to categorize sales into different groups, based on the amount of sales and the region where the sale occurred. The conditions for categorization are:

  • Standard Sales: Any sales below 2000 are considered standard, except if they occur in the East region, or in the month of July.
  • Premium Sales: Any sales that are over or equal to 2000, or any sales in the East region (regardless of the amount), are considered premium, except again during the month of July.
  • Promotional Sales: All sales made in the promotional period of July, regardless of the amount or region, are considered promotional.

The company wants a report that sums these amounts by region to help with financial planning and bonus allocations.

Note: You may assume that table contains data only for 2023

Example:

Input:

sales table

Column Type
sale_id INTEGER
employee_id INTEGER
product_id INTEGER
sale_amount FLOAT
sale_date DATE
region TEXT

Output:

Column Type
region TEXT
total_sales FLOAT
premium_sales FLOAT
standard_sales FLOAT
promotional_sales FLOAT
Behavioral
Medium
SQL
Easy
Loading pricing options

View all Alibaba Group questions

Challenge

Check your skills...
How prepared are you for working at Alibaba Group?

Alibaba Salaries by Position

$106K
$183K
AI Research Scientist
Median: $156K
Mean (Average): $155K
Data points: 12
$86K
$176K
ML Engineer
Median: $121K
Mean (Average): $127K
Data points: 4
$85K
$132K
Data Analyst
Median: $105K
Mean (Average): $107K
Data points: 4
$47K
$223K
Software Engineer
Median: $70K
Mean (Average): $101K
Data points: 18
$48K
$146K
Data Scientist
Median: $80K
Mean (Average): $92K
Data points: 3
$80K
$99K
Product Manager
Median: $85K
Mean (Average): $88K
Data points: 3
Business Analyst*
$53K
$105K
Business Analyst
Median: $79K
Mean (Average): $79K
Data points: 2

Most data science positions fall under different position titles depending on the actual role.

From the graph we can see that on average the AI Research Scientist role pays the most with a $154,733 base salary while the Business Analyst role on average pays the least with a $79,000 base salary.

Discussion & Interview Experiences

?
There are no comments yet. Start the conversation by leaving a comment.

Discussion & Interview Experiences

There are no comments yet. Start the conversation by leaving a comment.

Jump to Discussion