Question 1

How do you handle disagreements within a team?

Accepted Answer

Situation: Disagreements often stem from misaligned success criteria or incomplete information. Task: Turn subjective debate into objective decision-making. Action: I restate each position and surface underlying goals. I propose measurable criteria (latency, cost, maintainability) and gather evidence—benchmarks, POCs, incident data. For technical choices, I suggest a time-boxed spike or A/B pilot....

Question 2

Explain the trade-offs between batch and real-time data processing. Provide examples of when each is appropriate.

Accepted Answer

**Why the distinction matters**: Systems are optimized for different access patterns. Batch assumes bounded, complete datasets; streaming assumes unbounded, infinite data. The choice cascades into storage layout, compute model, operational complexity, and cost structure. **Batch**: Designed for high-throughput, bounded processing. Lower cost per record due to amortized compute (e.g., spot instances). Easier to reason about correctness (all-or-nothing). Trade-off: End-to-end latency is O(hours)....

Question 3

How do you manage tight project delivery timelines in a team environment?

Accepted Answer

Situation: We had 6 weeks to deliver a new data mart for a product launch; initial estimate was 10 weeks. Task: Deliver without burning out the team or cutting corners on quality. Action: I ran a scope negotiation: defined mandatory vs. nice-to-have with the PM. We dropped 2 non-critical dimensions. I broke work into 2-week milestones with clear ownership. I used burndown charts and flagged slippage in daily standups. I protected focus time—reduced meetings by 40%....

Question 4

How do you work under tight deadlines and high pressure?

Accepted Answer

Situation: Revenue pipeline failed 4 hours before a board presentation. Task: Restore data under pressure. Action: I followed the runbook; triaged root cause (schema change). I implemented fix, delegated comms, ran backfill. We restored in 2.5 hours. Post-incident we implemented schema validation....

Question 5

Why did you leave your last company in just 4 months?

Accepted Answer

Situation: Short tenure. Task: Honest, brief. Action: Role mismatch, direction change, opportunity, personal. Not easy decision. Grateful; left on good terms. Focused on long-term fit; this role aligns. Address flight risk directly....

Question 6

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 7

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 8

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....

Expedia Data Engineer Interview Questions

+11 More Questions with Expert Answers

Other Companies

Expedia Data Engineer Interview Questions

+11 More Questions with Expert Answers

Other Companies