This round was conducted by a Senior Data Engineer. Major discussion areas: My experience with ETL pipelines — architecture and challenges Knowledge of distributed systems like Spark How I handle schema evolution in pipelines Designing a data model for a real-time clickstream pipeline I was also asked to solve a SQL problem on a shared screen — filtering latest records using ROW_NUMBER(). The interviewer was friendly and gave good hints when I got stuck while optimizing Spark transformations.

It was good. The question were more towards the optimization, compliance and security . The type of the ETL and the governance architecture. How to deal with the PII data, masking.