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 Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Zepto Data Analyst Interview Questions and Answers for Experienced

Updated 27 Oct 2023

Zepto Data Analyst Interview Experiences for Experienced

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 24 May 2023

Interview experience
1
Bad
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in Apr 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 tips
Round 2 - Technical 

(6 Questions)

  • Q1. Joins, operations questions not data analysis questions
  • Q2. Customer retention case study
  • Q3. Cumulative sum for given table
  • Ans. 

    To calculate cumulative sum for a given table

    • Sort the table in ascending order based on the column you want to calculate the cumulative sum for

    • Add a new column to the table to store the cumulative sum

    • Iterate through each row of the table and calculate the cumulative sum by adding the current row's value to the previous row's cumulative sum

    • Store the cumulative sum in the new column for each row

  • Answered by AI
  • Q4. Do you have experience in operations/data entry role
  • Ans. 

    Yes, I have experience in both operations and data entry roles.

    • I have worked as a data entry operator for a pharmaceutical company where I was responsible for entering patient data into the system.

    • In my previous role as an operations analyst, I was responsible for analyzing data and creating reports for the management team.

    • I have experience using various data entry software such as Microsoft Excel and Google Sheets.

    • I a...

  • Answered by AI
  • Q5. As a data analyst can you do data entry work also?
  • Ans. 

    Yes, I can do data entry work as a data analyst.

    • Data entry work is a part of data analysis process.

    • I have experience in data entry work and can perform it efficiently.

    • Data entry work includes entering data into spreadsheets, databases, or other software.

    • I understand the importance of accurate data entry for effective analysis.

  • Answered by AI
  • Q6. Normal excel statements like if, vlookup, xlookups etc.,

Interview Preparation Tips

Interview preparation tips for other job seekers - 1) Waste of time (never trust interviewer who explains about the role)
2) they are looking for candidates for data reporting operations guy from a tier 1 college
3) as discussed with the interviewer the profile will be like a data entry operations role so get clarification on the role properly.
4) if you get an offer letter try to make this company as least priority company as the JD is not clear and the way they explain the case study is truly confusing.
5) other than this central tendency, normal crunching, joins, etc,.
6) People from non - data analytics team took an interview I hope there is no data analyst in the company while checking in LinkedIn and even the interviewer mentioned the same.
7) Interview will get rescheduled several times because of the interviewer and will be more delay
8) as per their discussion it will be more about data reporting in google sheets, excel on a daily basis i guess and I hope there won't be any proper predictive or quantitative or qualitative analysis.
9) if you are looking for better learning, growth and advancement in your career then this is not a correct company for you(that's how I decided when comparing offers from other company).
10) try to communicate with employees of the company who are in current role or past role get a better understanding.
11) current company situtation might push you but take a better decision.
12)chhallaaang lagaane se pahale dekho.

Skills evaluated in this interview

Interview questions from similar companies

I applied via LinkedIn and was interviewed in Apr 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. How can you reduce the delivery time of the order?
  • Ans. 

    Reducing delivery time can be achieved by optimizing the supply chain, improving communication, and automating processes.

    • Analyze the supply chain and identify bottlenecks

    • Implement automation tools to streamline processes

    • Improve communication between departments and with customers

    • Use data analytics to forecast demand and plan accordingly

    • Consider outsourcing or partnering with third-party logistics providers

    • Invest in tec...

  • Answered by AI
  • Q2. Questions based on Case Studies

Interview Preparation Tips

Interview preparation tips for other job seekers - The process consisted of two rounds. First was the business analysis kind of round which included the questions like how can you reduce the delivery time of the order? The second round was technical round where the person asked the questions on SQL and Excel

I applied via IIM Jobs and was interviewed in Nov 2020. There were 3 interview rounds.

Interview Questionnaire 

7 Questions

  • Q1. Advance SQL Questions.
  • Q2. Multiple Approaches in the SQL questions were seen. Some unconventional SQL Syntax was also asked.
  • Q3. Metrics Driven Case studies.
  • Q4. More number of solutions were seen instead of in depth implementation of 1 solution. Good Communication skills is judged.
  • Q5. Tell me something about yourself.
  • Ans. 

    I am a highly motivated and detail-oriented Business Analyst with a strong background in data analysis and problem-solving.

    • I have a Bachelor's degree in Business Administration with a focus on analytics.

    • I have experience working with cross-functional teams to gather and analyze business requirements.

    • I am proficient in using tools such as Excel, SQL, and Tableau for data analysis and visualization.

    • I have successfully im...

  • Answered by AI
  • Q6. Why quit last job.
  • Ans. 

    Seeking better growth opportunities and work-life balance.

    • Limited growth prospects in previous role

    • Lack of work-life balance

    • Desire for new challenges and learning opportunities

    • Company culture misalignment

    • Relocation or commute issues

    • Better compensation or benefits elsewhere

  • Answered by AI
  • Q7. Why Meesho.
  • Ans. 

    Meesho is a leading e-commerce platform that empowers individuals to start their own online businesses.

    • Meesho provides a user-friendly platform for individuals to sell products online without any investment.

    • It offers a wide range of products from various categories, allowing sellers to cater to different customer preferences.

    • Meesho provides extensive training and support to its sellers, helping them succeed in their on...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be calm, It's very similar to any other business analyst interview in industry.

