AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Expedia Group
Compare
Filter interviews by
Expedia Group Data Analyst Intern Interview Questions and Answers
Expedia Group Data Analyst Intern Interview Experiences
1 interview found
Anonymous
I applied via Campus Placement and was interviewed in Dec 2023. There were 2 interview rounds.
The first round was a 45 min long aptitude and case study round which involved basic aptitude questions along with certain cases like "There has been a drop off in customers booking a hotel though the the total number of visits to the site has not dropped. How would you you design a system to analyze the problem and what kind of data will you collect." It was followed by a couple of HR questions
A mock data set of hotel bookings in different countries for last two years were given a week prior to the interview. We were to clean, prepare, derive insights and recommend actions. All of this needed to be documented as 15 page presentation. This presentation then needed to be presented in a 45 min meet.
Interview Preparation Tips
Top trending discussions
Interview questions from similar companies
I applied via Campus Placement and was interviewed before May 2020. There was 1 interview round.
Interview Questionnaire
4 Questions
- Q1. 1. Programming Logic for loops and majorly In python
- Ans.
Python has for and while loops. For loop iterates over a sequence and while loop executes a block of code while a condition is true.
For loop syntax: for variable in sequence: block of code
While loop syntax: while condition: block of code
Example: for i in range(5): print(i) will print 0 to 4
Example: while x < 5: print(x); x += 1 will print 0 to 4
- Q2. Data warehouse concept
- Q3. Cloud Concepts Aws
- Q4. SQL writing SQL query important
Interview Preparation Tips
Skills evaluated in this interview
I applied via Approached by Company and was interviewed before Jun 2021. There were 5 interview rounds.
About your tech stack along with 2 Programming question basic DS Problems, and 2-3 SQL Queries moderate level.
3-4 SQL queries medium to high level and 2 programming question moderate level
Data modeling and Data warehousing questions along with SQL queries Hard level
(2 Questions)
- Q1. Create a Data model for the use case like CCD, Pizza hut and questions from that Data model
- Q2. Data Warehousing and Big data related problems Data pipelines and ETL related Question Cloud computing related questions
(1 Question)
- Q1. Techno manager round on case studies to come complex problems.
Interview Preparation Tips
Interview Preparation Tips
Experience: Relevant experience matters, a lot!
Round: HR Interview
Experience: Nothing specific. Just resume based.
Round: Technical Interview
Experience: 7 rounds. Across SQL, Python, Shell Script (bash), platform architectures and Amazon web services (AWS).
Tips: Prepare well - SQL and data architectures for various use cases.
Round: Behavioural Interview
Experience: On Amazons leadersh
I appeared for an interview in Nov 2020.
Interview Questionnaire
1 Question
- Q1. Design booking.com.
Interview Preparation Tips
Selected
I applied via Approached by Company and was interviewed in Aug 2024. There were 5 interview rounds.
I was hiring drive. First round was coding test with medium to advanced SQL, data modelling and python questions
(3 Questions)
- Q1. Data model e commerce application
- Q2. Higest nth rank and lowest rank if no of employees less than 2
- Ans.
If number of employees is less than 2, highest and lowest rank will be the same.
If there are less than 2 employees, both highest and lowest rank will be the same.
For example, if there is only 1 employee, their rank will be 1 which is both the highest and lowest rank.
- Q3. Event session data modeling
(1 Question)
- Q1. Sql-self join, non equi join, window funtion, consecutive seats, data modeling, stock market maximum profit sql question
(1 Question)
- Q1. This was hiring manager round. Detailed discussions on project and previous experience
(1 Question)
- Q1. Strength, weakness and why myntra
Interview Preparation Tips
I applied via Approached by Company and was interviewed before Aug 2023. There were 2 interview rounds.
Python SQL coding question and basic SQL understanding
(1 Question)
- Q1. White board Rround
Oops dsa sql network
(2 Questions)
- Q1. Dsa based python question
- Q2. Dsa based python question on tress
(2 Questions)
- Q1. Sql question queries
- Q2. Sql question query
Selected
I applied via Job Portal and was interviewed in Apr 2023. There were 4 interview rounds.
(1 Question)
- Q1. Study DSA SQL PYTHON
(1 Question)
- Q1. Study spark sql data warehousing
(1 Question)
- Q1. Hr managerial round
Selected
I applied via Referral and was interviewed in Mar 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Work experince , resume walk thorugh
- Q2. Location preferences,salary etc.
(2 Questions)
- Q1. SQL,python coding round
- Q2. Data warehousing concepts
Expedia Group Interview FAQs
Tell us how to improve this page.
Expedia Group Interviews By Designations
- Expedia Group Software Developer Intern Interview Questions
- Expedia Group Software Developer Interview Questions
- Expedia Group Senior Software Engineer Interview Questions
- Expedia Group Software Development Engineer II Interview Questions
- Expedia Group Software Engineer Interview Questions
- Expedia Group Data Engineer Interview Questions
- Expedia Group Software Engineer III Interview Questions
- Expedia Group Product Manager Interview Questions
- Show more
Interview Questions for Popular Designations
- Data Scientist Interview Questions
- Data Science Intern Interview Questions
- Senior Data Analyst Interview Questions
- Senior Data Scientist Interview Questions
- Data Scientist Intern Interview Questions
- Jr. Data Scientist Interview Questions
- Associate Data Scientist Interview Questions
- Data Science Engineer Interview Questions
- Show more
Expedia Group Data Analyst Intern Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
|
Software Development Engineer II
206
salaries
|  ₹15.6 L/yr - ₹40 L/yr |
|
Software Development Engineer
95
salaries
| ₹12 L/yr - ₹36 L/yr |
|
Software Development Engineer 3
77
salaries
| ₹27 L/yr - ₹58 L/yr |
|
Software Engineer
60
salaries
| ₹12 L/yr - ₹36 L/yr |
|
Software Developer
51
salaries
| ₹10 L/yr - ₹35 L/yr |
Amazon
Flipkart
Udaan
BigBasket
- Home >
- Interviews >
- Expedia Group Interview Questions >
- Expedia Group Data Analyst Intern Interview Questions
