5 real Python interview questions asked at General. Upvoted by engineers who cleared the loop. Covers Scenario, Technical rounds.
General
Medium
Scenario round
5–8 YearsSnowflakeAWS S3Python
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.
↑ 67 upvotes · 48 engineers asked this · Data Engineer
General
Hard
Scenario round
5–8 YearsSnowflakeSQLPython
Snowpipe is ingesting duplicate records from cloud storage. How would you detect, prevent, and remediate duplicate data in Snowflake?
↑ 83 upvotes · 59 engineers asked this · Data Engineer
General
Hard
Scenario round
5–8 YearsSnowflakeSQLPython
A query that previously completed in 2 minutes now takes 20 minutes. Describe your systematic approach to troubleshooting and optimizing performance in Snowflake.
↑ 91 upvotes · 65 engineers asked this · Data Engineer
General
Hard
Scenario round
5–8 YearsSnowflakePySparkAirflow
Design an end-to-end data pipeline using Python, PySpark, Snowflake, Airflow, and AWS S3. Explain data flow, orchestration, monitoring, and failure handling.
↑ 87 upvotes · 62 engineers asked this · Data Engineer
General
Medium
Technical round
1-4 yearsPython
What is the difference between .loc[] and .iloc[] in pandas? Give an example where using the wrong one silently returns the wrong row.
↑ 22 upvotes · 13 engineers asked this · Data Scientist
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.
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.
Snowpipe is ingesting duplicate records from cloud storage. How would you detect, prevent, and remediate duplicate data in Snowflake?
Snowpipe is ingesting duplicate records from cloud storage. How would you detect, prevent, and remediate duplicate data in Snowflake?
A query that previously completed in 2 minutes now takes 20 minutes. Describe your systematic approach to troubleshooting and optimizing performance in Snowflake.
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.
Design an end-to-end data pipeline using Python, PySpark, Snowflake, Airflow, and AWS S3. Explain data flow, orchestration, monitoring, and failure handling.
What is the difference between .loc[] and .iloc[] in pandas? Give an example where using the wrong one silently returns the wrong row.
What is the difference between .loc[] and .iloc[] in pandas? Give an example where using the wrong one silently returns the wrong row.