Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Oracle Team. If you also belong to the team, you can get access from here

Oracle Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Oracle Technical Analyst Interview Questions and Answers

Updated 6 May 2024

Oracle Technical Analyst Interview Experiences

3 interviews found

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Mar 2024. There were 3 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Past Experience, Salary expectation, skills
Round 2 - Technical 

(2 Questions)

  • Q1. Questions on previous project and role, Technical Question 5- 6
  • Q2. How can You optimize MySQL queries.
  • Ans. 

    Optimizing MySQL queries involves using indexes, avoiding unnecessary joins, optimizing data types, and using query caching.

    • Use indexes on columns frequently used in WHERE, ORDER BY, and GROUP BY clauses.

    • Avoid using SELECT * and only fetch the columns needed.

    • Optimize data types to use the smallest data type possible for each column.

    • Avoid unnecessary joins and use INNER JOIN instead of OUTER JOIN when possible.

    • Enable qu...

  • Answered by AI
Round 3 - One-on-one 

(2 Questions)

  • Q1. Managerial Questions
  • Q2. Why want to leave the previous company

Interview Preparation Tips

Topics to prepare for Oracle Technical Analyst interview:
  • Html5
  • Java
  • Python
  • MySQL
Interview preparation tips for other job seekers - Prepare according to Job description and resume.

Skills evaluated in this interview

Saint-Gobain

We thank our employees for rating us 4/5 on AmbitionBox

Join a company where our employee's ratings speak volumes.

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before May 2023. There were 2 interview rounds.

Round 1 - Coding Test 

Search an unsorted array

Round 2 - Technical 

(1 Question)

  • Q1. Create dumic website
  • Ans. 

    Creating a dummy website involves designing and developing a basic website for testing purposes.

    • Choose a simple layout and design for the website

    • Include placeholder content and images

    • Ensure basic functionality like navigation and links work

    • Use dummy data for testing purposes

    • Consider using a website builder or coding from scratch

  • Answered by AI

Skills evaluated in this interview

Technical Analyst Interview Questions Asked at Other Companies

asked in Coforge
Q1. Write a program to get a employee list whose salary is greater th ... read more
Q2. Optimize the code for job scheduling written in the first round
asked in Coforge
Q3. Explain Security authentication implementation and what are the d ... read more
asked in Coforge
Q4. How did you implemented the microservices in your project, What a ... read more
asked in Coforge
Q5. How did you configure Api gateway to manage your microservices?

Interview Questionnaire 

3 Questions

  • Q1. About past experience and how could you benefit present company from past experience ?
  • Q2. What do you know about Oracle? Why do you want to join us ?
  • Q3. Achievements, difficulties, feedbacks from past organization?

Technical Analyst Jobs at Oracle

View all

Interview questions from similar companies

I applied via Naukri.com and was interviewed before Feb 2021. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Questions on Salesforce Basics. One can learn all great features in Salesforce.com but we must know the basic admin functionalities and features in Saleforce.
Round 2 - Behavioral 

(1 Question)

  • Q1. The questions will be on your career, Resume. They will look for story telling skills, can you be a team player and individual player, etc. Can be technical as well.

Interview Preparation Tips

Interview preparation tips for other job seekers - First know the basics of Saleforce.com for functional role then you dive into all great features in Salesforce.

I applied via Campus Placement and was interviewed before Nov 2019. There were 8 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Porters Generic Marketing Strategy
  • Q2. Extempore Pitch to position a product differentially in the Market
  • Ans. 

    Our product is the only one in the market that offers a unique combination of features and benefits.

    • Our product is designed to solve a specific problem that no other product in the market can solve.

    • Our product offers a unique combination of features and benefits that are not available in any other product.

    • Our product is backed by extensive research and development, ensuring that it is the most effective solution in the...

  • Answered by AI
  • Q3. Why MBA, Why Marketing

Interview Preparation Tips

Interview preparation tips for other job seekers - 1.Be confident , Open and Prepared

2.Kindly understand the question and answer relating with some of the concepts you have studied

I applied via Referral

Interview Questionnaire 

