Big C Business Analyst Interview Questions and Answers

Q1. Work experience and basic introduction questions.
Add your answer

Q1. Business analyst related questions.
Add your answer

Q1. HR round about basic introduction.
Add your answer

Written test, asked to write queries on paper for given 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
Add your answer
Q2. Queries on self join
Add your answer

Q1. Questions on Power B, DAX etc.,
Add your answer

Q1. Where do you see yourself in 5 years
Add your answer

Q1. How you will improve health of a marketplace
Ans. 
By analyzing data, identifying pain points, and implementing solutions to improve user experience and trust.
• Analyze user behavior and feedback to identify areas of improvement

• Implement measures to increase transparency and trust, such as user reviews and seller verification

• Provide resources and support for dispute resolution

• Encourage diversity and inclusivity in the marketplace to attract a wider range of buyers and se...read more
Answered by AI
Add your answer

Q1. How you will design new customer support system
Ans. 
I will design a customer support system that is user-friendly, efficient, and personalized.
• Conduct research to understand customer needs and preferences

• Identify common customer issues and develop a knowledge base for quick resolution

• Implement a ticketing system to track and prioritize customer inquiries

• Integrate chatbots and AI to provide 24/7 support

• Train support staff to provide personalized and empathetic service

• Col...read more
Answered by AI
Add your answer

45 minutes coding test

Q1. 2 nd round was technical.
Add your answer

Q1. Third round was technical
Add your answer

SQL queries based on e-commerce platform. Warehouse and data modelling related questions.

How to improve delivery system and logistics in e-commerce platform?

Q1. What do I do in my existing job?
Add your answer
Q2. Why do you want to leave your existing job?
Add your answer

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