Prepare well on the technologies you work on. Major development happens in ADF, JAVA and SQL. So it is highly important to prepare in the area that you want to work at. You will be grilled to the very core in the technological terms.
I applied through a recruiter. I interviewed at Oracle
Interview
In person interview, easy questions asked on ML, puzzles and 2 dsa questions. Mostly from gfg and ml101 basics. asked about regularisation, cancer detection, scenario based questions etc . puzzle were sheep man and grass, lantern bridge
I applied through an employee referral. I interviewed at Oracle (Hyderabad)
Interview
First round dsa
Second round dsa
Third round hm
Find firts k element.
Height of treee
Level order traveraal
Third highest ekemenbt
Dp digit
Knapsack
Height of tress
Queueu
Disjoint set
PriorityQueue
it was fine lenghty AND EASY a bit difficult 3 rounds 1st round oa then 2 interview round the dsa questions were of medium level dbms hard sql queries oops basic questions some os questions some puzzles and all
Interview questions [1]
Question 1
Dsa and core subjects more on dbms as it is itself a database company