6 Questions

  • Q1. Tell me something about yourself?
  • Ans. 

    I am a highly motivated and detail-oriented individual with a passion for problem-solving and continuous learning.

    • I have a Bachelor's degree in Computer Science and have completed several online courses in data analysis and machine learning.

    • I have experience working as a software developer and have also worked on data analysis projects for a non-profit organization.

    • I am proficient in programming languages such as Pytho...

  • Answered by AI
  • Q2. My role at previous workplace?
  • Ans. 

    I was a project manager responsible for overseeing multiple client projects and ensuring timely delivery.

    • Managed project timelines and budgets

    • Coordinated with cross-functional teams to ensure project success

    • Communicated project updates to clients

    • Implemented project management tools to improve efficiency

    • Led team meetings and provided guidance to team members

  • Answered by AI
  • Q3. Why consulting?
  • Ans. 

    Consulting offers diverse challenges and opportunities to work with different clients and industries.

    • Opportunity to work with diverse clients and industries

    • Challenging and dynamic work environment

    • Continuous learning and development

    • Ability to make a significant impact on clients' businesses

  • Answered by AI
  • Q4. How did you know Accenture?
  • Ans. 

    I came to know about Accenture through my research on top consulting firms.

    • Researched top consulting firms

    • Accenture was consistently ranked among the top firms

    • Read articles and reviews about Accenture's work and culture

  • Answered by AI
  • Q5. Guesstimate the number of travellers to Antarctica
  • Ans. 

    Around 50,000 travellers visit Antarctica each year.

    • The number of visitors to Antarctica has been steadily increasing over the years.

    • Most visitors go on cruises that depart from South America.

    • The International Association of Antarctica Tour Operators reported 44,367 visitors during the 2016-2017 season.

    • The number of visitors is regulated by the Antarctic Treaty System to minimize impact on the environment.

  • Answered by AI
  • Q6. Guesstimate the number of cab drivers in Delhi
  • Ans. 

    There are approximately 100,000 cab drivers in Delhi.

    • Estimate the population of Delhi (approx. 20 million)

    • Assume 1 cab driver for every 200 people

    • Factor in the number of tourists and visitors to the city

    • Consider the number of cab companies and their fleet sizes

  • Answered by AI

Interview Preparation Tips

Round: Case Study Interview
Experience: Case: A multinational firm in oil and gas segment is looking at setting up a green field plant by collaborating with ONGC India. You being one of the directors chosen to work for this partnership what are the most important factors you would look at?
Case analysis:
I divided the decisions into HR, operations, finance and marketing related decisions. Since the venture was a new one I focused on the organizational chart development and the role of director in selecting the right people for higher and middle management roles. I also talked about getting policies with regard to skill set of workers, policy on unions being in place. Talked about setting up a township and hiring a contractor for it as the location is likely to be in a remote area. Also, focused on retaining and hiring of talent.
Marketing function decisions included pricing of product (based on cost estimates of sales force) and sales force for carrying out B2B activities. Discussion on operations was the most important one in this case. I talked about the role of director in hiring a contractor and overlooking the subcontractors used. I also talked about the timelines of the project and suggested a milestone based approach with penalties to ensure that the work gets done. In addition to contract related equipment i focused on the equipment specification to match to the capacity expectations. Aggregate planning with scaling up was also suggested to make the factory operational and to sort out initial issues. I focused on the supply chain related issues to transport the end product to customers.(Suggested pipeline)
Talked about the role of cost accountant in determining the price of the end product and also focused on selecting an external auditor to oversee the accounting standards.

Structure:
Divided the case as per verticals in an organization.
A guesstimate on the number of streetlights in Lucknow was asked (He asked me to be very short in description and wanted me to use numbers at every step) .
I approached this by assuming Lucknow to be close to a rectangle in shape the dimensions being 20 x 15 Km. Then i assumed the main streets to be passing though lines joining the mid points. I assumed that these roads to be two lane and had the highest density of lights. The next part was about the streets branching out of these streets and i assumed lower density of lights here. Thus i got a series and added them up to get the number of lights.
Tips: Ask for clarifications to the interviewer if needed. Practice a lot of cases with your peers.
Be clear about "Why ABC (or any firm in consideration)‟?

General Tips: Analyze the case patiently and try not to goof up during case interviews.
Skills:
College Name: IIM Lucknow

Consultant Interview Questions & Answers

Accenture user image Ujjwal Mukherjee

posted on 10 Dec 2015

I applied via Referral

Interview Questionnaire 

1 Question

  • Q1. Estimate the size of the pre-owned LCV market in India
  • Ans. 

    The pre-owned LCV market in India is estimated to be around X units.

    • The market size can be estimated based on the number of registered vehicles and their age.

    • Factors like demand, supply, and pricing also play a crucial role in determining the market size.

    • According to a report by IndianBlueBook, the pre-owned commercial vehicle market is expected to grow at a CAGR of 15% by 2022.

    • The market is dominated by players like M...

  • Answered by AI

Interview Preparation Tips

Round: Case Study Interview
Experience: Q. Confirm understanding of LCVs – Is it like the Tata Ace?
Yes
Q. Estimate the market or only for our company?
Do it only for our company, and assume we have last 10 years of sales data

Tips: The case was not hard, but I was taken aback when asked to stop. Interview lasted for only 15 minutes which unsettled me What was good: PI, scoping and structured approach What could be better: Speed in solving the case.

