AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Oracle
Compare
Filter interviews by
Clear (1)
Oracle Technical Consultant Interview Questions and Answers
Oracle Technical Consultant Interview Experiences
2 interviews found
Anonymous
I applied via Company Website and was interviewed in Jun 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Design pattern used
- Ans.
The design pattern used is the Factory Method pattern.
Creates objects without specifying the exact class of object that will be created
Defines an interface for creating objects, but lets subclasses decide which class to instantiate
- Q2. Scenario based question
(2 Questions)
- Q1. Why are you joining this company
- Q2. Challenges faced in previous projects
Skills evaluated in this interview
Easy
(1 Question)
- Q1. What is networking ? explain in your own words
- Ans.
Networking is the process of connecting devices and systems to share resources and communicate with each other.
Networking involves the use of hardware and software to connect devices and systems.
It allows for the sharing of resources such as files, printers, and internet connections.
Networking also enables communication between devices and systems, allowing for the exchange of data and information.
Examples of networkin...
(4 Questions)
- Q1. Why are you looking for a change?
- Q2. Where do you see yourself in 5 years?
- Q3. What are your strengths and weaknesses?
- Q4. Tell me about yourself.
Interview Preparation Tips
Skills evaluated in this interview
Technical Consultant Jobs at Oracle
Interview questions from similar companies
I applied via Naukri.com and was interviewed before Feb 2021. There were 2 interview rounds.
(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.
(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
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...
- Q3. Why MBA, Why Marketing
Interview Preparation Tips
2.Kindly understand the question and answer relating with some of the concepts you have studied
Mahesh
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...
- 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
- 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
- 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
- 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.
- 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
Interview Preparation Tips
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
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...
Interview Preparation Tips
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)
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...
- 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
- 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 ...
- 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.
Interview Preparation Tips
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)
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
- 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
- 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
Interview Preparation Tips
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
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)
I applied via Referral
Interview Questionnaire
8 Questions
- Q1. There is a factory. The transportation company charges the factory owners as long as their trucks stay in the factory area. Costs are rising due to this. How do you account for this problem?
- Ans.
The factory is facing rising costs due to transportation company charging for trucks staying in the factory area.
Analyze the transportation company's pricing structure and negotiate for a better deal
Consider alternative transportation options such as rail or water transport
Optimize the factory's logistics to reduce the time trucks spend in the factory area
Explore the possibility of outsourcing transportation to a third
- Q2. Tell me something about yourself?
- Ans.
I am a dedicated and experienced consultant with a passion for problem-solving and helping clients achieve their goals.
I have over 5 years of experience working in consulting firms, where I have successfully led projects from start to finish.
I have a strong background in data analysis and strategic planning, which allows me to provide valuable insights to clients.
I am skilled in building relationships with clients and ...
- Q3. Why Accenture?
- Ans.
Accenture is a global leader in consulting, technology, and outsourcing services with a strong reputation for innovation and client success.
Global presence with diverse range of clients and projects
Strong reputation for innovation and cutting-edge technology solutions
Opportunities for professional growth and development
Collaborative and inclusive work culture
Track record of successful client engagements and impactful r
- Q4. Why MBA?
- Ans.
An MBA will provide me with the necessary skills and knowledge to excel in the business world.
Acquire a strong foundation in business principles and practices
Develop leadership and management skills
Expand professional network and opportunities
Enhance critical thinking and problem-solving abilities
- Q5. Greatest achievement at ISB?
- Ans.
My greatest achievement at ISB was leading a team to win the national case competition.
Led a team to victory in a national case competition
Developed innovative solutions to complex business problems
Demonstrated strong leadership and teamwork skills
- Q6. One person you admire in your batch and why?
- Ans.
I admire Sarah in my batch for her exceptional leadership skills and dedication to helping others.
Sarah always takes the initiative to organize group study sessions and help classmates with difficult concepts.
She is a natural leader who motivates others to do their best and fosters a positive learning environment.
Sarah's dedication to academic excellence and willingness to support her peers make her a role model for me
- Q7. What did you learn from your peers at ISB?
- Ans.
I learned a lot from my peers at ISB.
I learned different perspectives and approaches to problem-solving.
I learned about new industry trends and best practices.
I learned effective communication and teamwork skills.
I learned from their experiences and success stories.
I learned how to collaborate and leverage each other's strengths.
- Q8. What do you think works for you in an interview?
- Ans.
Confidence, preparation, and showcasing relevant experience.
Researching the company and role beforehand
Practicing common interview questions
Highlighting relevant skills and experiences
Maintaining good eye contact and body language
Showing enthusiasm and confidence in responses
Interview Preparation Tips
Experience: After listening to the question I immediately analysed by asking myself some questions.
a) What can be the internal issues due to which trucks stay in the premises overtime? This could be broken down into - No preparation by the warehouse - No space in the warehouse- Shortage of tools and materials to unload Point no. 1 can be broken down into why there is no preparation by the warehouse personnel. One can analyse that there may be no communication between procurement division and store manager and the store manager may not know what he is getting, how much is he getting and at what time. The other reason can be that the truck is entering the premises with the wrong items (contrary to what was ordered) Point no. 2 can be broken down into several inventory management issues. Demand estimation, service cycle levels and are they reasonable and things like that. Basically a whole lot of OPMG from term 3. Point no. 3 is what do they use to upload. In this case the labour was fine but then there was a problem with the pallet availability. Pallets can be unavailable because they are procured from a vendor with high lead time. b) What can be the external factors that influence increase in costs? Are these the only transporters? Can we get better rates from another transporter Are these transporters getting rate of the items brought in.
Tips: Stay cool and confident. A case is just like doing a 30 min project under a
guide. Engage with him and be interested in knowing more.
Round: HR Interview
Tips: You can prepare for all the basic questions in a PI. Tell me about yourself is a standard question and should really be the clincher in any interview. Try not to talk only about studies and projects. Bring in a human and humour element to your anecdotes. And of course relevant anecdotes.
Skills:
College Name: Indian School Of Business (ISB)
Oracle Interview FAQs
Recently Viewed
REVIEWS
Fractal Analytics
No Reviews
SALARIES
Walmart
REVIEWS
Tech Mahindra
No Reviews
REVIEWS
Deloitte
No Reviews
SALARIES
Target
COMPANY BENEFITS
Fractal Analytics
No Benefits
SALARIES
Capgemini
SALARIES
Zensar Technologies
SALARIES
IQVIA
SALARIES
Lowe's
Tell us how to improve this page.
Oracle Interviews By Designations
- Oracle Software Developer Interview Questions
- Oracle Application Developer Interview Questions
- Oracle Software Engineer Interview Questions
- Oracle Senior Software Engineer Interview Questions
- Oracle Member Technical Staff Interview Questions
- Oracle Applications Engineer Interview Questions
- Oracle Senior Consultant Interview Questions
- Oracle Associate Consultant Interview Questions
- Show more
Interview Questions for Popular Designations
- Technical Lead Interview Questions
- Technical Specialist Interview Questions
- Associate Technical Consultant Interview Questions
- Member Technical Staff Interview Questions
- Technical Analyst Interview Questions
- Technical Architect Interview Questions
- Senior Technical Lead Interview Questions
- Senior Technical Consultant Interview Questions
- Show more
Oracle Technical Consultant Interview Process
based on 2 interviews
Interview experience
Technical Consultant Interview Questions from Similar Companies
Fast track your campus placements
Oracle Technical Consultant Reviews and Ratings
based on 9 reviews
Rating in categories
Hyderabad / Secunderabad,
Chennai
+15-10 Yrs
Not Disclosed
|
Senior Software Engineer
2.4k
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Senior Consultant
2.1k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Principal Consultant
2k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Member of Technical Staff
1.8k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Application Engineer
1.4k
salaries
| ₹0 L/yr - ₹0 L/yr |
SAP
MongoDB
Salesforce
IBM
- Home >
- Interviews >
- Oracle Interview Questions >
- Oracle Technical Consultant Interview Questions
