Upload Button Icon Add office photos

Swiggy

Compare button icon Compare button icon Compare

Filter interviews by

Swiggy Senior Business Analyst Interview Questions and Answers for Experienced

Updated 4 Dec 2024

Swiggy Senior Business Analyst Interview Experiences for Experienced

2 interviews found

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

(1 Question)

  • Q1. Questions on SQL joins, window functions etc.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Aug 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 tips
Round 2 - TechnicalΒ 

(5 Questions)

  • Q1. SQL Theory - joins, order of execution, window functions
  • Q2. Hands-on SQL - handling corner cases, solving practical problems
  • Q3. Python/Excel (if on resume). Important functions and packages e.g. (VLOOKUP, pandas, etc.)
  • Q4. Data visualization - basic understanding of storytelling with data, when to use what visualization
  • Q5. Schema design (if having experience) - what factors to consider, normalization, fact vs transaction tables
Round 3 - AnalyticalΒ 

(3 Questions)

  • Q1. Basic stats - central tendencies, distributions, skewness, outlier detection
  • Q2. Experiment design, hypothesis testing
  • Q3. Analytical case studies - how to solve problems and when to apply different approaches such as segmentation, clustering, forecasting, etc.
Round 4 - Case StudyΒ 

Open-ended case study to understand your approach and considerations. Use common sense, explain your thinking and be rigorous. Can come from any field but does not require field-intensive knowledge

Round 5 - BehavioralΒ 

(3 Questions)

  • Q1. Personality questions, motivations, company culture fit
  • Q2. Can re-touch on anything from previous round
  • Q3. In-depth exploration of any project or skill on resume

Interview Preparation Tips

Interview preparation tips for other job seekers - Make sure your SQL is up to par. Do plenty of practical problems and make sure your theory is brushed up. Later rounds are largely about common sense and analytical thinking which should be developed over time and with experience. Sample case studies will help but be sure to have solid foundations. Be sure to ask questions so you understand about the company and can also show what is important to you.

Senior Business Analyst Interview Questions Asked at Other Companies for Experienced

asked in Sapiens
Q1. Difference between annuity and pension, types of annuity and pens ... read more
asked in EVRY India
Q2. Five concepts in artificial intelligence, In machine learnin ... read more
Q3. Process of how a software is developed and pushed to production
asked in Capgemini
Q4. Explain about the credit card transaction end to end life cycle, ... read more
Q5. Explain a situation where you had to convince stakeholder to modi ... read more

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

  • Answered by AI
  • Q2. Questions based on Case Studies

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

I applied via LinkedIn and was interviewed before Jul 2021.Β 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 tips
Round 2 - One-on-oneΒ 

(1 Question)

  • Q1. Knowledge about data summarisation.and some tools like Power bi and advance excel.

Interview Preparation Tips

Interview preparation tips for other job seekers - Always speak first answer like perfect and effective answer without any hesitation...

I applied via Referral and was interviewed before Nov 2020.Β There was 1 interview round.

Interview QuestionnaireΒ 

1 Question

  • Q1. About personality

Interview Preparation Tips

Interview preparation tips for other job seekers - HR is very knowledgeable. The company want you to be very knowledgeable, smart and interesting.

I appeared for an interview in Nov 2020.

Interview QuestionnaireΒ 

1 Question

  • Q1. Mainly about sql, previous job role

I applied via Naukri.com and was interviewed in Sep 2020.Β There was 1 interview round.

Interview QuestionnaireΒ 

