PepsiCo Interview Questions

PepsiCo Interview Guides

Click or hover over a slice to explore questions for that topic.
Machine Learning
(3)
SQL
(3)
Behavioral
(2)
Product Sense & Metrics
(1)
Forecasting & Time Series
(1)

PepsiCo Interview Questions

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

QuestionTopicDifficulty
SQL
Medium

Given a employees and departments table, select the top 3 departments with at least ten employees and rank them according to the percentage of their employees making over 100K in salary.

Example:

Input:

employees table

Columns Type
id INTEGER
first_name VARCHAR
last_name VARCHAR
salary INTEGER
department_id INTEGER

departments table

Columns Type
id INTEGER
name VARCHAR

Output:

Column Type
percentage_over_100k FLOAT
department_name VARCHAR
number_of_employees INTEGER
SQL
Hard
SQL
Hard
Loading pricing options

View all Pepsico questions

Challenge

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

PepsiCo Salaries by Position

$172K
$220K
Data Engineer
Median: $220K
Mean (Average): $202K
Data points: 5
$122K
$183K
Software Engineer
Median: $135K
Mean (Average): $145K
Data points: 4
Data Scientist*
$92K
$128K
Data Scientist
Median: $110K
Mean (Average): $110K
Data points: 2
Business Analyst*
$87K
$96K
Business Analyst
Median: $91K
Mean (Average): $91K
Data points: 2
ML Engineer*
$85K
ML Engineer
Median: $85K
Mean (Average): $85K
Data points: 1
Data Analyst*
$81K
$90K
Data Analyst
Median: $85K
Mean (Average): $85K
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 Data Engineer role pays the most with a $202,000 base salary while the Data Analyst role on average pays the least with a $85,000 base salary.

Discussion & Interview Experiences

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