I had my interview vai video conferencing. Had technical queries & been explained addressed all questions. It was great experience to share my current job n understand the role n responsibility on my new role to be taken.

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.