Swiggy Senior Data Analyst Interview Questions and Answers

Coding test like I interst

Q1. Tell me about yourself.
Add your answer

The test was based on SQL and the questions were similar to medium difficulty level questions in leetcode.

Q1. Describe different types of joins
Ans. 
Different types of joins are used in database queries to combine data from multiple tables.
• Inner join: Returns only the matching records from both tables.

• Left join: Returns all records from the left table and the matching records from the right table.

• Right join: Returns all records from the right table and the matching records from the left table.

• Full outer join: Returns all records when there is a match in either the ...read more
Answered by AI
View 4 more answers
Q2. 2 tables were given and I was asked to tell the number of rows in output based on different types of joins.
Ans. 
Understanding join types helps determine the number of rows in SQL queries based on table relationships.
• INNER JOIN: Returns rows with matching values in both tables. Example: 5 rows if both tables have 5 matching records.

• LEFT JOIN: Returns all rows from the left table and matched rows from the right. Example: 7 rows if left has 7 and right has 3 matches.

• RIGHT JOIN: Returns all rows from the right table and matched rows...read more
Answered by AI
Add your answer
Q3. Calculated the rows based on joins and told the answer.
Ans. 
Understanding row calculations in SQL joins is crucial for accurate data analysis.
• Inner Join: Returns rows with matching values in both tables. Example: Customers and Orders where customer_id matches.

• Left Join: Returns all rows from the left table and matched rows from the right. Example: All Customers and their Orders, if any.

• Right Join: Returns all rows from the right table and matched rows from the left. Example: Al...read more
Answered by AI
Add your answer

Q1. Describe your previous experience
Ans. 
I have 3 years of experience as a Business Analyst in the IT industry.
• Worked on gathering and analyzing business requirements

• Created functional specifications and user stories

• Conducted stakeholder interviews and facilitated meetings

• Performed data analysis and created reports

• Collaborated with cross-functional teams to implement solutions

• Utilized tools like JIRA and Confluence for project management

• Improved business proc...read more
Answered by AI
Add your answer
Q2. Shared the details regarding my experience
Add your answer
Q3. A SQL based puzzle based on window functions where I had to find 4 consecutive empty seats in a theater.
Add your answer
Q4. Solved using lag function.
Add your answer

The interviewer asked about my previous experience along with a few situation based questions and then gave me a case study to find out possible reasons for a decrease in the cancellations between order dispatch and order delivery.

Q1. SQL joins intermediate level
Add your answer
Q2. SQL inner joins intermediate level
Add your answer

Advanced sql questions-3
joins-2
debugging-1

Q1. As i mentioned python, they asked me about hypothesis testing
Ans. 
Hypothesis testing is a statistical method to determine if there's enough evidence to support a specific claim about a population.
• Null Hypothesis (H0): Assumes no effect or no difference (e.g., a new drug has no effect compared to a placebo).

• Alternative Hypothesis (H1): Indicates the presence of an effect or difference (e.g., the new drug is more effective than the placebo).

• Significance Level (α): The probability of re...read more
Answered by AI
Add your answer
Q2. Predictive modelling?
Add your answer

Q1. Mcqs around core cs subjects
Add your answer
Q2. 3 sql coding question
Add your answer

Q1. Discussion around project
Add your answer
Q2. 5 sql code questions
Add your answer

Q1. Again 1 SQL coding question, 1 case study
Add your answer
Q2. Normal behavioral questions
Add your answer