Every real interview question we've collected across companies, roles, topics, and difficulty. Browse the whole bank, or filter by role, company, and topic. Currently 2k questions for Data Engineer.
Want company-specific interview rounds & questions? Generate your tailored plan at the top ↑
Showing 1–20 of 2.3k
For a 7-Eleven-like data project, tell me about a time you missed a deadline. What did you do?
Give an example of ambiguous requirements for a data product similar to 7-Eleven's dashboards and downstream ML features. How did you clarify them?
At 7-Eleven, data decisions often involve trade-offs. Tell me about a conflict with another engineer over retail analytics warehouse or Azure Data Factory, Spark, SQL warehouse, and dashboarding
Design cost controls for 7-Eleven's retail analytics warehouse where query and pipeline spend is growing faster than usage
Design an event contract and schema registry process for 7-Eleven's POS and loyalty event stream producers and data consumers
Design observability for 7-Eleven's critical store sales pipelines across freshness, quality, volume, and cost
Define data quality checks for 7-Eleven's receipt_id, store_id, sku, member_id, amount, event_time pipeline before publishing to analysts
Design a 7-Eleven data system for near-real-time store sales and inventory analytics with end-to-end latency of under 5 minutes
Design a star schema for 7-Eleven's convenience retail and loyalty platform that supports reporting on same-store sales, basket revenue, and app offer view -> store visit -> purchase -> loyalty redemption
Design a daily ETL pipeline for 7-Eleven that ingests POS and loyalty event stream into retail analytics warehouse for same-store sales reporting
A 7-Eleven ETL job failed halfway after writing partial data. Walk through the recovery design
How would you make 7-Eleven's Airflow DAG for store sales processing idempotent and safe to backfill?
Design reconciliation logic for 7-Eleven's ETL so basket revenue in retail analytics warehouse matches the operational source
For 7-Eleven, decide between ETL and ELT for transforming POS, loyalty, inventory, promotion, and delivery events. What factors drive your choice?
For 7-Eleven's privacy-sensitive data such as loyalty phone number, tell me about a time you raised an ethics, privacy, or governance concern
How would you explain a complex 7-Eleven data architecture decision to a non-technical executive?
How would you model 7-Eleven's loyalty coupon experiment results so analysts can compare treatment and control without metric leakage?
For 7-Eleven, would you model POS, loyalty, inventory, promotion, and delivery events as an event fact table, an accumulating snapshot, or a periodic snapshot? Defend the choice
Design a data platform feature store or serving layer for 7-Eleven's dashboards and downstream ML features using POS, loyalty, inventory, promotion, and delivery events
Design access control for 7-Eleven's analytics platform where loyalty phone number must be protected but aggregated analysis is allowed
Interview prep hub
PrepNPlaced turns your target company and role into a concrete plan: the rounds you'll face, the skills they test, and real questions with answers to practise. Start with your skills, your target company, or your role below — then rehearse live in a mock interview.
Process, focus areas, and prep tips for top employers.
Skills, questions, and roadmaps for each career track.
Start from the company and role: know the rounds you'll face, practise the skills those rounds test (with real questions and answers), rehearse out loud in a mock interview, and fix your weakest gaps. PrepNPlaced builds this plan for you from your resume and target company.
It depends on the role, but common areas are SQL, Python, PySpark, statistics, and BI tools like Power BI, Tableau, and Excel, plus role-specific system design or case rounds and behavioral questions. The guides below cover each with answers.
With a focused plan, two to four weeks is usually enough to cover the core topics for a role. Consistency beats cramming — practise a little each day and rehearse speaking your answers, not just reading them.
Yes. The interview-question guides and the company-style prep plan are free to use. You can also practise unlimited mock interviews on a paid plan.