Upload Button Icon Add office photos
Premium Employer

i

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

Zepto

Compare button icon Compare button icon Compare
3.6

based on 936 Reviews

Filter interviews by

Zepto Senior Business Analyst Interview Questions and Answers

Updated 25 Dec 2024

Zepto Senior Business Analyst Interview Experiences

2 interviews found

Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Windows Function
  • Q2. Joins (Self, Left, Right, Outer)
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Company Website and was interviewed in Jun 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. SQL question about joins on table having null values
  • Q2. SQL question on lead/lag/cummulative sum application

Senior Business Analyst Interview Questions Asked at Other Companies

asked in Sapiens
Q1. Difference between annuity and pension, types of annuity and pens ... read more
Q2. If you had to accommodate a CR in agile how would you do so?
asked in Brillio
Q3. If I tell you to prepare a TOC for a RFP what will you put into i ... read more
Q4. What are the different meetings that happen in Agile style develo ... read more
asked in EVRY India
Q5. Five concepts in artificial intelligence, In machine learnin ... read more

Interview questions from similar companies

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Nov 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

8 SQl questions of easy, medium and hard diffiulty

Round 2 - Technical 

(2 Questions)

  • Q1. SQL Question on join
  • Q2. SQL question on window funtions
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Questions on sql joins and window functions.
  • Q2. Window functions

Interview Preparation Tips

Interview preparation tips for other job seekers - Mostly on resume points.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

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

Round 1 - Coding Test 

Hacker rank test with SQL questions

Round 2 - Coding Test 

Design the database and write a query to find the most re-ordered product

Round 3 - Case Study 

Case study and technical round - database design questions and analytical thinking check

Round 4 - Case Study 

HR Related questions and market entry level case study

Interview Preparation Tips

Topics to prepare for Meesho Senior Business Analyst interview:
  • SQL
  • Case Studies
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Instahyre and was interviewed in Nov 2023. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Going through your resume, past projects and metrics around that project.
  • Q2. 2 SQL questions. 1. based on logic 2nd highest salary. 2. Basic Question on window functions and self join
Round 2 - Technical 

(2 Questions)

  • Q1. RCA on why the conversion is down on the app.
  • Q2. SQL question of high difficulty (don't remember the question as that was his self made question) Logic used: self join with date
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. 1.pivot function sql question 2.write a code in python to print out a triangle
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Jun 2023. There were 2 interview rounds.

Round 1 - Coding Test 

SQL and Tableau were asked. 4 questions each.

Round 2 - Case Study 

Case study was asked related to covid

Interview Preparation Tips

Topics to prepare for Tata 1mg Senior Business Analyst interview:
  • SQL
  • Tableau
  • Excel
Interview preparation tips for other job seekers - easy interview round. easy to crack. be confident and present in the interview.
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Questions on SQL joins, window functions etc.

I applied via Instahyre and was interviewed before Aug 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 tips
Round 2 - Technical 

(1 Question)

  • Q1. Around advance sql, mostly windows function use case and some scenario based sql problem which will require windows function to solve.
  • Ans. Lead lag function and rank function
  • Answered Anonymously
Round 3 - Case Study 

It's a general case study round, motive is to know your thought process.

Interview Preparation Tips

Topics to prepare for PharmEasy Senior Business Analyst interview:
  • SQL
  • Python
Interview preparation tips for other job seekers - Prepare sql well, python especially pandas, and common puzzles problem

Zepto Interview FAQs

How many rounds are there in Zepto Senior Business Analyst interview?
Zepto interview process usually has 1 rounds. The most common rounds in the Zepto interview process are Technical.
How to prepare for Zepto Senior Business 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 Zepto. The most common topics and skills that interviewers at Zepto expect are SQL, Python, Analytics, Advanced Excel and Analytical.
What are the top questions asked in Zepto Senior Business Analyst interview?

Some of the top questions asked at the Zepto Senior Business Analyst interview -

  1. SQL question about joins on table having null val...read more
  2. SQL question on lead/lag/cummulative sum applicat...read more
  3. Joins (Self, Left, Right, Out...read more

Tell us how to improve this page.

People are getting interviews through

based on 1 Zepto interview
Company Website
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
Zepto Senior Business Analyst Salary
based on 13 salaries
₹11 L/yr - ₹28.3 L/yr
32% more than the average Senior Business Analyst Salary in India
View more details
Shift Incharge
371 salaries
unlock blur

₹2 L/yr - ₹4.5 L/yr

Team Lead
129 salaries
unlock blur

₹2 L/yr - ₹8 L/yr

Store Manager
126 salaries
unlock blur

₹2.2 L/yr - ₹8.5 L/yr

Senior Manager
118 salaries
unlock blur

₹10 L/yr - ₹30 L/yr

Store Incharge
90 salaries
unlock blur

₹2.3 L/yr - ₹4.5 L/yr

Explore more salaries
Compare Zepto with

Blinkit

3.7
Compare

Dunzo

3.4
Compare

BigBasket

3.9
Compare

Swiggy

3.8
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview