Search

Interview Questions

  • Reviews
  • Salaries
  • Interview Questions
  • About Company
  • Benefits
  • Jobs
  • Office Photos
  • Community
+ Contribute
notification
notification
Login
Premium Employer

i

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

BigBasket Verified Tick

Compare button icon Compare button icon Compare
3.9

based on 4.5k Reviews

Filter interviews by

BigBasket Data Analyst 2 Interview Questions and Answers

Updated 26 Feb 2022

BigBasket Data Analyst 2 Interview Experiences

1 interview found

Data Analyst 2 Interview Questions & Answers

user image

posted on 26 Feb 2022

I applied via Naukri.com and was interviewed in Aug 2021. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Sql based queries like rank dense rank replacing bill values and some basic queries
    • Add your answer
  • Q2. CTE function, aggregate functions
    • Add your answer
Round 2 - Technical 

(2 Questions)

  • Q1. Running values third highest
  • Ans. 

    To find the third highest value in a dataset

    • Sort the dataset in descending order

    • Select the third value from the sorted dataset

    • If there are ties, consider the next highest value as the third highest

    • Answered by AI
    Add your answer
  • Q2. And some manager level questions
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Bigbasket was hiring for a report developer position so they mostly required a person who had intermediate knowledge on sql so be prepared make strong foundation in sql all the best

Top trending discussions

View All
Interview Tips & Stories
1w (edited)
timepasstiwari
·
A Digital Markter
Got Rejected In an Interview, Just Because I Didn’t Answer a Personal Question
So, I got invited for this interview, and they told me to be there at 9 AM. Of course, I get there early, like 8:30, because I don't want to be late. But then I end up waiting for 1.5 hours. Seriously, they didn't even acknowledge me until 10. Then this HR lady calls me in, and she's totally unprofessional. She's like, on her phone, making personal calls while I'm sitting right there. And then she starts asking me these really weird questions, like what my nickname is, and what my dad does for a living. It got really uncomfortable when she started pressing for details about where my dad works. I mean, what does that have to do with anything? So I politely told her I didn't want to answer, and she actually said, "Then we can't continue this interview." I was honestly shocked. But instead of arguing, I just stood up and said, “Alright then.” And walked out. I left feeling pissed. Not only did they waste an hour of my time, but the HR rep was also rude and unprofessional..
Got a question about BigBasket?
Ask anonymously on communities.

Interview questions from similar companies

Analyst Interview Questions & Answers

Flipkart user image Pratyaksh Karan

posted on 28 Mar 2015

Interview Preparation Tips

Round: Group Discussion
Experience: Nicely organized GD, civilized and intellectual GD group, discussion rich topic
Tips: Allow others to speak when they have something to say. Do try to push your way in if someone is talking too long or talking gibberish. Do not push your point too much, however, present logical arguments in favor. Try to draw similarities from what others say. Try to include all.

Round: HR Interview
Experience: Friendly HR interviewer. Non-direct questions but not too difficult.
Tips: Answer all questions honestly but be polite. Don't present too strong views, you are too young for that. Don't repeat content with different words, but be elaborate enough to let the interviewer know you.

Round: Guesstimate Interview
Tips: Read up some guesstimates and case studies before placements, discuss some with friends too. Open up your mind while guesstimating. Speak all that comes to your head, and vocally sift through them to get the logical and pursue-able approaches. The interviewer should get a complete idea of your analytical approach.

College Name: IIT Kharagpur
Motivation: First foray into corporate structure. Lots of opportunities. Diversified experiences.

Data Analyst Interview Questions & Answers

Amazon user image Anonymous

posted on 19 Nov 2020

I appeared for an interview before Nov 2019.

Interview Questionnaire 

4 Questions

  • Q1. How do you know about this company?
    • Add your answer
  • Q2. I have research about this company from various ways and collect a good bunch of information and decided to hire job from this company.
    • Add your answer
  • Q3. In which skill you are fit to perfect?
    • Add your answer
  • Q4. Well, iam a quick learner i grab new things at early stage i like to learn new things and perfection is my desire i try to get learn fast and getting knowledge is my aim.
    • Add your answer

Data Analyst Interview Questions & Answers

Flipkart user image Anonymous

posted on 13 Jun 2021

I applied via Company Website and was interviewed in May 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Salary and designation
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - 1

Data Analyst Interview Questions & Answers

Amazon user image

posted on 31 May 2021

I applied via Walk-in and was interviewed before May 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Introducing your self
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident

Data Analyst Interview Questions & Answers

Flipkart user image Anonymous

posted on 11 Jan 2022

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

