Blackstraw interview questions

I attended a walk‑in interview at BlackStraw. The process had three rounds: Round 1 – HR Intro Self‑introduction. Questions from my resume. Reason for leaving previous company. Do you have any other offers? Round 2 – Technical Round Self‑introduction. What is SCD (Slowly Changing Dimension) and its types? Which type of join would you use if one table is large and the other is small? How will you increase the performance of a query in SQL or PySpark? Difference between repartition and coalesce in PySpark. What is incremental data loading? How do you implement incremental data loading? What are the types of transformers? Difference between view and materialized view Round 3 – Managerial HR Round Self‑introduction. General discussion about background, expectations, and cultural fit. Do you have any other offers?