KPMG Data Engineer interview questions

I was interviewed for Data Engineer profile, got all answers correct- response was good and just before salary discussion, HR asked if I have got any offers and the details of it. Before interview too I had told ECTC to which team had agreed upon, but at the end they just rejected without reason. They wanted my time and energy.

First round was a SQL round. Second was L1 Technical round Third was again a technical round Then last with the director which was again a techno-managerial round. Most of the questions were from SQL, DATA WAREHOUSE AND Data modelling. Please understand and work on them very well if you need to nail the interview. Then there was questions from the database designing part. If you are into some cloud technology 50 percent questions will be from that part.