I applied through a staffing agency. I interviewed at LTIMindtree (Bangalore Rural) in Apr 2025
Interview
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.
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.
Interview questions [1]
Question 1
How I prioritize tasks when dealing with multiple dependencies