General Interview Process 2026 — Rounds, Tips & Questions
168 real General interview questions reported by engineers, with difficulty and round context.
Real 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?
Your AWS Lambda function runs fine in testing but times out in production on the first invocation. Why?
How do you implement dark mode in a React app that persists across refreshes, respects OS preference, and allows manual override?
Design a system that detects fraudulent credit card transactions in real-time (decision in under 50ms). The system processes 10,000 transactions per second.
You have a users table with 100M rows. You need to add a full-text search on the bio column (free text). Show how to implement this in PostgreSQL.
Your Next.js app shows 'Loading...' forever on first visit but works fine on refresh. What's happening?
A production table was accidentally deleted 2 hours ago. How would you recover the data using Snowflake Time Travel?
You're building a WebSocket server in Node.js that needs to broadcast messages to 50,000 concurrent connections. A naive broadcast loops through all 50,000 and calls socket.send(). What's wrong with this and how do you fix it?
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 →