Deliveroo Senior Data Analyst Interview Questions and Answers

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.
Add your answer
Q3. Calculated the rows based on joins and told the answer.
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
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. Guesstimates, SQL, MS-Excel related questions.
Add your answer

A case study, few HR questions.

SQL Assignment: Decent SQL questions were provided, Answers were provided with detailed approach. Time-in out sql problem, cohorts problem was there

Q1. Partition functions,creating dynamic buckets and sql puzzles were the highlights
Add your answer

Case study to understand the problem-solving aptitude was asked. Focus was more on the approach rather than the final outcome

Sql and python,numpy,pandas

Q1. Analyst skills,data handlling
Add your answer

Q1. DBMS? Questions from Graduation Project
Add your answer

Q1. SQL RDBMS Situational based questions
Add your answer

Q1. SQL, Case study, and puzzles.
Add your answer

Q1. Joins, operations questions not data analysis questions
Add your answer
Q2. Customer retention case study
Add your answer
Q3. Cumulative sum for given table
Ans. 
To calculate cumulative sum for a given table
• Sort the table in ascending order based on the column you want to calculate the cumulative sum for

• Add a new column to the table to store the cumulative sum

• Iterate through each row of the table and calculate the cumulative sum by adding the current row's value to the previous row's cumulative sum

• Store the cumulative sum in the new column for each row
Answered by AI
Add your answer
Q4. Do you have experience in operations/data entry role
Ans. 
Yes, I have experience in both operations and data entry roles.
• I have worked as a data entry operator for a pharmaceutical company where I was responsible for entering patient data into the system.

• In my previous role as an operations analyst, I was responsible for analyzing data and creating reports for the management team.

• I have experience using various data entry software such as Microsoft Excel and Google Sheets.

• I a...read more
Answered by AI
Add your answer
Q5. As a data analyst can you do data entry work also?
Ans. 
Yes, I can do data entry work as a data analyst.
• Data entry work is a part of data analysis process.

• I have experience in data entry work and can perform it efficiently.

• Data entry work includes entering data into spreadsheets, databases, or other software.

• I understand the importance of accurate data entry for effective analysis.
Answered by AI
Add your answer
Q6. Normal excel statements like if, vlookup, xlookups etc.,
Add your answer