Question 1

Tell me about a time when you faced a tight deadline in a project, and how did you manage it?

Accepted Answer

Situation: Data mart for product launch in 3 weeks. Task: Deliver on time. Action: Phased: core tables week 1, aggregations week 2, testing/docs week 3. Negotiated scope—dropped nice-to-have dimensions. Used existing patterns. Daily stakeholder updates....

Question 2

Write a SQL query to calculate the running total of sales per region, partitioned by year.

Accepted Answer

SELECT region, year, month, SUM(sales) OVER (PARTITION BY region, year ORDER BY month ROWS UNBOUNDED PRECEDING) AS running_total FROM sales ORDER BY region, year, month. **Why**: Cumulative sum = SUM with ORDER BY and default frame. ROWS UNBOUNDED PRECEDING explicit....

Question 3

How do you prioritize your tasks in a multi-project environment?

Accepted Answer

**Situation**: Faced competing demands—multiple pipelines, stakeholders, deadlines. **Task**: Deliver impact while maintaining quality and preventing burnout. **Action**: (1) Prioritized by business impact and SLA risk. (2) Used ROI (value/time); WIP limits; timeboxing. (3) Communicated trade-offs—'Adding X pushes Y by N days.' (4) Maintained backlog with tech-debt capacity. **Result**: Shipped on time; zero incidents; stakeholder alignment on deferrals....

PLEO Data Engineer Interview Questions

Other Companies