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

Reading isn't practice. Get AI feedback on your answers.

Other Companies

Expedia Data Engineer Interview Questions

Reading isn't practice. Get AI feedback on your answers.

Other Companies