This video goes over what to expect in data engineering interview rounds, how to prepare for it.
SQL
* Joins
* Self Join
* Window Functions
Coding
* String
* Dict
* Array
* Parse CSV/some file
System Design
* Design a data pipeline for a business usecase
Data Modelling
* Dimensional Modelling
* OBT
Behavorial Round
* Follow STAR
Important Concepts
* Spark
* Optimization
* Configuration
* Redshift or Snowflake or Databricks
* Knowledge of some cloud services
* Orchestration service like Airflow
2 Comments