Premium Employer

i

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

Infosys Verified Tick

Compare button icon Compare button icon Compare
3.7

based on 36.9k Reviews

Filter interviews by

Infosys Oracle Application Technical Consultant Interview Questions and Answers for Experienced

Updated 14 Jun 2024

Infosys Oracle Application Technical Consultant Interview Experiences for Experienced

1 interview found

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
Not Selected
Round 1 - Technical 

(2 Questions)

  • Q1. Oracle forms trigger
  • Q2. Report triggers and sequence

Interview questions from similar companies

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

I applied via Naukri.com and was interviewed in Aug 2024. There was 1 interview round.

Round 1 - Technical 

(5 Questions)

  • Q1. What is O to c cycle?
  • Ans. 

    Order to Cash (O to C) cycle is the process of receiving and fulfilling customer orders.

    • Includes order entry, order processing, order fulfillment, and invoicing

    • Starts with customer placing an order and ends with payment received

    • Involves multiple departments like sales, warehouse, and finance

    • Ensures timely delivery of products/services to customers

  • Answered by AI
  • Q2. What is IRSO ? and their setup and configuration.
  • Ans. 

    IRSO stands for Inventory Replenishment Supply Order. It is used in Oracle SCM for managing inventory replenishment orders.

    • IRSO is used to automatically generate supply orders based on inventory levels and demand forecasts.

    • Setup involves defining replenishment rules, lead times, and order policies.

    • Configuration includes setting up approval workflows, notification rules, and integration with other SCM modules.

    • Example: S...

  • Answered by AI
  • Q3. Explain Dropshipment process ?
  • Ans. 

    Dropshipment process involves direct shipment from supplier to customer without passing through the retailer.

    • Supplier ships the product directly to the customer on behalf of the retailer

    • Retailer acts as an intermediary between supplier and customer

    • Retailer does not handle the physical product

    • Retailer earns a commission for facilitating the transaction

  • Answered by AI
  • Q4. What are the key functionality of inventory
  • Ans. 

    Key functionalities of inventory include tracking stock levels, managing reorder points, and optimizing inventory turnover.

    • Tracking stock levels to ensure availability of products

    • Managing reorder points to avoid stockouts

    • Optimizing inventory turnover to reduce carrying costs

    • Implementing barcode scanning for accurate inventory counts

    • Utilizing demand forecasting to plan inventory levels

  • Answered by AI
  • Q5. Can you explain how the bill to and ship to addresses are populate in the sales order form ??
  • Ans. 

    The bill to and ship to addresses in the sales order form are populated based on the customer's default addresses and any overrides specified during order entry.

    • Bill to address is typically the default address associated with the customer account

    • Ship to address can be the same as bill to or a different address specified during order entry

    • Users can override the default addresses for specific orders if needed

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Dataguard architecture
  • Q2. Rman backup and restoration
Round 2 - HR 

(1 Question)

  • Q1. Why you join inm
  • Ans. 

    I joined inm because of the company's reputation for innovation and growth in the tech industry.

    • Attracted to company's reputation for innovation

    • Excited about opportunities for growth in tech industry

    • Impressed by company culture and values

  • Answered by AI
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
-

I applied via Naukri.com and was interviewed in Mar 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. How would you monitor a db performance with OEM AWR report?
  • Ans. 

    Monitoring db performance using OEM AWR report

    • Access OEM console and navigate to Performance tab

    • Select AWR report option to generate a report

    • Analyze the report for key performance metrics like CPU usage, memory utilization, I/O stats

    • Identify any performance bottlenecks and take necessary actions to optimize db performance

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Accenture Oracle Database Administrator interview:
  • Dataguard
  • BACKUP & recovery
  • ASM
  • Oracle RAC
Interview preparation tips for other job seekers - Be strong with basic knowledge of the how to configure, install, patch, migrate and upgrade database.. if you have mentioned RAC and performance tuning they expect you to answer more and dive deep into scenarios. Dataguard, ASM they would expect to have knowledge in these areas as well.. Moreover, have a throughout preparation based on scenarios, as they expect you to answer in scenarios where you don’t have OEM as a monitoring tool.. and if things are manually done..
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Company Website and was interviewed in Jan 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Mainly they focus on PLSQL query .
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(1 Question)

  • Q1. 1) Learnings from my current company 2)why HCL 3) Current and expected Salary.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
