Fairly easy process, met with a couple of Data Engineering team members who asked basic behavioral and a few technical (Data Warehousing and SQL) questions.
In the second round, had a small interview with CCAP's head and the role was explained to me, a few more technical and behavioral questions were asked.
This was immediately followed by a coding round on coderpad.io.
There were 5 PL-SQL based questions.