AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
i
Zepto
Compare
Filter interviews by
Zepto Senior Product Analyst Interview Questions and Answers
Zepto Senior Product Analyst Interview Experiences
1 interview found
Anonymous
I applied via Instahyre and was interviewed in Sep 2024. There was 1 interview round.
The coding test was basically around the questions which will never come in use, You shall be asking what is actually required in the real word and check the approach if the other person knows the approach or not.
Interview Preparation Tips
What people are saying about Zepto
Interview questions from similar companies
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
I appeared for an interview in Nov 2020.
Interview Questionnaire
1 Question
- Q1. Mainly about sql, previous job role
I applied via LinkedIn and was interviewed in Mar 2022. There were 5 interview rounds.
The test was based on SQL and the questions were similar to medium difficulty level questions in leetcode.
(3 Questions)
- Q1. Describe different types of joins
- Ans.
Different types of joins are used in database queries to combine data from multiple tables.
Inner join: Returns only the matching records from both tables.
Left join: Returns all records from the left table and the matching records from the right table.
Right join: Returns all records from the right table and the matching records from the left table.
Full outer join: Returns all records when there is a match in either the ...
- Q2. 2 tables were given and I was asked to tell the number of rows in output based on different types of joins.
- Q3. Calculated the rows based on joins and told the answer.
(4 Questions)
- Q1. Describe your previous experience
- Ans.
I have 3 years of experience as a Business Analyst in the IT industry.
Worked on gathering and analyzing business requirements
Created functional specifications and user stories
Conducted stakeholder interviews and facilitated meetings
Performed data analysis and created reports
Collaborated with cross-functional teams to implement solutions
Utilized tools like JIRA and Confluence for project management
Improved business proc
- Q2. Shared the details regarding my experience
- Q3. A SQL based puzzle based on window functions where I had to find 4 consecutive empty seats in a theater.
- Q4. Solved using lag function.
The interviewer asked about my previous experience along with a few situation based questions and then gave me a case study to find out possible reasons for a decrease in the cancellations between order dispatch and order delivery.
Interview Preparation Tips
- SQL
- Problem solving
Skills evaluated in this interview
(1 Question)
- Q1. Guesstimates, SQL, MS-Excel related questions.
A case study, few HR questions.
Interview Preparation Tips
Selected
I applied via Referral and was interviewed before Oct 2022. There were 4 interview rounds.
SQL Assignment: Decent SQL questions were provided, Answers were provided with detailed approach. Time-in out sql problem, cohorts problem was there
(1 Question)
- Q1. Partition functions,creating dynamic buckets and sql puzzles were the highlights
Case study to understand the problem-solving aptitude was asked. Focus was more on the approach rather than the final outcome
Interview Preparation Tips
I applied via Inkedin and was interviewed in Sep 2023. There were 3 interview rounds.
Sql and python,numpy,pandas
(1 Question)
- Q1. Analyst skills,data handlling
Selected
I applied via Campus Placement and was interviewed in Apr 2023. There were 3 interview rounds.
(1 Question)
- Q1. DBMS? Questions from Graduation Project
(1 Question)
- Q1. SQL RDBMS Situational based questions
I applied via LinkedIn and was interviewed in May 2023. There were 3 interview rounds.
4 challenges on coderbyte
(1 Question)
- Q1. Joins, windowed function and basic sql queries
(1 Question)
- Q1. SQL, Case study, and puzzles.
Interview Preparation Tips
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 Store Manager Interview Questions
- Zepto Software Developer Interview Questions
- Zepto Operations Manager Interview Questions
- Zepto Team Lead Interview Questions
- Zepto MIS Executive Interview Questions
- Show more
Interview Questions for Popular Designations
- Production Engineer Interview Questions
- Production Supervisor Interview Questions
- Product Manager Interview Questions
- Production Manager Interview Questions
- Production Analyst Interview Questions
- Production Officer Interview Questions
- Executive Production Interview Questions
- Production Interview Questions
- Show more
Zepto Senior Product Analyst Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
|
Shift Incharge
412
salaries
|  ₹2 L/yr - ₹4.8 L/yr |
|
Store Manager
158
salaries
| ₹3 L/yr - ₹8.5 L/yr |
|
Team Lead
148
salaries
| ₹2 L/yr - ₹8.4 L/yr |
|
Senior Manager
133
salaries
| ₹10 L/yr - ₹31 L/yr |
|
Store Incharge
94
salaries
| ₹2.3 L/yr - ₹5 L/yr |
Blinkit
Dunzo
BigBasket
Swiggy
- Home >
- Interviews >
- Zepto Interview Questions >
- Zepto Senior Product Analyst Interview Questions
