Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by PepsiCo Team. If you also belong to the team, you can get access from here

PepsiCo Verified Tick

Compare button icon Compare button icon Compare

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

Clear (1)

PepsiCo Reporting Analyst Interview Questions and Answers

Updated 4 Jul 2024

PepsiCo Reporting Analyst Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Approached by Company and was interviewed in Jan 2024. There were 2 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. About CPG Industry
  • Q2. About PowerBI technical
Round 2 - Technical 

(2 Questions)

  • Q1. Report was shared and asked to analyze
  • Q2. Situation based question

Interview Preparation Tips

Interview preparation tips for other job seekers - Get knowledge about the industry.

Reporting Analyst Jobs at PepsiCo

View all

Interview questions from similar companies

Interview Questionnaire 

1 Question

  • Q1. Asked on past job experience. Asked on key achievements. Asked on technical skills. Asked on market analysis and competitive benchmark study.

Analyst Interview Questions & Answers

Dabur user image Anonymous

posted on 11 Feb 2022

I applied via Naukri.com and was interviewed before Feb 2021. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - HR 

(1 Question)

  • Q1. Tell me about yourself.
Round 3 - HR 

(1 Question)

  • Q1. Why should we hire you?

Interview Preparation Tips

Interview preparation tips for other job seekers - Very nice company to work from today
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Sep 2023. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - HR 

(2 Questions)

  • Q1. Give an example of leadership you experienced in a previous job
  • Q2. Explain your previous work

Interview Preparation Tips

Interview preparation tips for other job seekers - Great interview
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Sep 2024. There were 2 interview rounds.

Round 1 - Assignment 

Excel,sql,advance excel

Round 2 - Coding Test 

Sql,excel,advanced excel

Interview Preparation Tips

Interview preparation tips for other job seekers - stay current with industry trends and enhence your skills throught online courses ,job searching can be challenging,so practice self-care and stay motived throughout the process
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. Tell me about your experience
Round 2 - HR 

(1 Question)

  • Q1. Expected salary, what is ur previous salary

Interview Preparation Tips

Interview preparation tips for other job seekers - Be humble
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed in Feb 2024. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. Tell me about your strengths & weakness.
Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in May 2023. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Technical 

(1 Question)

  • Q1. SQL medium difficulty level questions.
Round 3 - Behavioral 

(1 Question)

  • Q1. She asked me about the projects.
Round 4 - Client Interview 

(1 Question)

  • Q1. Still waiting for their response.

I applied via Naukri.com and was interviewed in Nov 2021. There were 4 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Previous experience, tools on which I worked/ used.
  • Q2. Are you open to learn technology?
  • Ans. 

    Yes, I am always open to learning new technologies.

    • I actively seek out opportunities to learn new technologies.

    • I have taken online courses to learn new programming languages.

    • I am comfortable with using online resources to learn new technologies.

    • I am excited to learn about any new technologies that may be relevant to my work.

  • Answered by AI
  • Q3. Understanding on Financial statements?
  • Ans. 

    Financial statements are reports that show the financial performance of a company.

    • Financial statements include the balance sheet, income statement, and cash flow statement.

    • The balance sheet shows the company's assets, liabilities, and equity.

    • The income statement shows the company's revenue, expenses, and net income.

    • The cash flow statement shows the company's cash inflows and outflows.

    • Financial statements are important ...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - There were 2 technical rounds on Advanced Excel. There was a data set asked to answer by formulaes. For example: Sequence, Transpose, Sumproduct, Sumifs 3ic., For each question interviewer expected an alternative method to achieve the same.

I applied via LinkedIn and was interviewed in Feb 2022. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Tell us data science project where you developed a script for forecastings, KNN, Data science models with practical examples.
  • Ans. 

    Developed a script for forecasting using KNN and data science models.

    • Developed a script using Python to forecast sales for a retail company using KNN algorithm.

    • Built a data science model to predict customer churn for a telecom company using logistic regression.

    • Used time series analysis to forecast stock prices for a financial services company.

    • Developed a script to predict the likelihood of a customer defaulting on a lo...

  • Answered by AI
  • Q2. 1. Why you are asking this role is for Data analyst or data scientist? 2. Don't go for the provided JD and do you think you are well aware of Data science concepts and models, algorithms etc.

Interview Preparation Tips

Topics to prepare for Hindustan Unilever Data Analyst interview:
  • Data Science
  • Algorithms
Interview preparation tips for other job seekers - Please don't waste your time here coze thet need Data scientist for data analyst profile irrespective of JD which is of no use.
Very arrogant interviers sorry to say this but true!

Skills evaluated in this interview

Contribute & help others!
anonymous
You can choose to be anonymous

PepsiCo Interview FAQs

How many rounds are there in PepsiCo Reporting Analyst interview?
PepsiCo interview process usually has 2 rounds. The most common rounds in the PepsiCo interview process are One-on-one Round and Technical.
How to prepare for PepsiCo Reporting Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at PepsiCo. The most common topics and skills that interviewers at PepsiCo expect are Power Bi, Analytics, Data Analytics, Excel and Project Planning.
What are the top questions asked in PepsiCo Reporting Analyst interview?

Some of the top questions asked at the PepsiCo Reporting Analyst interview -

  1. Report was shared and asked to anal...read more
  2. About PowerBI techni...read more
  3. Situation based quest...read more

Recently Viewed

JOBS

Gushwork

14 jobs

JOBS

Browse jobs

Discover jobs you love

JOBS

GroundTruth

33 jobs

PHOTOS

Growisto

7 office photos

SALARIES

PepsiCo

SALARIES

Nestle

DESIGNATION

SALARIES

Oberoi Group of Hotels

No Salaries

JOBS

Aavas Financiers

No Jobs

JOBS

Crescent Foundry

No Jobs

Tell us how to improve this page.

PepsiCo Reporting Analyst Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

ITC Interview Questions
3.9
 • 547 Interviews
Dabur Interview Questions
4.0
 • 272 Interviews
Nestle Interview Questions
3.9
 • 233 Interviews
Britannia Interview Questions
4.0
 • 164 Interviews
Parle Agro Interview Questions
4.1
 • 104 Interviews
Cargill Interview Questions
4.0
 • 94 Interviews
Marico Interview Questions
4.0
 • 87 Interviews
Suguna Foods Interview Questions
4.0
 • 71 Interviews
View all

PepsiCo Reporting Analyst Reviews and Ratings

based on 1 review

1.0/5

Rating in categories

1.0

Skill development

1.0

Work-life balance

3.0

Salary

3.0

Job security

1.0

Company culture

1.0

Promotions

1.0

Work satisfaction

Explore 1 Review and Rating
Control & Reporting Analyst

Hyderabad / Secunderabad

4-7 Yrs

Not Disclosed

Explore more jobs
Associate Manager
629 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Deputy Manager
523 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Manager
449 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Customer Executive
360 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Manager
301 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare PepsiCo with

Nestle

3.9
Compare

Coca-Cola Company

4.1
Compare

Hindustan Unilever

4.2
Compare

Britannia

4.0
Compare
Did you find this page helpful?
Yes No
write
Share an Interview