This was an internal transfer, I used to work for the pre-sales team in oracle and I wanted to move to the development team of OCI.
Job role - Software Engineer [OCI]
So I started my prep on leetcode, did about 3 months of solid preparation
I had 5 rounds

Round 1:

• https://leetcode.com/problems/top-k-frequent-elements/
• Generic APIs - Write a function like convert(function, input)
  input - binary tree
  output - binary tree and the function applied on it. ex(toUpper)

Round 2:

• Find 1st index of element in a sorted array: https://leetcode.com/problems/find-first-and-last-position-of-element-in-sorted-array/
  input - [0,0,0,1,1,2,3,4,5,6], 1
  output - 3
• Burn the binary tree starting from the target node
• Bunch of questions on OCI

Round 3:

• https://leetcode.com/problems/reverse-linked-list/
• https://leetcode.com/problems/middle-of-the-linked-list/
• Class implementation of Linked List Node
• Basic questions on Java Threads and OOPs

Round 4:

• Full round based on OCI questions:

  1. What is Load Balancer?
  2. What is a compute?
  3. How to use load balancer?
  4. Load balancer algorithms?
  5. Basic questions on Docker.

  This round was specially for me as my previous role was a solutions architect. They were purely testing my skills on the previous role I performed at Oracle.

Round 5:
Manegerial + Behavioural (Bar Raiser Round)

1. Questions on previous projects
2. How to sell your product/ get people to test your innovations
3. Problems you faced while suggesting ideas
4. Scenario where your idea was good and implemented in the given product
5. Overall contribution to team and how it benefits the customer

Finally, I got the job and have been internally trasferred.
Huge shoutout to all the support I got here on leetcode.