Oracle NetSuite Interview Experience for ASE 2023

HackerRank Online Test:

Pattern:

Question-1: Coding.

MCQs (2-21): Computer Fundamentals, DSA, Logical Reasoning, Aptitude, Verbal.

Question-22: Rest API.

Duration: 1 hr 40min.

Question-1:

For a given string of repeating characters, remove the duplicate characters such that the result string is lexicographically highest.

Question-22:

For a given API of country and continent codes retrieve country names that have the given country code in its name.

The Online test results were out within 2 days of the test.

The next rounds in the hiring process consists of 4 face-to-face interviews. The first three rounds are technical interviews and the fourth is the HR round. All the technical rounds will happen for a minimum of 30 mins duration.

TR1 Questions (Duration: 30-35 mins):

1. Self Introduction.

2. Projects

3. DBMS

4. Second highest salary – answer multiple approaches and also inform about the type of SQL query (MySQL specific, oracle db specific, etc..)

5. DSA-1: For a given array of unsorted integers find the possibility of sum of a pair to give a target K.

6. DSA-2: For a given tree verify if it is a perfect parent or not. (Perfect parent is where if the parent node value is equal to the sum of the values of its child nodes).

7. Javascript – promises, callback functions.

8. Internship experience – project that I’m involved in, technologies I used in it.

9. Asked about S3 bucket which I used in my internship.

10. Also asked about AWS Services which I used in my internship.

11. Differences between CPP and JS

12. Which prg language i prefer to use and why.

13. Do you have any questions for me?

TR2 Questions (Duration: 30-35 mins):

1. Self introduction.

2. DBMS – Normalisation techniques, Anolamlies, ACID properties.

3. SQL – Given a table order table with customer id, product quantity and product price per unit. Find the top 3 spenders. (Note: the customer might repeat as this is orders table and primary key is order I’d not customer id).

4. Given a table and asked me to identity it’s normal form. And asked for the problems with in it. Asked to convert it into next higher normal form and asked for an ER diagram for this new normal form state. And asked for the problems with in this new normal form and approaches to over come it.

5. Programming-1: In word document or text editors when a line is out of space to fit a complete word we need to move that complete word to the next line rather than breaking the word into two lines. He asked me to code this functionality and dry run my code with diverse test cases.

6. Programming-2: Given two dates in DD-MM-YYYY format and aksed to calculate due number of days in between (guaranteed that second is always equal or greater than the previous date). The interviewer expected me to dry run the code by thinking for multiple edge cases and explain how each block of code is handling each edge case.

7. Do you have any questions for me?

TR3 (Managerial) Questions (Duration: 30-35 mins):

1. Self introduction.

2. Why oracle?

3. Why only oracle? (This question might be specific to your answer for above question)

4. What role do you like the most developement or testing and why?

5. Asked about my experiences in previous rounds.

6. Write testcases for a coding question asked in previous rounds.

7. Projects – (Indepth analysis of them)

8. Project related questions like – I used OAuth in one of my projects. So he asked me to explain its necessity for this project and it’s complete working.

9. Choose any project and explain the complete architecture of it.

10. Other than studies – hobbies, what are your interests. He might also test you in those interests whether do you really do them in real life.

11. Do you have any questions for me?

HR Interview Questions (Duration: 5-10 mins):

1. Describe your Interview experience.

2. What do you like the most in this interview and what did you hate.

3. Relocation (they look for valid, genuine and unique explanation for your answer).

4. M.S. / M.Tech plans (they look for valid, genuine and unique explanation for your answer).

5. Expectations from the role.

6. Hobbies.

7. Do you have any questions for me?

The results were out after the interviews on the same day.

VERDICT: SELECTED

Suggestions:

1. Self intro gives interviewers a huge information about you. So be careful on what you would say.

2. For DSA, if you had any question ask the interviewer about it, it might be regarding the choice of programming language or constraints or the question itself. But if you had any doubt ask him before jumping into the solution.

3. Come with multiple approaches and code for the approach that the interviewer asks you.

4. It’s all about resume and how diverse you can think.

5. For TR2 questions the main objective is to check how diverse you can think even before you encounter errors with the edge cases. He expected me to dry run even before he asked me (and I did it actually).

6. For SQL, DSA questions come with multiple approaches.

7. For SQL inform him about the DB specific query you are writing (MySQL, Oracle DB, etc..)

8. Include only those skills you are really aware of in your resume.

9. For any project you do try to include motivation for the idea, necessity and approach. This makes a huge difference on your profile for the interviewer and makes you outstand others.

10. Always utilise the opportunity of asking one or two questions to the interviewer if he asks you? This is a godlen opportunity to build up the conversation.

11. End the interview by greeting them. This leaves a positive impression.