Ho presentato la mia candidatura tramite un selezionatore. La procedura ha richiesto 3 giorni. Ho sostenuto un colloquio presso Oracle (Calcutta) nel mese di apr 2017
Colloquio
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.
Domande di colloquio [1]
Domanda 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?
Mostly coding question focused, and some talking about personal experience and terms. Some technical design, you could have chosen any language to complete the coding questions. Questions were simple technical concepts that person came up with at the moment.
Domande di colloquio [1]
Domanda 1
Something like searching in logs using maps and filter/find data
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.
Le migliori aziende per "stipendio e benefit" vicino a te
