Search

Interview Questions

  • Reviews
  • Salaries
  • Interview Questions
  • About Company
  • Benefits
  • Jobs
  • Office Photos
  • Community
+ Contribute
notification
notification
Login
Upload Button Icon Add office photos
Engaged Employer

i

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

CityMall Verified Tick

Compare button icon Compare button icon Compare
3.2

based on 266 Reviews

Filter interviews by

CityMall Business Analyst Interview Questions and Answers

Updated 5 Mar 2024

CityMall Business Analyst Interview Experiences

1 interview found

Business Analyst Interview Questions & Answers

user image Samadhan Raghunath Tidke

posted on 5 Mar 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Sql Join / Window Functions in SQL
  • Ans. 

    SQL Join is used to combine rows from two or more tables based on a related column. Window functions perform calculations across a set of table rows that are related to the current row.

    • SQL Join is used to retrieve data from multiple tables based on a related column between them.

    • Window functions in SQL are used to perform calculations on a set of rows related to the current row.

    • Examples of SQL Join include INNER JOIN, L...

    • Answered by AI
    Add your answer

Skills evaluated in this interview

Top trending discussions

View All
Interview Tips & Stories
2w (edited)
timepasstiwari
·
A Digital Markter
Got Rejected In an Interview, Just Because I Didn’t Answer a Personal Question
So, I got invited for this interview, and they told me to be there at 9 AM. Of course, I get there early, like 8:30, because I don't want to be late. But then I end up waiting for 1.5 hours. Seriously, they didn't even acknowledge me until 10. Then this HR lady calls me in, and she's totally unprofessional. She's like, on her phone, making personal calls while I'm sitting right there. And then she starts asking me these really weird questions, like what my nickname is, and what my dad does for a living. It got really uncomfortable when she started pressing for details about where my dad works. I mean, what does that have to do with anything? So I politely told her I didn't want to answer, and she actually said, "Then we can't continue this interview." I was honestly shocked. But instead of arguing, I just stood up and said, “Alright then.” And walked out. I left feeling pissed. Not only did they waste an hour of my time, but the HR rep was also rude and unprofessional..
Got a question about CityMall?
Ask anonymously on communities.

Interview questions from similar companies

Business Analyst Interview Questions & Answers

Tata 1mg user image Anonymous

posted on 12 Oct 2020

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
    Add your answer
  • Q2. Questions based on Case Studies
    • Add your answer

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

Team Lead Interview Questions & Answers

Meesho user image Anonymous

posted on 6 Mar 2022

I applied via Naukri.com and was interviewed before Mar 2021. There was 1 interview round.

Round 1 - HR 

(2 Questions)

  • Q1. What are your salary expectations?
    • Add your answer
  • Q2. Tell me about yourself.
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - I am Vishnu Sharma. It's qualification B.Sc (hon math). Three years experience in TL post.

Team Lead Interview Questions & Answers

Swiggy user image Anonymous

posted on 4 Feb 2021

Interview Questionnaire 

1 Question

  • Q1. Team handling
    • Add your answer

Business Analyst Interview Questions & Answers

Swiggy user image Anonymous

posted on 13 May 2021

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
    Add your answer

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

Team Lead Interview Questions & Answers

Udaan user image Anonymous

posted on 15 Apr 2021

I applied via Recruitment Consultant and was interviewed in Oct 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Sales
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Good company

Team Lead Interview Questions & Answers

Udaan user image Anonymous

posted on 12 Mar 2020

I applied via Naukri.com and was interviewed in Sep 2019. There were 4 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. How to increase business?
  • Ans. 

    To increase business, focus on customer satisfaction, expand marketing efforts, and offer promotions.

    • Improve customer service to increase customer satisfaction and loyalty

    • Expand marketing efforts through social media, email marketing, and targeted advertising

    • Offer promotions such as discounts, referral programs, and loyalty rewards

    • Analyze market trends and adjust business strategies accordingly

    • Collaborate with other bu...

    • Answered by AI
    Add your answer
  • Q2. Case study and solutions to business problem
    • Add your answer
  • Q3. Experience
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - There were 40 candidates and 2 posts were there,
The interview was ,
Written test,
Group discussion,
Interview with Manager.

You need to be prepared for ground level questions.

Team Lead Interview Questions & Answers

Udaan user image Anonymous

posted on 16 Nov 2021

I applied via Walk-in and was interviewed before Nov 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Your last month ctc salary
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare your answer for commonly asked interview questions

Business Analyst Interview Questions & Answers

Swiggy user image Anonymous

posted on 11 May 2021

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.
    • Add your answer

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.

Business Analyst Interview Questions & Answers

Udaan user image Anonymous

posted on 6 May 2021

I appeared for an interview in Nov 2020.

Interview Questionnaire 

1 Question

  • Q1. Mainly about sql, previous job role
    • Add your answer
More about working at CityMall

CityMall Interview FAQs

How many rounds are there in CityMall Business Analyst interview?
CityMall interview process usually has 1 rounds. The most common rounds in the CityMall interview process are Technical.
How to prepare for CityMall Business Analyst interview?
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 CityMall. The most common topics and skills that interviewers at CityMall expect are Business Analysis, SQL, Analytical skills, Analytics and E-commerce.

Tell us how to improve this page.

CityMall Interviews By Designations

Interview Questions for Popular Designations

CityMall Business Analyst Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Business Analyst Interview Questions from Similar Companies

Meesho Business Analyst Interview Questions
3.7
 • 43 Interviews
Swiggy Business Analyst Interview Questions
3.8
 • 24 Interviews
Reliance Retail Business Analyst Interview Questions
3.9
 • 8 Interviews
CARS24 Business Analyst Interview Questions
3.5
 • 7 Interviews
Tata 1mg Business Analyst Interview Questions
3.6
 • 4 Interviews
Udaan Business Analyst Interview Questions
4.0
 • 3 Interviews
Digit Insurance Business Analyst Interview Questions
3.9
 • 3 Interviews
Porter Business Analyst Interview Questions
3.9
 • 3 Interviews
Licious Business Analyst Interview Questions
3.7
 • 2 Interviews
NOON.COM Business Analyst Interview Questions
3.7
 • 2 Interviews
View all
CityMall Business Analyst Salary
based on 45 salaries
₹6.6 L/yr - ₹24 L/yr
63% more than the average Business Analyst Salary in India
View more details

CityMall Business Analyst Reviews and Ratings

based on 12 reviews

3.1/5

Rating in categories

3.5

Skill development

2.4

Work-life balance

3.6

Salary

1.4

Job security

2.9

Company culture

2.3

Promotions

2.9

Work satisfaction

Explore 12 Reviews and Ratings
CityMall Salaries in India
Team Lead
85 salaries
unlock blur

₹2.8 L/yr - ₹5.6 L/yr

Relationship Manager
46 salaries
unlock blur

₹2 L/yr - ₹4.5 L/yr

Business Analyst
45 salaries
unlock blur

₹6.6 L/yr - ₹24 L/yr

Program Manager
38 salaries
unlock blur

₹12 L/yr - ₹25 L/yr

Category Manager
29 salaries
unlock blur

₹10 L/yr - ₹37.2 L/yr

Explore more salaries
Compare CityMall with

Udaan

4.0
Compare

Swiggy

3.8
Compare

CARS24

3.5
Compare

BlackBuck

3.8
Compare
Popular Calculators
Are you paid fairly?
Monthly In-hand Salary Calculator
Gratuity Calculator
HRA Calculator
Salary Hike Calculator
Did you find this page helpful?
Yes No
write
Share an Interview