Swiggy Senior Business Analyst Interview Questions and Answers

Hacker rank test with SQL questions

Design the database and write a query to find the most re-ordered product

Case study and technical round - database design questions and analytical thinking check

HR Related questions and market entry level case study

On their new product launch was given 2-4 days for completion

Q1. Based on case study
Add your answer
Q2. SQL related question , how will you perform analysis, check if data is accurate
Add your answer

Q1. Going through your resume, past projects and metrics around that project.
Add your answer
Q2. 2 SQL questions. 1. based on logic 2nd highest salary. 2. Basic Question on window functions and self join
Add your answer

Q1. RCA on why the conversion is down on the app.
Add your answer
Q2. SQL question of high difficulty (don't remember the question as that was his self made question) Logic used: self join with date
Add your answer

Q1. Normal verification
Add your answer

Q1. Questions related to sql
Add your answer
Q2. Windows function in sql
Ans. 
The Windows function in SQL is used to perform calculations on a specific subset of rows in a result set.
• The Windows function is used with the OVER clause to define the subset of rows to perform calculations on.

• Common Windows functions include ROW_NUMBER, RANK, DENSE_RANK, and NTILE.

• Example: SELECT ROW_NUMBER() OVER (PARTITION BY department ORDER BY salary DESC) AS row_num FROM employees;
Answered by AI
Add your answer

Q1. Interview with stakeholders
Add your answer

Q1. Windows Function
Add your answer
Q2. Joins (Self, Left, Right, Outer)
Add your answer