education:Btech from tier -2 college
experience-2.3 YOE as a data engineer

there were four rounds:

round1(90-120 mins)(technical round 1):
was asked to design a system similar to optimise command in delta lake in realtime scenario with all functional as well as non functional requirements in s3 with a pseudo code along with all sevices for logging ,monitoring ,fail proof,etc

round2(60 mins)(technical round 2):
design a automated system to get data from 100-1000s of databases which can be sql or nosql and populate it to data warehouse.System must be self healing incase of failure.

round3(45 mins)(managerial round):
discussion on projects in resume end to end description of a project with all challenges faced along with data quality metrics and a little bit of spark internals.

round4(30mins):
HR discussion and culture fit round