Solicité el puesto a través de un captador. El proceso duró 3 días. Acudí a una entrevista en Oracle (Calcuta) en abr 2017
Entrevista
I was contacted by a recruiter on LinkedIn on Wednesday night and the interview took place on Saturday morning after I had cleared their online tests. I had basically no time to prepare. I am a QA analyst but this interview was for a Developer position and the recruiter did not mention this to me eventually leading to a lot of embarrassment for me. During the interview I was taken to a separate room and there were 2 people who asked me technical questions. They also probed me about my academics and whether I had a lag year and if I have EVER failed in a subject. They were nice people- even though I could not answer most of the stuff they did not discourage me but gave hints trying to help me out. However when I asked one of them, "What is it like working in Oracle? ", they gave me a reply which made me feel bad- he said : (Quoting from memory) "In Oracle we are responsible for our own work. We don't deliver work to client somehow and then run away like service-based companies do". Now I have 4 years of experience in a service-based company and I assure you that is not how we function. I did not say this aloud but apart from this small incident, the interview was good. I learned a lot.
Preguntas de entrevista [1]
Pregunta 1
1. OOP concepts- inheritance, static keyword
2. Design classes and methods to implement a "Parking lot" problem
3. SQL queries for scenarios- Lead, Lag, Rank, group by, joins
4. Difference between analytical functions and aggregate functions
5. How can you swap values of 2 columns in a table using a single query?
6. What is the reason you are looking for a change of job?
decent amount of DSA and System design were asked, and behavioral questions. so prepare leetcode level questions and good amount knowledge in sql, java and also mostly oracle sql. overall it was good
First online assessment. Then 2 interview rounds + 1 hr round. This was during campus placement. In interviews they mainly asked about dsa, os concepts, logical questions and some system design questions also.
Solicité el puesto por otro medio. Acudí a una entrevista en Oracle (Seattle, WA)
Entrevista
i got a return offer from internship, and I had to do one additional technical interview because I was switching branch. He first asked me a OOP question, and then leetcode medium level question.
Preguntas de entrevista [1]
Pregunta 1
What is BST? Write a function that verifies if it is a BST.
