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
Compare
Filter interviews by
CityMall Business Analyst Interview Questions and Answers
Updated
5 Mar 2024
1 interview found
Sort by:
Popular
Samadhan Raghunath Tidke
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (1 Question)
- Q1. Sql Join / Window Functions in SQL View Answers (1)
Skills evaluated in this interview
Top trending discussions
View All
Interview Tips & Stories
2w (edited)
a consultant
Alternate documents for Employee verification?
My new employer asked for my previous offer letters and salary slips. When I inquired, they said it was for background verification.
However, I feel that providing these documents might affect salary negotiations, and it feels a bit unethical too.
What alternative documents can I provide for employment verification?
Got a question about CityMall?
Ask anonymously on communities.
Interview questions from similar companies
Anonymous
Interview experience
Average
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected
I applied via Campus Placement and was interviewed in Oct 2024.
3 Interview Rounds
1
Coding Test Round
It was based on 4 sql questions of medium to hard level and 24 mcqs based on sql,aptitude,excel.
2
Technical Round (1 Question)
- Q1. They give you some questions and you have to write sql queries for them Add Answer
3
Technical Round (1 Question)
- Q1. You are given case study and come sql questions based on that Add Answer
Interview experience
Excellent
Difficulty level
Moderate
Duration
2-4 weeks
Result
Not Selected
I applied via LinkedIn and was interviewed in Aug 2024.
2 Interview Rounds
1
Coding Test Round
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.
2
One-on-one Round (2 Questions)
- Q1. Introduction and explain any one of the projects plus what was the analytics you used View Answers (1)
- Q2. SQL coding, shared screen and was asked to find cumulative sum of cost for a table. Add Answer
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
Excellent
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected
I applied via Referral and was interviewed in Jun 2024.
2 Interview Rounds
1
One-on-one Round (2 Questions)
- Q1. Case study questions based on Logistics & Porter business. Add Answer
- Q2. More Case study & porter business questions Add Answer
2
Technical Round (2 Questions)
- Q1. Some medium SQL Queries Add Answer
- Q2. Some medium python codes Add Answer
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
Technical Round (1 Question)
- Q1. Sql questions on advanced concepts Add Answer
2
Behavioral Round (1 Question)
- Q1. Previous experience and business questions Add Answer
Interview experience
Good
Difficulty level
Moderate
Duration
-
Result
Selected
2 Interview Rounds
1
Resume Shortlist Round
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 tips
2
Technical Round (3 Questions)
- Q1. Business use cases on logistics & last mile delivery?? View Answers (2)
- Q2. Basic excel functions Add Answer
- Q3. Sumifs, pivot tables, Vlookup etc. Add Answer
vivek duggal
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
HR Round (2 Questions)
- Q1. Salary discussion Add Answer
- Q2. Expected salary vs what they can offer Add Answer
govind goel
Interview experience
Average
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected
I applied via Internshala and was interviewed in Sep 2023.
3 Interview Rounds
1
Resume Shortlist Round
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
2
Aptitude Test Round
Medium difficultty on pandas SQL
3
One-on-one Round (1 Question)
- Q1. Coding interview python pandas medium difficulty View Answers (1)
Interview Preparation Tips
Topics to prepare for Paisabazaar.com Business Analyst interview:
- Python
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (1 Question)
- Q1. SQL, Case study, and puzzles. Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - SQL, case study, and Puzzles. That's what I was asked.
Interview experience
Excellent
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via Naukri.com and was interviewed before Nov 2023.
2 Interview Rounds
1
Technical Round (2 Questions)
- Q1. Find 3rd highest salary using SQL View Answers (1)
- Q2. Queries on self join Add Answer
2
Technical Round (1 Question)
- Q1. Questions on Power B, DAX etc., Add Answer
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
- CityMall Team Lead Interview Questions
- CityMall Relationship Manager Interview Questions
- CityMall Area Manager Interview Questions
- CityMall Assistant Manager Interview Questions
- CityMall Business Analyst Interview Questions
- CityMall Category Manager Interview Questions
- CityMall Customer Experience Representative Interview Questions
- CityMall Customer Relation Officer 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 Manager Interview Questions
- Business Executive Interview Questions
- Show more
Business Analyst Interview Questions from Similar Companies
73%
more
than the average Business Analyst Salary in India
View more details
CityMall Business Analyst Reviews and Ratings
based on 12 reviews
Rating in categories
|
Team Lead
84
salaries
|  ₹2.8 L/yr - ₹5.8 L/yr |
|
Relationship Manager
60
salaries
| ₹2 L/yr - ₹5 L/yr |
|
Business Analyst
44
salaries
| ₹7.7 L/yr - ₹24 L/yr |
|
Program Manager
38
salaries
| ₹12 L/yr - ₹25 L/yr |
|
Key Account Manager
27
salaries
| ₹2.2 L/yr - ₹7 L/yr |
Explore more salaries
Compare CityMall with
Big Bazaar
Compare
Reliance Retail
Compare
DMart
Compare
Future Group
Compare
Calculate your in-hand salary
Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and
get your in-hand salary
Did you find this page helpful?
Yes No
- Home >
- Interviews >
- CityMall Interview Questions >
- CityMall Business Analyst Interview Questions
Share an Interview