Skill Tips: Before jumping into size, I identified factors that would drive sales of pre-owned vehicles like total cost of ownership, emergence of a better vehicle, expansion of alternate use by customers etc. Was asked to concentrate on TCO and I probed for yearly data of costs. Did not come up with a number as he abruptly stopped the interview Summarize the case. [Not more than 30 seconds!]
Skills: Case Analysis
College Name: Indian School Of Business (ISB)

Consultant Interview Questions & Answers

Accenture user image Pranai Agarwal

posted on 10 Dec 2015

I applied via Walk-in

Interview Questionnaire 

4 Questions

  • Q1. There is an international bank (US based) that has been operating in Asia for the past 10 years. However, recently it has noticed that a lot of its customers are leaving the bank and using services of othe...
  • Ans. 

    Customers leaving a US-based international bank in Asia for local/regional banks.

    • Possible reasons could be lack of understanding of local market and culture

    • Inability to provide personalized services to customers

    • Higher fees and charges compared to local/regional banks

    • Competition from other international banks with better offerings

    • Negative perception due to scandals or controversies involving the bank

    • Lack of innovation a...

  • Answered by AI
  • Q2. Tell me something about your work and what you exactly did?
  • Ans. 

    I worked as a consultant for a tech company, providing strategic advice and solutions for improving efficiency and productivity.

    • Analyzed current processes and identified areas for improvement

    • Developed and implemented strategies to streamline operations

    • Provided training and support to staff on new technologies and processes

  • Answered by AI
  • Q3. What did you do in relation to financial products?
  • Ans. 

    I have experience in managing and selling various financial products.

    • Managed a portfolio of mutual funds and provided investment advice to clients

    • Sold insurance policies and explained the benefits and coverage to customers

    • Assisted in the underwriting process for loans and evaluated creditworthiness of applicants

    • Developed financial models to analyze the performance of different investment options

    • Collaborated with other ...

  • Answered by AI
  • Q4. Which horizontal and vertical do you see yourself working in at Accenture?
  • Ans. 

    I see myself working in the Technology and Financial Services verticals at Accenture.

    • I have experience in implementing technology solutions for financial institutions.

    • I am interested in exploring emerging technologies in the financial sector.

    • I am also open to working in other verticals based on project requirements.

  • Answered by AI

Interview Preparation Tips

Round: Stress Interview
Experience: The company focuses on Heavy on cases relevant to your past work experience and functional expertise. Structured approach while solving the cases rather than exact solution.

Round: Case Study Interview
Experience: Q. Is there anything that has happened in the economy that is resulting in this change?
No, nothing has happened in the economy.
What does the company do? What are the products provided?
Company provides deposits, lending, but major into processing of payroll related data.
Q. What are the various sources of revenue?
Payroll related services and processing capabilities to other companies.
Q. Is the processing of payroll data carried out differently in the USA as compared to the Asia Pacific region?
Yes, that is exactly what it is. In the US, majority of the processing is being done manually, and this process has been copy pasted in the Asian subsidiaries. However, in Asia, technology and automation is being used by other regional and local banks, hence they are able to provide faster and better service.
Q. Where all does the firm operate in the Asia pacific region?
All over.
Q. Who are the competitors and are they offering any different services?
Not relevant.
Tips: As you can see the case isn't much hard. The focus is more on structured approach and the way you are involving the interviewer. This was the feedback that I received. 4) Good approach with the economy, company and market 5) Could have been a bit faster with the questions In general for Accenture, prepare for cases from your industry as there is a high probability you will be put in an interview with someone with that particular industry expertise.

