314,552 interview questions from 6,000+ companies.
Tests prioritization under pressure across multiple projects, including trade-off judgment, stakeholder communication, and ownership of outcomes.
Tests influence without authority: aligning stakeholders through data, empathy, and ownership to drive a decision and measurable outcome.
Tests ownership under ambiguity: how you prioritize, align stakeholders, and recover a project when the path forward is unclear.
Tests conflict resolution between senior engineers, plus influence, communication, and ownership in driving a durable technical decision.
Preferred tools and approach for monitoring and managing data pipelines in production.
Evaluate when a pipeline should use stream processing versus scheduled batch based on latency, cost, complexity, and data quality needs.
Describe a practical approach to data governance across shared data pipelines, including quality, ownership, lineage, and controlled data access.
Tests communication of technical trade-offs to non-technical stakeholders, with emphasis on influence, clarity, and business-oriented decision-making.
Design a pipeline for a real-time operational dashboard, covering streaming ingestion, modeling, data quality, and dashboard serving.
Approach for building privacy controls, lineage, and auditability into data pipelines that handle personal data.
Compare star and snowflake schemas in a warehouse pipeline, including structure and transformation trade-offs.
Tests communication and influence: translating a complex data concept into business value, aligning stakeholders, and driving a decision under ambiguity.
Use CTEs, joins, and date filtering to calculate 30-day retention by signup cohort from login and feature usage data.
Use ROW_NUMBER() to keep the earliest created_at 'Repl created' per entity and return out-of-order duplicates to delete.
Design a Fivetran+dbt ELT platform in Snowflake with incremental models, late-arriving updates, and strong data quality/observability.
Design a streaming+batch pipeline and warehouse model to track AI Agent usage, credit consumption, and error rates with late events and retries.
Choose between Fivetran and a custom Python connector to ingest Stripe + Salesforce into Snowflake with SLAs, late data handling, and auditability.
Design an auditable, backfillable schema and ELT pipeline to support point-in-time historical reporting for a fast-changing product feature.
Design a pipeline that joins Stripe invoices/charges with clickstream events into Snowflake with <10 min freshness, handling late events and refunds.
