Interview questions by company and role, before your interview.
Pick a company, role and experience. You get the rounds in order, the questions to practise for each, answer outlines and a day-by-day plan.
- Rounds in order
- Answer outlines
- 7 or 14-day plan
Or go straight to the question bank or the skill guides.
Interview plans for 101 companies
Question bank
Browse 32,000+ practice questions by role
PrepNPlaced's curated bank, sorted by role, company and topic. Every question has an answer outline; most also have follow-ups and common mistakes. They are practice questions in each company's style, not questions leaked from real interviews.
Filters: company, topic, difficulty
Showing 1–20 of 2,300 Data Engineer questions
Mixed across 25 companies
For a Google-like data project, tell me about a time you missed a deadline. What did you do?GoogleAccountabilityMediumPrepNPlaced curated
Design a Microsoft data system for Azure usage and reliability analytics with end-to-end latency of under 5 minutesMicrosoftData System DesignHardPrepNPlaced curated
For Amazon's privacy-sensitive data such as shipping address, tell me about a time you raised an ethics, privacy, or governance concernAmazonEthics and PrivacyHardPrepNPlaced curated
Walk me through a production incident in a data pipeline similar to Meta's engagements platformMetaIncident LeadershipHardPrepNPlaced curated
Design a Netflix data system for streaming quality and recommendation analytics with end-to-end latency of under 5 minutesNetflixData System DesignHardPrepNPlaced curated
Design warehouse monitoring for Uber's completed trips pipelineUberData WarehousingHardPrepNPlaced curated
What metadata should be captured for Airbnb's warehouse tables?AirbnbData WarehousingMediumPrepNPlaced curated
What should be logged for exposure in Stripe's checkout authentication change experiment?StripeExperimentationHardPrepNPlaced curated
For PayPal's payment_events, write SQL to identify anomalous days where successful payments drops more than 25% compared with the prior 7-day averagePayPalSQL Anomaly DetectionHardPrepNPlaced curated
What interference risks exist in Databricks's lakehouse data platform experiments, and how would you mitigate them?DatabricksExperimentationHardPrepNPlaced curated
How would you detect novelty or learning effects in a Snowflake experiment?SnowflakeExperimentationMediumPrepNPlaced curated
Design observability for Target's critical orders pipelines across freshness, quality, volume, and costTargetData ObservabilityMediumPrepNPlaced curated
The client's warehouse bill for Accenture's e-commerce client's clickstream ingestion doubled this quarter. Where do you look first?Accenturecost controlMediumPractice pattern
Rows in Deloitte's manufacturing client's sensor telemetry feed arrive more than once after a retry. Write the SQL that lands exactly one row per business key and say which one survives.Deloittededuplication on loadMediumPractice pattern
When would you broadcast the dimension in Capgemini's telecom client's call-detail-record pipeline, and when does that blow up?Capgeminibroadcast joinsMediumPractice pattern
The client wants a fully normalised warehouse for Cognizant's manufacturing client's sensor telemetry feed. Where do you agree, and where do you push back?Cognizantnormalisation trade-offsMediumPractice pattern
Pick the storage format and partition layout for TCS's banking client's nightly core-banking ingestion, and show what a bad partition key costs.TCSfile formats and partitioningMediumPractice pattern
The client wants a new feed on Infosys's media client's subscriber-events pipeline in three days and you believe it needs two weeks. What do you say?Infosyspushing back on scopeEasyPractice pattern
One Spark task in Wipro's travel client's booking and cancellation mart runs for an hour while the rest finish in a minute. Diagnose and fix it.Wiprodata skewHardPractice pattern
Model HCLTech's utilities client's smart-meter reading feed as a star schema. Which tables are facts, which are dimensions, and why not one wide table?HCLTechstar schema designMediumPractice pattern
Interview prep hub
Everything you need to prepare, in one place
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.
Interview questions by skill
Company interview guides
Process, focus areas, and prep tips for top employers.
Role interview guides
Skills, questions, and roadmaps for each career track.
Frequently asked questions
How do I prepare for a job interview?
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.
What questions are asked in technical interviews?
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.
How long does it take to prepare for an interview?
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.
Are these interview questions free?
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.