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 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 Jul 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Some general knowledge question regarding shoping and what is justdial

Interview Preparation Tips

Interview preparation tips for other job seekers - It was good

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 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 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.

Interview Questionnaire 

1 Question

  • Q1. SQL and excel questions.

Interview Preparation Tips

Interview preparation tips for other job seekers - Good experience , interviewers were helpful, understand the approach

I applied via Company Website and was interviewed in Oct 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. I went as a fresher for the job. They asked me technical skills and good cummication skills.
  • Q2. I am interested to do in it

Interview Preparation Tips

Interview preparation tips for other job seekers - I am bathula suresh yadav from medchal
I am pursuing my graduation final year (bcom
Computer)
I have technical skills and good at computer knowledge
I have good cummication skills
Thanking you
Yours careingly

I applied via Recruitment Consultant and was interviewed before Jun 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Pivot and excel questions
  • Q2. All about excel

Interview Preparation Tips

Interview preparation tips for other job seekers - It was very simple self intro and excel questions and basic macro

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
Flipkart Interview Questions
3.9
 • 1.3k Interviews
PolicyBazaar Interview Questions
3.6
 • 379 Interviews
JustDial Interview Questions
3.5
 • 330 Interviews
Uber Interview Questions
4.2
 • 150 Interviews
Expedia Group Interview Questions
3.8
 • 75 Interviews
LinkedIn Interview Questions
4.3
 • 65 Interviews
Times Internet Interview Questions
3.6
 • 65 Interviews
View all
Business Development Executive
648 salaries
unlock blur

₹2 L/yr - ₹5.1 L/yr

Shift Incharge
458 salaries
unlock blur

₹2 L/yr - ₹5.3 L/yr

Inventory Executive
444 salaries
unlock blur

₹2.1 L/yr - ₹5.2 L/yr

Operations Controller
377 salaries
unlock blur

₹2 L/yr - ₹5.4 L/yr

Customer Support Executive
325 salaries
unlock blur

₹1.6 L/yr - ₹3.8 L/yr

Explore more salaries
Compare BigBasket with

Milkbasket

3.9
Compare

Amazon

4.1
Compare

Blinkit

3.7
Compare

Flipkart

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