General Tips: Interviewee can start by repeating the case to the interviewer in order to make sure he/ she has understood the objective properly (very very important). Then start of by describing the economy of the country in which the client is in (read the papers) and ask if any external change is resulting in the issue. Then move onto the company and ask about what the company does, product mix, revenue and cost trends over time. Then move onto the market scenario (industry analysis) and ask about market size and growth rates, competitors and market shares. Use this data to start solving the case and involve the interviewer as much as possible. Summarize the case. [Not more than 20 seconds!
Skill Tips: In general for Accenture, prepare for cases from your industry as there is a high probability you will be put in an interview with someone with that particular industry expertise.
Skills: Case Analysis
College Name: Indian School Of Business (ISB)

Consultant Interview Questions & Answers

Accenture user image Ujjwal Mukherjee

posted on 10 Dec 2015

I applied via Referral

Interview Questionnaire 

3 Questions

  • Q1. Talk about a challenging project at work and what you took away from it
  • Ans. 

    Managed a project to implement a new CRM system for a large retail company

    • Had to coordinate with multiple departments and stakeholders

    • Faced challenges with data migration and system integration

    • Managed to complete the project within the given timeline and budget

    • Learned the importance of effective communication and project management skills

  • Answered by AI
  • Q2. How will your friends describe you?
  • Ans. 

    My friends would describe me as dependable, loyal, and always willing to lend a helping hand.

    • Dependable

    • Loyal

    • Helpful

    • Good listener

    • Positive attitude

  • Answered by AI
  • Q3. What else did you do apart from maintaining a good GPA at ISB
  • Ans. 

    Apart from maintaining a good GPA at ISB, I was actively involved in various extracurricular activities.

    • I was a member of the organizing committee for the annual cultural fest

    • I participated in various case competitions and won a few of them

    • I volunteered for a local NGO and organized a fundraising event

    • I was a part of the debate club and participated in various inter-college competitions

    • I also attended various guest lec

  • Answered by AI

Interview Preparation Tips

Round: HR Interview
Experience: Was comfortable with PI What was good: Confidence What could be better: Did not have knowledge on the projects / kind of work done by different divisions


Skills: Personnel Management
College Name: Indian School Of Business (ISB)

I applied via Referral

Interview Questionnaire 

1 Question

  • Q1. You have to make a choice between 3 consulting offers that you have and you should prepare an issue tree analysing the situation

Interview Preparation Tips

Round: Case Study Interview
Experience: The theme of the interview was to test how I react when put under pressure and I think the way I responded to it is what clinched the interview for me. I think the interviewer was very aggressive in his questions and tried to make the questions as uncomfortable as possible for me.One learning that I would want to leave out of this experience is that it works better if you take a stand and are hard on that throughout. Just hang-in, by using different arguments possible or even repeat the same arguments in different ways but its important to just hang-in. For example, on the consulting vs. I-banking issue, there were moments when he dominated the discussion so much that I could have shifted my stance a bit but in hindsight that could have been fatal.
Tips: Frankly, issue trees are ambiguous in the sense that you can cut the problem any which way and I made a 3 level issue tree. Don’t think I should give the one that I made here as benchmark because its easy to make any issue tree and then defend it. I presented the tree and the interviewer seemed to like how I did it. He raised a point that I missed incorporating information about the and adjusted my analyses promptly.

Skills:
College Name: Indian School Of Business (ISB)
Contribute & help others!
anonymous
You can choose to be anonymous

Oracle Interview FAQs

How many rounds are there in Oracle Technical Analyst interview?
Oracle interview process usually has 2-3 rounds. The most common rounds in the Oracle interview process are Technical, HR and One-on-one Round.
How to prepare for Oracle Technical Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Oracle. The most common topics and skills that interviewers at Oracle expect are Oracle, Troubleshooting, PLSQL, SQL and Support Services.
What are the top questions asked in Oracle Technical Analyst interview?

Some of the top questions asked at the Oracle Technical Analyst interview -

  1. How can You optimize MySQL queri...read more
  2. Create dumic webs...read more

Recently Viewed

JOBS

Gushwork

14 jobs

JOBS

Browse jobs

Discover jobs you love

JOBS

GroundTruth

33 jobs

PHOTOS

Growisto

7 office photos

JOBS

Oracle

No Jobs

JOBS

AGI Technologies

No Jobs

JOBS

Quaarc Solutions

No Jobs

JOBS

Siemens

No Jobs

JOBS

Oracle

No Jobs

JOBS

Deepija Telecom

No Jobs

Tell us how to improve this page.

Oracle Technical Analyst Interview Process

based on 2 interviews

Interview experience

4
  
Good
View more

HCLTech

There's no stopping you

Technical Analyst Interview Questions from Similar Companies

View all
Oracle Technical Analyst Salary
based on 233 salaries
₹4.7 L/yr - ₹15.3 L/yr
9% less than the average Technical Analyst Salary in India
View more details

Oracle Technical Analyst Reviews and Ratings

based on 25 reviews

4.0/5

Rating in categories

3.2

Skill development

4.2

Work-life balance

3.6

Salary

4.1

Job security

4.0

Company culture

2.8

Promotions

3.2

Work satisfaction

Explore 25 Reviews and Ratings
Fusion HCM Technical Analyst

Bangalore / Bengaluru

7-12 Yrs

Not Disclosed

Fusion HCM Technical Analyst

Bangalore / Bengaluru

7-12 Yrs

Not Disclosed

Fusion HCM Technical Analyst 3-Support

Bangalore / Bengaluru

5-9 Yrs

Not Disclosed

Explore more jobs
Senior Software Engineer
2.4k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Consultant
2.1k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Principal Consultant
2k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Member of Technical Staff
1.8k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Application Engineer
1.4k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Oracle with

SAP

4.2
Compare

MongoDB

3.7
Compare

Salesforce

4.0
Compare

IBM

4.0
Compare
Did you find this page helpful?
Yes No
write
Share an Interview