About
ROLE: Software Development Engineer, QA
CTC: 16.65 LPA
ELIGIBILITY:
- B.Tech & M.Tech with specialization in CSE/ECE/EEE/IT/MCS (CS/IT & Circuit branches); research students are not eligible.
- 7/10 or above or percentage equivalent to 70% or above.
- No Active Backlogs in any semester.
NO. OF RECRUITMENTS: 6
Selected Candidates
HARSHAVARDHAN
Department:CSE
Written test round:
It consisted of 4 sections and each sections was further divided into subsections
There was time limit for each section and subsection and had no negative marking, the test had 90 questions to be solved in 107 minutes and was divided as:
Section 1 : Aptitude test (Quantitative, logical, data interpretation, Reasoning )
Section 2 : Coding Skills (Avl,binary,Btress,code snippets with output , flow diagrams)
Section 3 : Computer Science and Knowledge (Operating Systems, Computer Networks, DBMS, CSE basics)
Section 4 : Contextual Communication (Passage Reading, Grammar, missing words, parts of speech, correct sentences, antonyms, and synonyms)
The round was a bit difficult as we couldn’t re-attempt the questions once submitted and also due to subsectional timer
Round-1: (Technical)
Self introduction
Problems:
1) Given a set of medicine expiry dates and shipping dates how do you map in a best way such that customer doesn’t get expired medicine
2) Sort an array with numbers consisting of only 0,1,2 in one pass without using sort function
https://leetcode.com/problems/sort-colors/
3) How do you detect if a loop is present in a graph
https://leetcode.com/problems/linked-list-cycle/
(The proof for my solution was asked)
4) How do you find the middle value of a linked list in a single iteration
https://leetcode.com/problems/middle-of-the-linked-list/
5) Check if the given trees are identical or not
https://leetcode.com/problems/same-tree/
6) Any questions for the interviewer
Round-2: (Technical)
Self introduction
I mentioned regarding my cloud related work at IEEE based on which the following questions were asked
Questions:
1) Explain about data communication between OSI layers
2) Explain what is load balancing and EC2 instances
3) How does server redirect traffic based on its load
4) Explain about CDN
5) Difference between choosing a 3rd party host and deploying ourselves, which is better and why
6) Any questions for the interviewer
Problems:
1) Reverse a linked list in groups of K
https://leetcode.com/problems/reverse-nodes-in-k-group/
( I couldn’t solve this question as I wasn’t able to resolve a bug before the time limit, but I explained him my idea regarding what my code was trying to achieve, probably this made me qualify for the next round)
Round-3 (HR)
Self introduction
Problems:
1) Find second largest number in a given array
2) Find k closest numbers in a given set of numbers and write the possible test cases you would use to ensure its working properly
3) Swap 2 numbers without using 3rd variable
Questions:
1) Explain about your role at IEEE
2) Basic questions regarding my projects, the database I used for them and deployment
3) Why do you want to join oracle
4) What is caching? Consider a scenario where we have lots of money, is it a good idea to make all of our memory organization into caches
5) Why do you think you are suitable for the role
6) What do you know about netsuite
7) Did you participate in any coding events
8) Were you selected in other companies
9) Any plans for higher studies
10) Finally he asked me if I have any questions for the interviewer
- Be mentally prepared to give 3–4 rounds in a single day.
- Honesty is the best policy. If you don’t know any answer, accept it and tell them. You can ask for hints or they will change the question.
- During interview, don’t jump straight to the solution. First reiterate the question, ask for edge cases. Tell them about what assumptions you are making.
- Think out loud. Convey your though process like how you are arriving at the solution. Start with brute force then keep improving the solution further.
- Don’t hesitate to ask for clarifications and hints about the question.
- Go thorough the company thoroughly before attending the interview, ask relevant questions about the job and company when asked, to show that you are excited for the job.
MANASA
Department: CSE
This is my Interview Experience for the position of a developer at Oracle. All of the rounds were conducted online.
Round 1– Written:
Consisted of 4 sections (aptitude, coding skills, computer science knowledge, and contextual communication). All of the sections contained multiple-choice questions. Shortlisted students were divided into 4 groups and I got selected under the ONI group.
The interviewer was friendly and calm.
He started off by asking me 2 coding questions. The 1st one was to print a given pattern. The 2nd one was to choose 3 numbers from the array such that their sum was equal to a given number.
Tip: Always start by giving them a naïve solution and then try to optimize it. Make sure to communicate your thoughts to the interviewer so that he might help you when you get lost. Consider checking your code against edge cases too.
Dbms questions- various types of joins, selecting the nth highest mark from the table, authorization, etc.
Examples where you would use multithreading and how to implement it in java.
A brief discussion about my projects. ( He was really impressed with my robotics IEEE project- self-driving car )
Sorting algorithms and how the time complexity of each one was found out.
Can’t recall all the questions but these were the main ones 🙂
Round-2: (Technical)
Focused a lot on my projects. In-depth discussion about all of them and related questions asked.
Lot of Questions on APIs and the client-server architecture.
Questions on cloud (different services, load balancing, etc)
Tip: remain calm and confident. Always listen to what the interviewer says. Include unique and interesting projects in your resume.
Round-3 (HR)
questions about oracle.
Asked about my preference towards python instead of java.
What I knew about cloud
Leadership and teamwork skills tested
Extra activities I mentioned in my resume were questioned.
SOUMITHA
Department: ECE
MY ORACLE NETSUITE INTERVIEW EXPERIENCE
The hiring process consisted of 4 rounds.First was an online test and remaining 3 were F2F interviews.
Round1:
This was an online written test of 90 MCQS for 107 mins which had sectional and subsectional timing cutoff. No negative marking.We cannot navigate back and forth within any question.This was the major elimination round.
The 4 sections and their subsections are
1.Aptitude: Quantitative,Logical Reasoning,Flow chart (logic was described and needs to be represented in flow chart),Data Interpretation.
2.Coding based MCQs:Most of the questions were from trees(Binary trees,Binary Search Tree,AVL tree)and traversals ,code snippets with output.A tree was given and 3-4 questions were based on the single diagram.
3.Computer Science and Knowledge: Operating systems,DBMS,OOPS,Time Complexities.
4.Contextual Communication:Reading Comprehension,Grammar Correction,Picking the
correct order of sentences,Synonyms,Antonyms.
Time Management is important to clear this round.
This was the first technical Interview.It started with our introductions(This was the first thing in every round).He then started asking coding questions for which I need to explain the approach and then write the code.
● Sort an array of 0’s,1’s,2’s(To be done in linear time and constant space).
● What are different types of trees?
● What is a self balanced tree?
● Kth largest element in binary search tree(constant space).
● Then he asked about projects.
This round lasted for around 30 mins.
This was the second technical Interview.
● 5 statements with const keyword are given and I need to explain what each line meant.(int const a,const int a,int* const a,const int* a).
● What is a pointer?Types of pointers in C.
● Difference between Compiler based and Interpreted based language and advantages of interpreter based language.
● Different data types in C.
● Why is struct used?Create a struct named student and make instances of it.
● A code snippet was given and output is to be determined.
● What is a database? What is DBMS?
● Advantages of DBMS over file system.
● What is primary key and foreign key?
● What is final keyword?
● Then he proceeded to a coding question.A matrix is given whose elements are sorted in row wise and column wise in ascending order and an element is to be searched.He asked me to code both brute force and the optimal approach.(To be done in linear time and constant space).
● Asked what all data structures I knew.He then gave a tree diagram and asked outputs for various traversals and views.
I asked about learning experience in Oracle and the work culture.This round lasted
for around 1hr 10 mins.
This was the final round.It was the managerial round.He asked how I felt with the whole process and then proceeded with the technical stuff.
● Differences between C and C++.
● What type of language is C?
● What is meant by OOPS? What are the various features of OOPS and explain them?
● What is the difference between private and protected access modifiers?
● A bank is to be started.Write the code describing its functionalities using oops concepts.
● How much do you rate yourself in DBMS?
● SQL query to find 2nd highest salary.
● Puzzle:Two jars of capacity 3L and 5L are given and 4L is to be measured.
● Asked about hobbies.
● Asked if I’m interested in higher studies. I said No and he asked why?
● Asked about Verilog HDL and how it is different from C(verilog was mentioned in my resume).
Finally, I asked a few questions.This round lasted for around 25 mins.
❖ Make your self introduction crisp and informative.Tell about your education,technical skills,projects and internships.
❖ Prepare what you need to tell about projects well before.
❖ For coding questions start with brute force and move to optimized solutions.While writing the code try to explain what you are writing.Don’t be silent.Try to be interactive.
❖ Ask informative questions at the end of every round.
VAMSHI KRISHNA
Department: ECE
Oracle Netsuite visited our campus for the role of Software Engineer/Associate Software Engineer/QA
Analyst.
The entire process was virtual and consisted of 1 written test on oracle’s platform, Followed by 2
Technical Interviews and 1 HR Interview.
Round 1:-Written Test
This test consisted of MCQ’s based on Aptitude, DBMS,OS, DSA.Many of the questions were based on
Binary trees,AVL trees,Flow Charts.
You need to practice a lot to clear this round as Time is less.
Techinal Interview 1
It started with an Introduction of mine,Then the Interviewer asked me some basic questions on OOPS
and Data Structures.
A coding question Based on Arrays.
Find The index of an Array element,The sum of all the elements to the left of it is equal to The sum of all
the elements to it’s right.
Asked me to reduce time complexity and space complexity.
Round-2: (Technical)
Technical Interview 2
3 coding questions were asked in this round.
https://www.geeksforgeeks.org/sort-an-array-of-0s-1s-and-2s/
https://www.geeksforgeeks.org/remove-nth-node-from-end-of-the-linked-list/
https://www.geeksforgeeks.org/merge-two-sorted-linked-lists/
The Interviewer was more Interested in the approach than the code.
Make sure you handle all the corner cases.Ask Follow up questions regarding the problem statement and discuss the approach first,rather than Writing the code directly.
HR Interview
This round began with typical Hr questions followed by detailed Discussion on Java.
The Interviewer then asked me a puzzle and told me to generalize it using mathematical formula.Then he gave me a scenario and asked me to implement it using Java sort function by Comparator interface.
He finally asked me the logic for this https://www.geeksforgeeks.org/count-ways-reach-nth-stair-using-step-1-2-3/
All the Interviews started with an Introduction of mine and concluded with few questions asked by me for the Interviewer.
SUPRAJA
Department: CSE
online written test
4 sections
each section has subsections
The time limit for each section and subsection
No -ve marking
Sectional cutoff for each section
Section 1 : Aptitude test
Subsections : Quantitative ,logical,data interpretation,Reasoning
Section 2 : Coding Skills
-: Avl,binary,Btress,code snippets with output , flow diagrams
Section 3 : Computer Science and Knowledge
- Operating Systems, Computer Networks, DBMS, CSE basics
Section 4: Contextual Communication
Passage Reading, Grammar, missing words, parts of speech, correct sentences, antonyms, and synonyms.
90 questions 107 minutes
Overall the test was not that easy because of the Sectional time limit
It was my first interview. I was a little tense but the interviewer was very friendly. She made me cool down by asking about extracurricular Activities mentioned in my resume. (About Youva)
- Then she asked me basics about CSS, HTML, JavaScript, and React (because they are mentioned in my resume). These Questions were very basic but tricky.
- Then she asked me about the differences between a flowchart and an Algorithm and examples
- 2 to 3 lines about each data Structure and their use in real life,we had a conversation about data Structures
- I said my favorite programming language is java so she asked me the difference between java and other languages
- OOPs basics
- I opened my eclipse and I gave a walkthrough about all the functionalities that eclipse provide
- She asked me to write a method to reverse a number involving oops concepts (making method private, creating an object and calling the method, inheritance, and encapsulation)
- Final and this keyword usage
- Palindrome program following naming Conventions in java and OOPs concepts
- Operating Systems (Questions on kernel, system calls, threads and advantages,real-life examples) the more you answer the more they ask
- DBMS – advantages of normalization
- Sql – create a table with primary key and foreign key with different constraints
- She was asking about joins but she said time is up and she asked me to leave the meeting
The interviewer was really calm and listened to whatever I said with a smile
- He asked me about a situation where I was creative and solved a real-life problem
- A situation where I was versatile
- Then asked me about projects (mine is full stack web development project)
- Technical and logical problems I faced during the projects
- Asked me about the tech stack that I used and why
- How am I planning to Scale the project and what Additional features that I would add later
- I hosted my projects and put that link in my resume. So, he looked at projects and seemed pretty satisfied
- Asked me to write a SQL Query for filtering the data I get in one of my projects (very basic)
- Asked some questions about why I used FireBase in my projects
- Asked me about REST (as it was mentioned in my resume)
- Asked me what my favorite data Structure is. I said trees so he asked me to write a pseudocode for the diameter of a tree and made me dry run and explain with an example
- Then question on (number of jumps needed to reach the end of the array) just asked the approach, I did not code
- Asked me about anagrams. He gave me an array of words and asked me to separate all the sets of anagrams. I told the process involving sorting and using a hash map. Along with time and space complexities
- SQL questions nth highest salary
- Asked me what I know about oracle
- Then finally asked me if I had any questions for him.
I was immediately taken to the next round
The interviewer was a manager. He asked me if I was tired of continuous interviews (Lol). He was so cool and asked me about my college and how I learned web development. We talked about how logical thinking is important and my views on it.
- Asked me 2 Puzzles
- https://www.geeksforgeeks.org/puzzle-7-3-bulbs-and-3-switches/
- https://practice.geeksforgeeks.org/problems/the-3-5-litre-die-hard-water-puzzle
- Opened my projects and looked at the UI asked me how my project is useful
- One SQL query
- question on how do you design a database for Instagram (all the different tables we need and column names primary key, foreign key)
- He asked me if I have SQL in my project, I said no because firebase uses NoSql and I gave a basic idea on how firebase stores data in the form of collections and documents
- We talked about work culture and Expectations from freshers in Oracle.
Finally got Selected
ROSHAN
Department: ECE
MY ORACLE NETSUITE INTERVIEW EXPERIENCE (ON CAMPUS)
(Tell me about yourself, Any questions for me? common in every round)
ONLINE WRITTEN TEST
It was the first elimination round which consisted of 4 sections and had several subsections in it, where in every subsection had respective time limits (which is very less) and also cutoffs, which is the main reason for the difficulty of the test.
There is no negative marking.
SECTION 1: APTITUTE TEST
Subsections: Quantitative, logical, data interpretation, Reasoning.
SECTION 2: CODING SKILLS
Mixed type were asked of which majority were based on AVL TREES (building, rotating etc), SORTING ALGOS (mine was radix sort related ques), BINARY TREES, BTREES etc.
The second section consisted of data flow diagrams and their outputs.
The third section was something like code snippets and their outputs.
SECTION 3: CONTEXTUAL COMMUNICATION
The type of ques(subsections) includes comprehension, grammar, antonyms, synonyms, sentence correction, ordering of sentences, parts of speech etc. Comparatively this was some sort of easier section of all, but other challenging task was the ques to time ratio was less than a minute for the ques other than the passages, which should
be taken care of.
SECTION 4: CS KNOWLEDGE
This section mainly tests your knowledge on CS basics and advanced concepts.
The subsections consists of OPERATING SYSTEMS, DBMS, SQL, COMPUTER
NETWORKS, CS KNOWLWDGE.
The above written round was on Aug 13 and results were out the next day.
Interviews were on Aug 17.
(First online interview round)
Started with the briefing about myself and asked about projects and related follow up questions, if any.
Straight away jumped into solving questions (all my technical interviews are purely problem-solving type), he gave me question to find the diameter of a binary tree.
Solving included drawing a pseudo tree on the board shared and first explain the answer for the tree drawn and then the required approach. He was satisfied with the tree drawn and required answer and then asked to write the code for the same, as there could be no further optimization, he was satisfied with the code written
(but if there could be an optimization, he asks to do it)
Then he asked me about the memory efficiency of creating an object to creating a static method and a detailed discussion of how both works for about 6-7 min.
He asked me about ACID properties in dbms and asked to explain each in detail.
The last question he given me was to find the longest substring without repeating characters and gave me some testcases to dryrun them.
As we were running out of time, he was curious about my approach for solving the same.
First, I gave the bruteforce approach of finding all the substrings and find the longest one, but he asked me to further optimize to linear time complexity.
I then gave the approach using hashmap and he was all satisfied with that approach.
The last part was any questions for him.
The interview lasted for about 40 min.
This round also started with a briefing about me and about projects.
He started with definition of recursion and then a simple problem stating finding power of a number without using inbuilt functions.
Told him the bruteforce iterative approach and then he told me to optimize further, (I didn’t remember the bit manipulation method), so went with divide and conquer of handling odd and even powers, even then he wasn’t satisfied and asked to further optimize and then I
corrected my code a bit but its not working for corner cases like for 100 and basically for number pow zero .
This question lasted for about 20-23 min and then somehow, I could do after couple of hints.
Then he asked me about tree traversals and explanation for every traversal (inorder especially).
Then he told me if I know iterative inorder of a binary tree and asked me to draw a pseudo tree and asked me the output.
I told him that I would use stack and carry my approach, he was satisfied with my approach and asked me to code and few follow up’s like why only stack and not queue and what is stack etc.
This one took me about 30-35 min and at last he gave me a tree to dryrun especially includes skewed trees.
He was a perfectionist and was not considered about my approach and all but asked me to walk him through the code and if the output was correct.
Then he asked me a question on arrays to find triplet sum closest to zero, first I told him the brute force and then for optimization I said I would sort the array and perform accordingly to my requirements (as he also asked for the quadruplet sum too).
The last question was based on quicksort and asked me about where does quicksort has its worst case and a detailed discussion for about 15-20 min.
Asked about Masters theorem, Recurrence Relations and few academics related questions.
The last few minutes was any questions to him.
This round lasted for around 1:30 hrs.
Round-3 (HR)
This was purely resume based round and seldom does it have any technical questions.
A briefing here too and intro into the projects.
Some mandatory HR questions like why oracle etc.
Then he shared her screen and asked me to write the approach for a puzzle she’s yet to give.
She then stated to measure 9 minutes using two hourglasses of 7 and 4 min each.
Do not directly jump into the solution, instead clarify what are the requirements and given things.
She was satisfied with my approach and asked me to write the approach on the board shared.
This lasted for about 20-25 min.
The last part was any questions for her.
Finally got selected!