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

Filter interviews by

BigBasket Data Analyst 2 Interview Questions and Answers

Updated 26 Feb 2022

BigBasket Data Analyst 2 Interview Experiences

1 interview found

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
  • Q2. CTE function, aggregate functions
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
  • Q2. And some manager level questions

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

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.

I appeared for an interview before Nov 2019.

Interview Questionnaire 

4 Questions

  • Q1. How do you know about this company?
  • 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.
  • Q3. In which skill you are fit to perfect?
  • 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.

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

Interview Questionnaire 

1 Question

  • Q1. Salary and designation

Interview Preparation Tips

Interview preparation tips for other job seekers - 1

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

Interview Questionnaire 

1 Question

  • Q1. Introducing your self

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident

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

Interview Preparation Tips

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

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

Interview Questionnaire 

2 Questions

  • Q1. Aptitude question
  • Q2. Interview panalam questions

Interview Preparation Tips

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

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 ..
  • Q2. Advance excel is a must have
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

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
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
  • Q2. Immediately I can join

Interview Preparation Tips

Interview preparation tips for other job seekers - Do your MBA
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
  • Q2. On sql mainly, with some python and Excel.

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.

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.

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
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
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
Did you find this page helpful?
Yes No
write
Share an Interview