Q: Share good and bad experiences with past employers.

Balanced, professional. Good: Collaboration, learning, impactful projects. Bad: Frame as learning—'Challenges with X taught me Y; I've applied those lessons.' Never badmouth. If pushed: 'Constraints around scope/resources led me to seek new opportunities.' Focus on growth.

Q: What are your expectations from the next job role?

Similar to 672/673. 'Role with [impact/scale/ownership]. Work on [problems] with [team/culture]. Deliver [X], grow in [Y]. [Company]'s [specific] aligns with my interests.' Mutual fit.

Question 1

Calculate the average session duration per user for the Expedia website.

Accepted Answer

**SQL**: SELECT user_id, AVG(duration) AS avg_session_duration FROM (SELECT user_id, session_id, MAX(ts) - MIN(ts) AS duration FROM events GROUP BY user_id, session_id) t GROUP BY user_id. **Logic**: Inner query computes per-session duration; outer averages per user....

Question 2

Given exchange rates for USD to INR with timestamps: Find the ticket price in rupees for various dates. Use the latest exchange rate based on the timestamp for each date.

Accepted Answer

**Approach**: Time-based join—for each ticket_date, get max rate_timestamp <= ticket_date. CROSS APPLY / LATERAL with ORDER BY rate_timestamp DESC LIMIT 1. Spark: asof join (merge_asof in Pandas); or join with condition + window for latest....

Question 3

How do you manage failed ideas?

Accepted Answer

**Situation**: Ideas fail; how you respond reflects maturity.

**Action**: (1) Postmortem—learn, no blame; (2) Salvage—partial value? Reuse? (3) Share—document; (4) Pivot—adjust from feedback; (5) Move on. Define success upfront; treat as experiment....

Question 4

Share experiences of quickly adapting to new technologies and tools in evolving project requirements.

Accepted Answer

STAR: SITUATION—Project shifted batch→streaming. TASK—Learn Kafka/Flink, deliver PoC. ACTION—Two weeks: courses, local experiments, pair with expert; delivered PoC that went production. Another: Led dbt migration; templates, trained team. RESULT—PoC in production; dbt adopted org-wide....

Question 5

Share good and bad experiences with past employers.

Accepted Answer

Balanced, professional. Good: Collaboration, learning, impactful projects. Bad: Frame as learning—'Challenges with X taught me Y; I've applied those lessons.' Never badmouth. If pushed: 'Constraints around scope/resources led me to seek new opportunities.' Focus on growth.

Question 6

What are your expectations from the next job role?

Accepted Answer

Similar to 672/673. 'Role with [impact/scale/ownership]. Work on [problems] with [team/culture]. Deliver [X], grow in [Y]. [Company]'s [specific] aligns with my interests.' Mutual fit.

Expedia General Interview Questions

Companies asking these questions

All 6 Questions

More Interview Prep Guides

Get All Answers in PDF Format

Expedia General Interview Questions

Companies asking these questions

All 6 Questions

More Interview Prep Guides

Get All Answers in PDF Format