Upload Button Icon Add office photos
Engaged Employer

i

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

Licious Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Licious Data Analyst Interview Questions and Answers

Updated 3 Aug 2024

Licious Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 3 Aug 2024

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 Jul 2024. There was 1 interview round.

Round 1 - Coding Test 

SQL based questions wer asked on joins , rank function,

Interview questions from similar companies

I applied via Naukri.com and was interviewed in Jan 2022. There were 2 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. What do I do in my existing job?
  • Q2. Why do you want to leave your existing job?
Round 2 - HR 

(2 Questions)

  • Q1. Tell me about yourself?
  • Q2. Why would you like to join our organisation?

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared, be confident and be humane.

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...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Understand any city's demographics for instance. Take most busy road and assume that 70% supply will be on food -tech (MArket Standard). Open Sw / Zo and see the supply available in that area in peak time. There can be more than one way to solve for these question

I applied via Company Website and was interviewed in Aug 2022. 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 Resume tips
Round 2 - Technical 

(2 Questions)

  • Q1. Ques.1 How many delivery boy have called customers more than 5 times?
  • Ans. 

    The number of delivery boys who called customers more than 5 times is not provided.

    • Data on the number of delivery boys who called customers more than 5 times is missing.

    • Need to gather data on the number of delivery boys and their call logs.

    • Analysis can be done once the data is available.

  • Answered by AI
  • Q2. Question 2. Count distinct uniques names from the table
  • Ans. 

    To count distinct unique names from a table, use the SELECT DISTINCT statement with the name column.

    • Use SELECT DISTINCT to retrieve unique names

    • Specify the name column in the SELECT statement

    • Example: SELECT DISTINCT name FROM table_name

    • Store the result in an array of strings

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepared well for SQL. Try to use hacker rank for the preparation.

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Aug 2024. There were 2 interview rounds.

Round 1 - Coding Test 

Technical + Analytics
I gave my coding test this august 2024, it was purely based on SQL coding
8 question, 3 easy, 3 intermediate and 3 hard.

Round 2 - One-on-one 

(2 Questions)

  • Q1. Introduction and explain any one of the projects plus what was the analytics you used
  • Ans. 

    Implemented a project to optimize marketing campaigns using predictive analytics

    • Developed a predictive model to identify the most effective marketing channels

    • Utilized data from past campaigns to train the model

    • Used techniques such as regression analysis and decision trees to analyze the data

    • Generated insights on customer behavior and preferences to improve campaign targeting

  • Answered by AI
  • Q2. SQL coding, shared screen and was asked to find cumulative sum of cost for a table.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be very very well prepared with SQL and you should be aware of advanced sql, not only concepts but solving questions
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - Coding Test 

Mostly sql question asked, moderate level

Round 2 - One-on-one 

(2 Questions)

  • Q1. Sql join and sub query
  • Q2. Window functions

I was interviewed in Nov 2020.

Interview Questionnaire 

1 Question

  • Q1. Mainly about sql, previous job role
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Nov 2023. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Find 3rd highest salary using SQL
  • Ans. 

    Use SQL query with ORDER BY and LIMIT to find 3rd highest salary.

    • Use SELECT statement to retrieve salary column

    • Use ORDER BY clause to sort salaries in descending order

    • Use LIMIT 2,1 to skip first two highest salaries and retrieve the third highest salary

  • Answered by AI
  • Q2. Queries on self join
Round 2 - Technical 

(1 Question)

  • Q1. Questions on Power B, DAX etc.,

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Sep 2022. There were 5 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 Resume tips
Round 2 - Coding Test 

Basic SQL questions

Round 3 - Technical 

(1 Question)

  • Q1. SQL python and basic statistics
Round 4 - Case Study 

Problem solving case studies, analytics cases

Round 5 - One-on-one 

(1 Question)

  • Q1. Hiring manager round, general HR questions and resume based questions
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

SQL test coding assessment which I am yet to give

Contribute & help others!
anonymous
You can choose to be anonymous

Licious Interview FAQs

How many rounds are there in Licious Data Analyst interview?
Licious interview process usually has 1 rounds. The most common rounds in the Licious interview process are Coding Test.

Recently Viewed

PHOTOS

InsuranceDekho

3 office photos

LIST OF COMPANIES

Credit Bajaar

Overview

INTERVIEWS

Greet Technologies

No Interviews

DESIGNATION

DESIGNATION

SALARIES

Oracle

JOBS

Ericsson

No Jobs

SALARIES

Digit Insurance

DESIGNATION

REVIEWS

Einfochips

No Reviews

Tell us how to improve this page.

Licious Data Analyst Interview Process

based on 1 interview

Interview experience

3
  
Average
View more
Licious Data Analyst Salary
based on 6 salaries
₹5 L/yr - ₹13.7 L/yr
100% more than the average Data Analyst Salary in India
View more details
HUB Manager
109 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Manager
101 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

QA Executive
36 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Executive Production
36 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Territory Sales Manager
32 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Licious with

BigBasket

3.9
Compare

FreshToHome

3.5
Compare

ZappFresh.com

3.0
Compare

Blinkit

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent