GitHub 上一份精心收集的数据工程师面试题库：data-engineering-interview-questions ，收录了超过 2000 道题。

覆盖数据库与数据仓库、大数据处理框架、云平台服务、数据格式、数据可视化等核心方向，可以按主题逐个击破，也能用完整题单做全面模拟。

GitHub：http://github.com/OBenner/data-engineering-interview-questions…

数据库部分涵盖 Cassandra、MongoDB、HBase、Hive 以及 Redshift、BigQuery 等主流选型。

理论部分也没落下，数据建模、数据质量、系统设计、SQL 和 Python 都有专门的题目集。

每个主题还附带了官方文档和 Awesome 资源列表的链接，方便深入学习。

如果你正在准备数据工程相关的面试，这份题库值得收藏，系统刷一遍心里会踏实很多。

OBenner/data-engineering-interview-questions

Source: https://github.com/OBenner/data-engineering-interview-questions

More than 2000+ questions for preparing a Data Engineer interview.

Full list of questions

Pick a topic below or use the full list to practice end-to-end.

Interview questions for Data Engineer

Databases and Data Warehouses
GitHub Repo	Official page	Questions	Description	Useful links
		Apache Cassandra	Cassandra is a distributed, wide-column store, NoSQL database management system.	Awesome Cassandra
		Greenplum	Greenplum is a big data technology based on MPP architecture and the Postgres open source database technology.	Awesome Greenplum
		MongoDB	MongoDB is a document-oriented database.	Awesome MongoDB
		Apache Hbase	HBase is an open-source non-relational distributed database.	Awesome HBase
		Apache Hive	Apache Hive is a data warehouse software project built on top of Apache Hadoop for providing data query and analysis.	Awesome Hive
		Amazon DynamoDB	Amazon DynamoDB is a fully managed proprietary NoSQL database service.	Awesome DynamoDB Awesome AWS
		Amazon Redshift	Amazon Redshift is a data warehouse product.	Amazon Redshift Utilities Awesome AWS
		BigQuery GCP	BigQuery is a fully-managed, serverless data warehouse.	Awesome BigQuery
		Bigtable GCP	Bigtable is a fully managed wide-column and key-value NoSQL database service.	Awesome Bigtable
Data Formats
		Apache Avro	Avro is a row-oriented remote procedure call and data serialization framework.	Awesome Avro
		Apache Parquet	Apache Parquet is a column-oriented data file format designed for efficient data storage and retrieval.	Parquet format · Docs
		Delta	Delta Lake is a storage framework that enables building a Lakehouse architecture with compute engines	Delta examples
		Apache Iceberg	Apache Iceberg is an open table format for huge analytic datasets.	Iceberg docs
		Apache Hudi	Apache Hudi brings upserts, deletes, and incremental processing to data lakes.	Hudi docs
Big Data Frameworks
		Apache Airflow	Apache Airflow is a workflow management platform for data engineering pipelines.	Awesome Airflow
		Apache Flume	Apache Flume is a distributed, reliable, and available software for efficiently collecting, aggregating, and moving large amounts of log data.	Flume User Guide
		Apache Hadoop	Apache Hadoop is a collection of software utilities that facilitates using a network of many computers to solve problems involving massive amounts of data and computation.	Awesome Hadoop
		Apache Impala	Apache Impala is a parallel processing SQL query engine for data stored in a computer cluster running Apache Hadoop.	Impala docs
		Apache Kafka	Apache Kafka is a distributed event store and stream-processing platform.	Awesome Kafka
		Apache NiFi	Apache NiFi is a software project designed to automate the flow of data between software systems.	Awesome NiFi
		Apache Spark	Apache Spark is unified analytics engine for large-scale data processing.	Awesome Spark
		Apache Flink	Apache Flink is unified stream-processing and batch-processing framework.	Awesome Flink
		Kubernetes	Kubernetes is a system for managing containerized applications across multiple hosts.	Awesome Kubernetes
Cloud providers
		Amazon Web Services	Amazon web service is an online platform that provides scalable and cost-effective cloud computing solutions.	Awesome AWS
		Microsoft Azure	Microsoft Azure is Microsoft's public cloud computing platform.	Awesome Azure
		Google Cloud Platform	Google Cloud Platform is a suite of cloud computing services.	Awesome GCP
Modern Data Stack
		dbt	dbt is a transformation framework for building tested and documented SQL models.	dbt tests
Theory
		DWH Architectures	A data warehouse architecture is a method of defining the overall architecture of data communication processing and presentation that exist for end-clients computing within the enterprise.	Awesome databases
		Change Data Capture (CDC)	CDC captures inserts/updates/deletes from source systems for low-latency ingestion.	Debezium docs
		Data Modeling	Dimensional modeling concepts used to build reliable analytics datasets.	Kimball Group
		Data Quality	Tests, monitoring, and practices to ensure datasets are trusted and correct.	Great Expectations docs
		Data Observability	Monitoring and incident response practices for pipeline and dataset health.	OpenLineage
		Data Governance	Ownership, policies, privacy, and access controls for data platforms.	DataHub
		Cost Optimization	Practical techniques to reduce compute and storage costs while meeting SLAs.	Spark tuning
		Python for Data Engineering	Python fundamentals for reliable, scalable data pipelines and tooling.	PyArrow docs
		Data System Design	System design interview questions for batch/streaming data platforms.	Data mesh overview
		Data Structures	A data structure is a specialized format for organizing, processing, retrieving and storing data.	Awesome Algorithms
		SQL	SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS).	Awesome SQL
Data visualization tools/BI
		Tableau	Tableau is a powerful data visualization tool used in the Business Intelligence.	Tableau Desktop docs
		Looker	Looker is an enterprise platform for BI, data applications, and embedded analytics that helps you explore and share insights in real time.	Looker docs
			Apache Superset	Superset is a modern data exploration and data visualization platform	Superset docs