Flipkart Health+ Business Analyst Interview Questions and Answers

Q1. SQL based questions were asked with some puzzles
Add your answer

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. Prepare on SQL in depth
Add your answer
Q2. Prepare on Excel & Python in depth
Add your answer

1. Tell me about yourself
2. Estimate the number of hospitals in India

1. There has been a decrease in 20% of the users in the past 3 days in online pharmacy application, what will you do now?

Q1. Salary negotiation on what were last salary and related questions
Add your answer
Q2. How soon can you join?
Add your answer
Q3. Are you holding any other offer, in case you do..they will try to match it which ideally depends on your interview.
Add your answer
Q4. Are you comfortable relocating to the office location?
Add your answer

8 sql questions
1 hard, 4 easy and 3 medium

Q1. Tell me about yourself. Your responsibilities in current role.
Ans. 
I am a Business Analyst with experience in data analysis, process improvement, and stakeholder management.
• Analyze data to identify trends and insights

• Improve business processes through automation and optimization

• Manage relationships with stakeholders to gather requirements and ensure project success
Answered by AI
Add your answer
Q2. SQL based basic questions. Output of left join and inner right join
Add your answer
Q3. Any notable project you’ve done which made any remarkable change in business
Ans. 
Implemented a data analytics project that optimized inventory management, resulting in a 20% reduction in costs.
• Analyzed historical sales data to forecast demand and optimize inventory levels

• Implemented a new inventory management system based on data-driven insights

• Collaborated with cross-functional teams to ensure successful implementation

• Monitored key performance indicators to track the impact of the project
Answered by AI
Add your answer
Q4. Difference between DDL and DML
Ans. 
DDL stands for Data Definition Language and is used to define the structure of database objects. DML stands for Data Manipulation Language and is used to manipulate data within the database.
• DDL is used to create, modify, and delete database objects like tables, indexes, etc.

• DML is used to insert, update, delete, and retrieve data from the database.

• Examples of DDL statements include CREATE TABLE, ALTER TABLE, DROP TABLE...read more
Answered by AI
Add your answer
Q5. How null behaves in different types of joins
Ans. 
Null behaves differently in different types of joins in SQL
• In INNER JOIN, rows with NULL values are excluded from the result set

• In LEFT JOIN, rows with NULL values from the left table are included in the result set

• In RIGHT JOIN, rows with NULL values from the right table are included in the result set

• In FULL OUTER JOIN, rows with NULL values from either table are included in the result set
Answered by AI
Add your answer

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