Expedia Group Data Analyst Intern Interview Questions and Answers

Q1. Explain data architecture of your project
Add your answer
Q2. Explain data lake
Add your answer

Duration - 3 hours, DSA

It was a mix of 1 coding question and MCQ's on topics like python, SQL, Git, Computer Networks, Linux etc.

Q1. This round was about SQL, Python the interviewer gave a problem and asked to write SQL query and they tested my SQL skills on basic concepts.
Add your answer
Q2. The interviewer asked to write python code for basic problems. This round was lasted about 40-45 mins
Add your answer

Q1. Again this round was focussed on my SQL skills the interviewer asked to write queries. SQL medium-hard level concepts. This lasted for 40-45 mins
Add your answer

Q1. This was final round the interviewer asked about everything I mentioned in my resume, behavioural questions, situational questions etc
Add your answer

Q1. SQL - Given 2 tables with some nullls and asked to output the count of rows we get for all types of joins
Add your answer
Q2. Types of joins and explain cross join
Ans. 
Types of joins in SQL include inner, outer, left, right, and cross join.
• Inner join: Returns rows when there is a match in both tables

• Outer join: Returns all rows when there is a match in one of the tables

• Left join: Returns all rows from the left table and the matched rows from the right table

• Right join: Returns all rows from the right table and the matched rows from the left table

• Cross join: Returns the Cartesian produ
Answered by AI
Add your answer

Q1. Projects and impact
Add your answer

Python SQL coding question and basic SQL understanding

Q1. White board Rround
Add your answer

Q1. Study DSA SQL PYTHON
Add your answer

Q1. Study spark sql data warehousing
Add your answer

Q1. Hr managerial round
Add your answer