Got a call directly from the recruitment team. Asked about my current offer, salary, etc., and documents. After multiple calls, the interview was scheduled. It was a 1-hour video interview. The interviewer was not able to listen to me since there was a lot of noise at his end.

All scenario-based questions, not a single straightforward question.

Year-wise sales data to be loaded into the target. Load only positive sales data.

If a source file has a parent-child relationship, how will you load each file for different parents?

The interview was very tough, as the interviewer was expecting answers in detail.