6 Questions

  • Q1. Tell me about your self
  • Ans. 

    I am a highly motivated and detail-oriented Business Analyst with a strong background in data analysis and problem-solving.

    • Experienced in conducting market research and competitor analysis

    • Proficient in using various data analysis tools such as Excel, SQL, and Tableau

    • Skilled in identifying business needs and translating them into functional requirements

    • Excellent communication and presentation skills

    • Ability to work colla...

  • Answered by AI
  • Q2. What do you want work here?
  • Ans. 

    I want to work here because of the company's reputation, growth opportunities, and alignment with my skills and interests.

    • I am impressed by the company's reputation in the industry.

    • I see great potential for growth and advancement within the company.

    • The company's values and mission align with my own.

    • I believe my skills and experience would be a valuable asset to the company.

    • I am excited about the opportunity to contribu...

  • Answered by AI
  • Q3. What makes you unique?
  • Ans. 

    I have a unique combination of technical skills and business acumen, allowing me to bridge the gap between IT and business stakeholders.

    • I have a strong background in both technology and business domains.

    • I can effectively communicate with both technical and non-technical stakeholders.

    • I have a track record of successfully translating business requirements into technical solutions.

    • I possess a deep understanding of various...

  • Answered by AI
  • Q4. What do you know about the company?
  • Ans. 

    The company is a leading technology firm specializing in software development and consulting services.

    • The company was founded in 2005 and has since grown to have a global presence.

    • They offer a wide range of services including business analysis, software development, and project management.

    • Some of their notable clients include Fortune 500 companies in various industries.

    • They have a strong focus on innovation and staying...

  • Answered by AI
  • Q5. What are your key professional strengths?
  • Ans. 

    My key professional strengths include analytical thinking, problem-solving, and effective communication.

    • Analytical thinking: I have a strong ability to analyze complex business problems and identify key insights.

    • Problem-solving: I am skilled at finding creative solutions to challenges and implementing them effectively.

    • Effective communication: I can communicate complex ideas and findings clearly and concisely to stakeho...

  • Answered by AI
  • Q6. What are your biggest weaknesses?
  • Ans. 

    My biggest weaknesses include perfectionism, overthinking, and public speaking anxiety.

    • Perfectionism: I tend to spend too much time on tasks to ensure they are flawless.

    • Overthinking: I sometimes overanalyze situations, which can lead to indecisiveness.

    • Public speaking anxiety: I get nervous when presenting in front of large audiences.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Tension free
Practice, practice, practice.
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

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

  • Answered by AI
  • 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

  • Answered by AI
  • 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...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be calm, It's very similar to any other business analyst interview in industry.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding TestΒ 

Advanced sql questions-3
joins-2
debugging-1

Round 2 - TechnicalΒ 

(2 Questions)

  • Q1. As i mentioned python, they asked me about hypothesis testing
  • Q2. Predictive modelling?

Interview Preparation Tips

Interview preparation tips for other job seekers - prepare your cv well

Swiggy Interview FAQs

How many rounds are there in Swiggy Senior Business Analyst interview for experienced candidates?
Swiggy interview process for experienced candidates usually has 3 rounds. The most common rounds in the Swiggy interview process for experienced candidates are Technical, Resume Shortlist and Case Study.
How to prepare for Swiggy Senior Business Analyst interview for experienced candidates?
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 Swiggy. The most common topics and skills that interviewers at Swiggy expect are QlikView, RDBMS, Python, Google Analytics and MySQL.
What are the top questions asked in Swiggy Senior Business Analyst interview for experienced candidates?

Some of the top questions asked at the Swiggy Senior Business Analyst interview for experienced candidates -

  1. Analytical case studies - how to solve problems and when to apply different app...read more
  2. Schema design (if having experience) - what factors to consider, normalization,...read more
  3. Data visualization - basic understanding of storytelling with data, when to use...read more

Tell us how to improve this page.

Swiggy Senior Business Analyst Interview Process for Experienced

based on 2 interviews

Interview experience

4
Β Β 
Good
View more

Senior Business Analyst Interview Questions from Similar Companies

View all
Swiggy Senior Business Analyst Salary
based on 109 salaries
β‚Ή13 L/yr - β‚Ή28.5 L/yr
48% more than the average Senior Business Analyst Salary in India
View more details

Swiggy Senior Business Analyst Reviews and Ratings

based on 13 reviews

3.7/5

Rating in categories

3.1

Skill development

3.2

Work-life balance

3.5

Salary

2.7

Job security

3.9

Company culture

3.0

Promotions

3.7

Work satisfaction

Explore 13 Reviews and Ratings
Delivery Boy
877 salaries
unlock blur

β‚Ή0.4 L/yr - β‚Ή5 L/yr

Sales Manager
581 salaries
unlock blur

β‚Ή2 L/yr - β‚Ή9.5 L/yr

Fleet Manager
572 salaries
unlock blur

β‚Ή2.5 L/yr - β‚Ή6 L/yr

Assistant Manager
490 salaries
unlock blur

β‚Ή2.6 L/yr - β‚Ή13 L/yr

Assistant Store Manager
443 salaries
unlock blur

β‚Ή1.7 L/yr - β‚Ή4.2 L/yr

Explore more salaries
Compare Swiggy with

Eternal Limited

3.7
Compare

Dunzo

3.4
Compare

FoodPanda

3.7
Compare

Rapido

3.8
Compare
Did you find this page helpful?
Yes No
write
Share an Interview