I applied via LinkedIn and was interviewed before May 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Questions were from SQL, Python, Statistics & Business Case Studies/Metrics in the form of 4-5 rounds.

Interview Preparation Tips

Interview preparation tips for other job seekers - So Key Takeaway is You have to be good with your Technical Knowledge (SQL Expert, Python, Overall Stats Knowledge) and That is not really enough. What differs a Business Analyst from other Developers/Statisticians etc. is Business acumen, Problem Solving Skills etc. To have a Business Knowledge and Understanding such that you find the problems/solutions/ Metrics and then solve them using the Technology.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in May 2023. 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 - Coding Test 

4 challenges on coderbyte

Round 3 - Technical 

(1 Question)

  • Q1. Joins, windowed function and basic sql queries
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Internshala and was interviewed in Sep 2023. 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 - Aptitude Test 

Medium difficultty on pandas SQL

Round 3 - One-on-one 

(1 Question)

  • Q1. Coding interview python pandas medium difficulty
  • Ans. Solved it and had to discuss with manager
  • Answered by govind goel

Interview Preparation Tips

Topics to prepare for Paisabazaar.com Business Analyst interview:
  • Python
Interview preparation tips for other job seekers - Prepare pandas
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
More than 8 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed in Apr 2023. 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 - One-on-one 

(1 Question)

  • Q1. DBMS? Questions from Graduation Project
Round 3 - Technical 

(1 Question)

  • Q1. SQL RDBMS Situational based questions
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Mar 2024. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. More about your role and insurance based questions
Round 2 - Technical 

(1 Question)

  • Q1. More about insurance based and brd, requirements gathering, sdlc
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Jan 2024. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Explain about your work as BA in the insurance project
  • Ans. 

    As a BA in the insurance project, I analyzed business requirements, facilitated communication between stakeholders, and ensured project goals were met.

    • Analyzed business requirements to identify gaps and opportunities for improvement

    • Facilitated communication between stakeholders including business users, IT teams, and management

    • Ensured project goals were met by tracking progress, identifying risks, and proposing solutio...

  • Answered by AI
  • Q2. Agile methodologies, SQL knowledge , Insurance domain knowledge

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare Insurance terms .
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. SQL, Case study, and puzzles.

Interview Preparation Tips

Interview preparation tips for other job seekers - SQL, case study, and Puzzles. That's what I was asked.

Zepto Interview FAQs

How many rounds are there in Zepto Data Analyst interview for experienced candidates?
Zepto interview process for experienced candidates usually has 2 rounds. The most common rounds in the Zepto interview process for experienced candidates are Resume Shortlist and Technical.
How to prepare for Zepto Data Analyst interview for experienced candidates?
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 Analytical, Analytics, Business Intelligence, Business Strategy and Data Analysis.
What are the top questions asked in Zepto Data Analyst interview for experienced candidates?

Some of the top questions asked at the Zepto Data Analyst interview for experienced candidates -

  1. As a data analyst can you do data entry work al...read more
  2. cumulative sum for given ta...read more
  3. joins, operations questions not data analysis questi...read more

Tell us how to improve this page.

Zepto Data Analyst Interview Process for Experienced

based on 1 interview

Interview experience

1
  
Bad
View more
Join Zepto We’re revolutionizing the way India shops.
Zepto Data Analyst Salary
based on 12 salaries
₹2.4 L/yr - ₹7 L/yr
34% less than the average Data Analyst Salary in India
View more details

Zepto Data Analyst Reviews and Ratings

based on 5 reviews

3.6/5

Rating in categories

3.5

Skill development

2.5

Work-life balance

3.4

Salary

2.8

Job security

3.4

Company culture

2.8

Promotions

3.3

Work satisfaction

Explore 5 Reviews and Ratings
Shift Incharge
416 salaries
unlock blur

₹2.2 L/yr - ₹4.8 L/yr

Store Manager
162 salaries
unlock blur

₹3 L/yr - ₹8.5 L/yr

Team Lead
150 salaries
unlock blur

₹2 L/yr - ₹8.4 L/yr

Senior Manager
133 salaries
unlock blur

₹10 L/yr - ₹31 L/yr

Delivery Boy
105 salaries
unlock blur

₹0.6 L/yr - ₹6 L/yr

Explore more salaries
Compare Zepto with

Blinkit

3.7
Compare

Dunzo

3.4
Compare

BigBasket

3.9
Compare

Swiggy

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