Interview Questionnaire 

1 Question

  • Q1. Sql questions based on group by , windows functions , functions
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident. Understand the role very clearly.

Data Analyst Interview Questions & Answers

Amazon user image Anonymous

posted on 2 Oct 2020

I applied via Walk-in and was interviewed in Sep 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Aptitude question
    • Add your answer
  • Q2. Interview panalam questions
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - How many rounds of interview and aptitude questions models

Analyst Interview Questions & Answers

Zomato user image Anonymous

posted on 17 Dec 2022

I applied via Referral and was interviewed before Dec 2021. 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 tips
Round 2 - Technical 

(2 Questions)

  • Q1. Basic sql and joins ..
    • Add your answer
  • Q2. Advance excel is a must have
    • Add your answer
Round 3 - Case Study 

Price precision of riders, city wise calculation of cost per orders and earnings

Round 4 - HR 

(1 Question)

  • Q1. Salary expectations and all
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - plz prepare for business understanding like how businesses works and at the end how you values to the company

Analyst Interview Questions & Answers

DMart user image Anonymous

posted on 3 Oct 2023

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

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

Round 1 - Case Study 

Case study on Dmart financials

Round 2 - HR 

(2 Questions)

  • Q1. How soon can you join
    • Add your answer
  • Q2. Immediately I can join
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Do your MBA

Analyst Interview Questions & Answers

Swiggy user image Anonymous

posted on 3 Dec 2022

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 tips
Round 2 - Technical 

(2 Questions)

  • Q1. SQL hakcerank test, 10 questions 1 hour
    • Add your answer
  • Q2. On sql mainly, with some python and Excel.
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare sql well, joins, lag, lead, row_number and other advance function in sql are must.
More about working at BigBasket
golden leaf award

#9 Best Tech Startup - 2021

golden leaf award

BigBasket Interview FAQs

How many rounds are there in BigBasket Data Analyst 2 interview?
BigBasket interview process usually has 2 rounds. The most common rounds in the BigBasket interview process are Technical.
What are the top questions asked in BigBasket Data Analyst 2 interview?

Some of the top questions asked at the BigBasket Data Analyst 2 interview -

  1. Running values third high...read more
  2. Sql based queries like rank dense rank replacing bill values and some basic que...read more
  3. CTE function, aggregate functi...read more

Tell us how to improve this page.

BigBasket Interviews By Designations

Interview Questions for Popular Designations

Join BigBasket India's largest online supermarket

Interview Questions from Similar Companies

Amazon Interview Questions
4.1
 • 5k Interviews
Reliance Retail Interview Questions
3.9
 • 1.6k Interviews
Flipkart Interview Questions
4.0
 • 1.3k Interviews
Amazon Development Centre India Interview Questions
4.1
 • 749 Interviews
Swiggy Interview Questions
3.8
 • 428 Interviews
DMart Interview Questions
3.9
 • 404 Interviews
PolicyBazaar Interview Questions
3.6
 • 357 Interviews
JustDial Interview Questions
3.5
 • 329 Interviews
Zomato Interview Questions
3.8
 • 312 Interviews
Blinkit Interview Questions
3.7
 • 182 Interviews
View all

Fast track your campus placements

Institute of Rural Management (IRMA), Anand Placement Questions
2 Interviews
Dayananda Sagar College of Engineering, Bangalore Placement Questions
1 Interview
Galgotias College of Engineering and Technology, Greater Noida Placement Questions
1 Interview
Jetking Computer Hardware and Network Institute, Delhi Placement Questions
1 Interview
KIIT University, Bhuvaneshwar Placement Questions
1 Interview
View all
BigBasket Salaries in India
Business Development Executive
654 salaries
unlock blur

₹2 L/yr - ₹5.5 L/yr

Inventory Executive
434 salaries
unlock blur

₹2.1 L/yr - ₹5.2 L/yr

Operations Controller
380 salaries
unlock blur

₹2 L/yr - ₹5.4 L/yr

Shift Incharge
369 salaries
unlock blur

₹1.9 L/yr - ₹5.8 L/yr

Customer Support Executive
326 salaries
unlock blur

₹1.7 L/yr - ₹3.8 L/yr

Explore more salaries
Compare BigBasket with

Milkbasket

3.9
Compare

Amazon

4.1
Compare

Blinkit

3.7
Compare

Nature's Basket

3.8
Compare
Popular Calculators
Are you paid fairly?
Monthly In-hand Salary Calculator
Gratuity Calculator
HRA Calculator
Salary Hike Calculator
Did you find this page helpful?
Yes No
write
Share an Interview