Selected Selected
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. Explain about DataGuard
  • Ans. 

    DataGuard is an Oracle feature that provides high availability and disaster recovery solutions for databases.

    • DataGuard creates and maintains a standby database that can take over in case of a primary database failure.

    • It uses redo apply technology to keep the standby database synchronized with the primary database.

    • DataGuard can be configured in different modes such as maximum availability, maximum performance, and maxim...

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. Why do you want to switch from your career

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

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

Round 1 - One-on-one 

(4 Questions)

  • Q1. Previous Experience qs
  • Q2. Implementation Experience is asked
  • Q3. Process Improvement Implementation
  • Ans. 

    Process improvement implementation involves analyzing current processes, identifying areas for improvement, implementing changes, and monitoring results.

    • Analyze current processes to identify inefficiencies

    • Develop a plan for improvement with clear objectives and timelines

    • Implement changes gradually to minimize disruption

    • Monitor results and adjust as needed to ensure success

  • Answered by AI
  • Q4. Automation Qs is asked
Round 2 - Technical 

(3 Questions)

  • Q1. Implementation qs is Asked
  • Q2. Automation Qs is asked
  • Q3. Hobby and Personal qs like how many people in Family

Interview Preparation Tips

Interview preparation tips for other job seekers - Great Company
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Client Interview 

(2 Questions)

  • Q1. Communication with client
  • Q2. How frequently communication with client
  • Ans. 

    Frequent communication with the client is crucial for successful project delivery.

    • Regular status updates should be provided to the client.

    • Communication should be maintained through various channels such as emails, phone calls, and meetings.

    • Client feedback should be taken into consideration and addressed promptly.

    • Communication frequency may vary depending on the project phase and client requirements.

    • Effective communicat...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared well before attended the interview
Functional aspects and pricing options flexibility of work
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Oct 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - HR 

(2 Questions)

  • Q1. 1)Tell me about your self 2) Your educational background
  • Q2. 3) why it field 4) which certification you have
Round 3 - Aptitude Test 

Quants, logic and English including puzzles and some gk based puzzles as well

Interview Preparation Tips

Interview preparation tips for other job seekers - Be cool while interview don't get afraid they will hire you

Infosys Interview FAQs

How many rounds are there in Infosys Oracle Application Technical Consultant interview for experienced candidates?
Infosys interview process for experienced candidates usually has 1 rounds. The most common rounds in the Infosys interview process for experienced candidates are Technical.
What are the top questions asked in Infosys Oracle Application Technical Consultant interview for experienced candidates?

Some of the top questions asked at the Infosys Oracle Application Technical Consultant interview for experienced candidates -

  1. Report triggers and seque...read more
  2. Oracle forms trig...read more

Tell us how to improve this page.

Join Infosys Creating the next opportunity for people, businesses & communities

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.1k Interviews
Accenture Interview Questions
3.9
 • 7.9k Interviews
Wipro Interview Questions
3.7
 • 5.5k Interviews
Cognizant Interview Questions
3.8
 • 5.4k Interviews
Capgemini Interview Questions
3.8
 • 4.7k Interviews
Tech Mahindra Interview Questions
3.6
 • 3.7k Interviews
HCLTech Interview Questions
3.5
 • 3.7k Interviews
Genpact Interview Questions
3.9
 • 3k Interviews
LTIMindtree Interview Questions
3.9
 • 2.8k Interviews
IBM Interview Questions
4.1
 • 2.3k Interviews
View all
Infosys Oracle Application Technical Consultant Salary
based on 44 salaries
₹4.2 L/yr - ₹11.8 L/yr
11% less than the average Oracle Application Technical Consultant Salary in India
View more details

Infosys Oracle Application Technical Consultant Reviews and Ratings

based on 3 reviews

3.1/5

Rating in categories

3.1

Skill development

4.0

Work-Life balance

3.1

Salary & Benefits

4.9

Job Security

3.1

Company culture

3.1

Promotions/Appraisal

3.1

Work Satisfaction

Explore 3 Reviews and Ratings
Technology Analyst
56.3k salaries
unlock blur

₹3 L/yr - ₹11 L/yr

Senior Systems Engineer
49.4k salaries
unlock blur

₹2.8 L/yr - ₹9.2 L/yr

System Engineer
38.9k salaries
unlock blur

₹2.5 L/yr - ₹5.5 L/yr

Technical Lead
30.7k salaries
unlock blur

₹5.2 L/yr - ₹19.5 L/yr

Senior Associate Consultant
27.1k salaries
unlock blur

₹6.2 L/yr - ₹17 L/yr

Explore more salaries
Compare Infosys with

TCS

3.7
Compare

Wipro

3.7
Compare

Cognizant

3.8
Compare

Accenture

3.9
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview