GCP Data Engineer

GCP Data Engineer Interview Questions

180+ curated questions across BigQuery, Dataflow, Pub/Sub, Composer, IAM, SQL modeling and Power BI. Every answer ships with the interviewer's rationale — what they actually want to hear, and the follow-up they'll drop if you nail the first pass.

Topics covered

• BigQuery architecture & pricing
• Partitioning & clustering
• SQL modeling & warehousing
• Dataflow (Apache Beam)
• Pub/Sub messaging patterns
• Cloud Composer / Airflow
• IAM & least-privilege design
• Cost optimization playbooks
• ETL vs ELT design
• Streaming ingestion
• Power BI reporting
• Data governance & lineage

How the question bank is organized

Filter by difficulty (Beginner, Intermediate, Advanced, Professional) and by topic. Mark questions as "Done" and they move to a Covered section — the bank never re-asks you the same one until you reset it. Progress is synced to your account, so you can leave and come back on any device.

Every SQL / MySQL question is a full coding problem with an executable model answer and an explanation of every function used (window functions, CTEs, JSON operators, EXPLAIN plan reads).