Add office photos
i
Zepto
Compare
Filter interviews by
Zepto Data Analyst Interview Questions, Process, and Tips
Top Zepto Data Analyst Interview Questions and Answers
- Q1. As a data analyst can you do data entry work also?
- Q2. how fast can you prepare a bar chart with product operations data
- Q3. how can I do merge multiple excel files together
2 Zepto Data Analyst Interview Experiences
11 questions found
Anonymous
Selected
I applied via Approached by Company and was interviewed in Apr 2023.
2 Interview Rounds
Resume Shortlist Round
Technical Round (6 Questions)
- Q1. Joins, operations questions not data analysis questions Add Answer
- Q2. Customer retention case study Add Answer
- Q3. Cumulative sum for given table View Answers (1)
- Q4. Do you have experience in operations/data entry role View Answers (1)
- Q5. As a data analyst can you do data entry work also? View Answers (1)
- Q6. Normal excel statements like if, vlookup, xlookups etc., Add Answer
Interview Preparation Tips
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
Selected
I applied via Approached by Company and was interviewed in Apr 2023.
6 Interview Rounds
Resume Shortlist Round
HR Round (2 Questions)
- Q1. Screening questions Add Answer
- Q2. Name, age, qualification, prior experience etc Add Answer
Case Study Round
Operation questions like vlookups, Hlookups, xlookups etc,.
Case Study Round
Reporting questions like pivot tables, typing speed, power pivots, pricing sheet preparation
Case Study Round
SQL queries like joins, aggregation functions, filters etc,.
One-on-one Round (3 Questions)
- Q1. Advanced analytics and finding trends and patterns with MH - operations data Add Answer
- Q2. How fast can you prepare a bar chart with product operations data View Answers (1)
- Q3. How can I do merge multiple excel files together View Answers (1)
Skills evaluated in this interview
Interview questions from similar companies
Gautham Reddy
2 Interview Rounds
Technical Round (2 Questions)
- Q1. Interviewer asked me basic SQL questions Add Answer
- Q2. In the second technical round he asked me advanced SQL topics (Windows Functions, Joins & Subqueries) Add Answer
Coding Test Round
In the second technical round interview asked me about advanced sql topics, theory questions and two coding questions in joins and window functions.
1 Interview Round
Technical Round (5 Questions)
- Q1. Basic Excel Questions Add Answer
- Q2. Medium and Basic SQL Questions Add Answer
- Q3. Resume based Question Add Answer
- Q4. Case Study Questions Add Answer
- Q5. Questions on Project Add Answer
I applied via Naukri.com and was interviewed in Jul 2024.
1 Interview Round
Coding Test Round
SQL based questions wer asked on joins , rank function,
Selected
I applied via LinkedIn and was interviewed in Apr 2024.
1 Interview Round
Technical Round (2 Questions)
- Q1. SQL base Question Add Answer
- Q2. About your projects Add Answer
I applied via Instahyre and was interviewed in May 2024.
2 Interview Rounds
Coding Test Round
Asked to write different SQL queries.
1. Moving average of lf previous 10 days
2. For a data which records in and out time of an employee. How many employees were present in the office at a given time
3. A/B testing vs pre-post testing
Case Study Round
1. Had to come up with a method to give a score to each user based on FRM(frequency, recency, monetory)
2. Guesstimate: how many burgers does McD sells in a day
Selected
I applied via Company Website and was interviewed in Jul 2023.
4 Interview Rounds
Resume Shortlist Round
Aptitude Test Round
Number sires, clock, logic, arithmetic, geometry
Coding Test Round
Code test basic, ans the basic knowledge, write code
Technical Round (5 Questions)
- Q1. What is python? View Answers (2)
- Q2. What is python used for? View Answers (2)
- Q3. What type of language is python? View Answers (1)
- Q4. What is oops in python? View Answers (1)
- Q5. What is array in python? View Answers (1)
Interview Preparation Tips
- Advanced Excel
- SQL Server
- Python
Skills evaluated in this interview
2 Interview Rounds
Technical Round (1 Question)
- Q1. Joins and basics Add Answer
Case Study Round
Netflix user churn case study,
Uber booking number reduce
Snigdha Dhupal
I applied via Job Portal
2 Interview Rounds
Coding Test Round
SQL and Python data analysis questions
Technical Round (1 Question)
- Q1. How do you match the data in different columns. View Answers (1)
Zepto Interview FAQs
Tell us how to improve this page.
Zepto Interviews By Designations
- Zepto Shift Incharge Interview Questions
- Zepto Senior Software Engineer Interview Questions
- Zepto Software Development Engineer 3 Interview Questions
- Zepto Operations Manager Interview Questions
- Zepto MIS Executive Interview Questions
- Zepto Product Manager Interview Questions
- Zepto Software Developer Interview Questions
- Zepto Software Development Engineer II Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
Data Analyst Interview Questions from Similar Companies
Fast track your campus placements
Zepto Data Analyst Reviews and Ratings
based on 3 reviews
Rating in categories
|
Shift Incharge
363
salaries
|  ₹2 L/yr - ₹4.5 L/yr |
|
Store Manager
118
salaries
| ₹3.1 L/yr - ₹8.5 L/yr |
|
Team Lead
115
salaries
| ₹2 L/yr - ₹8 L/yr |
|
Senior Manager
112
salaries
| ₹13 L/yr - ₹30 L/yr |
|
Store Incharge
86
salaries
| ₹2.1 L/yr - ₹4.5 L/yr |
Blinkit
Dunzo
BigBasket
Swiggy
Calculate your in-hand salary
- Home >
- Interviews >
- Zepto Interview Questions >
- Zepto Data Analyst Interview Questions
