Data Engineer Interview Questions at General
11 real Data Engineer interview questions asked at General. Covers Scenario rounds. Sourced from engineers who cleared the loop.
Interview Signals — What General Asks Data Engineers
All Data Engineer Questions Asked at General
A query that previously completed in 2 minutes now takes 20 minutes. Describe your systematic approach to troubleshooting and optimizing performance in Snowflake.
Design an end-to-end data pipeline using Python, PySpark, Snowflake, Airflow, and AWS S3. Explain data flow, orchestration, monitoring, and failure handling.
Snowpipe is ingesting duplicate records from cloud storage. How would you detect, prevent, and remediate duplicate data in Snowflake?
A production table was accidentally deleted 2 hours ago. How would you recover the data using Snowflake Time Travel?
Compare Streams and Tasks in Snowflake. How do they work together to support Change Data Capture (CDC) workflows?
Your team needs a test environment containing production data without duplicating storage costs. How would you use Zero Copy Cloning and what are its benefits and limitations?
Compare Temporary, Transient, and Permanent tables in Snowflake. When would each table type be appropriate?
Compare Snowpipe and COPY INTO. When would you choose one over the other?
A file lands in AWS S3 and must be ingested into Snowflake automatically in near real-time. How would you design the solution? Explain the role of Snowpipe, event notifications, and the ingestion workflow.
Compare Time Travel and Fail-safe in Snowflake. What are the key differences and use cases for each?
A critical table was dropped 10 days ago and the Time Travel retention period has expired. What recovery options are available? Explain how Fail-safe works and its limitations.
Practice these questions with AI feedback
Get instant grading on your answers, identify your weak areas, and generate a personalised 14-day study plan — all free.
Build my study plan →