AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Licious
Compare
Filter interviews by
Licious Business Analyst Interview Questions and Answers
Licious Business Analyst Interview Experiences
2 interviews found
Anonymous
(1 Question)
- Q1. Sql questions on advanced concepts
(1 Question)
- Q1. Previous experience and business questions
Selected
I applied via Approached by Company and was interviewed in Oct 2023. There were 3 interview rounds.
(2 Questions)
- Q1. SQL basic questions, group by having etc
- Q2. SQL intermediate questions- cte, nested queries, window function etc
(2 Questions)
- Q1. Some Business Case study question
- Q2. Hiring manager discussions
(2 Questions)
- Q1. Intent to join the org.
- Ans.
I am excited to join the organization because of its reputation for innovation and growth opportunities.
I am impressed by the company's track record of success in the industry.
I am excited about the potential for career advancement and professional development within the organization.
I believe that my skills and experience align well with the company's goals and values.
- Q2. Why do you want to join this company only, when many similar companies are available in the market?
- Ans.
I am impressed by the company's innovative approach, strong reputation, and commitment to employee growth.
I am drawn to the company's reputation for innovation and cutting-edge technology.
I admire the company's strong track record of success and growth in the industry.
I value the company's commitment to employee development and growth opportunities.
I believe that the company's culture and values align with my own profe
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...
- Q2. Questions based on Case Studies
Interview Preparation Tips
I applied via Referral and was interviewed before May 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. How can you understand the supply of restaurant in a particular area of a city ?
- Ans.
To understand the supply of restaurants in a particular area of a city, we can use various methods.
Collect data from online directories like Yelp, Zomato, etc.
Conduct surveys to gather information about the number of restaurants in the area.
Analyze the population density and demographics of the area to estimate the demand for restaurants.
Check the number of restaurant permits issued by the local government.
Use GIS mapp...
Interview Preparation Tips
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
(1 Question)
- Q1. Guesstimates, SQL, MS-Excel related questions.
A case study, few HR questions.
Interview Preparation Tips
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...
- 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
- 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...
Interview Preparation Tips
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
I applied via Recruitment Consulltant and was interviewed in Apr 2024. There were 2 interview rounds.
HackerRank Test - 3 questions
SQL - Window functions and Joins
(1 Question)
- Q1. SQL - Joins, window functions and stored procedure
Licious Interview FAQs
Tell us how to improve this page.
Licious Interviews By Designations
- Licious Executive Production Interview Questions
- Licious Software Developer Interview Questions
- Licious Assistant Manager Interview Questions
- Licious Junior Qa Executive Interview Questions
- Licious Business Analyst Interview Questions
- Licious Software Development Engineer II Interview Questions
- Licious Management Trainee Interview Questions
- Licious Software Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
- Business Development Executive Interview Questions
- Business Development Manager Interview Questions
- Business Development Associate Interview Questions
- Senior Business Analyst Interview Questions
- Business Associate Interview Questions
- Business Development Interview Questions
- Business Executive Interview Questions
- Business Manager Interview Questions
- Show more
Licious Business Analyst Interview Process
based on 2 interviews
Interview experience
Business Analyst Interview Questions from Similar Companies
Fast track your campus placements
Licious Business Analyst Reviews and Ratings
based on 1 review
Rating in categories
|
HUB Manager
110
salaries
|  ₹2.9 L/yr - ₹5.3 L/yr |
|
Assistant Manager
101
salaries
| ₹1.8 L/yr - ₹10 L/yr |
|
QA Executive
36
salaries
| ₹3 L/yr - ₹4.6 L/yr |
|
Executive Production
36
salaries
| ₹2.8 L/yr - ₹7.5 L/yr |
|
Territory Sales Manager
32
salaries
| ₹6 L/yr - ₹14 L/yr |
BigBasket
Swiggy
CARS24
Udaan
- Home >
- Interviews >
- Licious Interview Questions >
- Licious Business Analyst Interview Questions
