I had two rounds of technical discussion
SQL (advanced)
Joins, window functions, query optimization
Python / Scala
Data manipulation, coding problems
ETL/ELT Concepts
Data pipelines, transformations
Data Warehousing
Star schema, snowflake, SCD (Slowly Changing Dimensions)
Apache Spark / Hadoop
RDD vs DataFrame, partitioning, performance tuning
Streaming (Kafka / Spark Streaming / Flink)
System Design
Data pipelines at scale
Cloud (AWS/Azure/GCP)
Services like S3, Glue, Data Factory, BigQuery, etc.
and 1 hr round and i joined within a week.