Upload Button Icon Add office photos
Engaged Employer

i

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

LTIMindtree Verified Tick

Compare button icon Compare button icon Compare
3.8

based on 20.1k Reviews

Filter interviews by

LTIMindtree Oracle Technical Consultant Interview Questions and Answers

Updated 29 May 2024

LTIMindtree Oracle Technical Consultant Interview Experiences

1 interview found

Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. How does an interface works?
  • Ans. 

    An interface acts as a bridge between two systems, allowing them to communicate and exchange data.

    • Interfaces define a set of methods that a class must implement.

    • They provide a way for different systems to interact with each other.

    • Interfaces can be used to achieve abstraction and polymorphism in programming.

    • Example: JDBC (Java Database Connectivity) provides an interface for connecting Java applications to databases.

  • Answered by AI
  • Q2. How does an HCM Extract work?
  • Ans. 

    HCM Extract is a tool in Oracle HCM Cloud that allows users to extract and transfer data from the system.

    • HCM Extracts are used to extract data from Oracle HCM Cloud for reporting, analysis, or integration purposes.

    • Users can define the data to be extracted, the format of the output, and the delivery method.

    • HCM Extracts can be scheduled to run at specific times or triggered based on certain events.

    • Extracted data can be t...

  • Answered by AI

Interview questions from similar companies

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

I applied via Campus Placement and was interviewed in Sep 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Workex related questions
  • Q2. Case related to clients
Round 2 - Technical 

(1 Question)

  • Q1. Workex pointers from previous company
  • Ans. 

    Workex pointers from previous company

    • Highlight key projects you worked on

    • Discuss your role and responsibilities in those projects

    • Mention any challenges faced and how you overcame them

    • Talk about any innovative solutions you implemented

    • Share any positive feedback or recognition received

  • Answered by AI
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.

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

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 

(2 Questions)

  • Q1. Pl/SQL collection and anonymous blocks
  • Q2. Module specific Table names

Interview Preparation Tips

Interview preparation tips for other job seekers - Study basics first and then advance. Try to learn module specific questions as well like table names.

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

Round 1 - One-on-one 

(1 Question)

  • Q1. O2C cycle, P2P cycle, Reports. Pl/SQL, SQL, Unix
Round 2 - HR 

(1 Question)

  • Q1. Basic Salary and location discussion

Interview Preparation Tips

Interview preparation tips for other job seekers - Just go through the skills that you have mentioned, be open minded about learning new things and be honest about something you have not worked on.

I applied via Campus Placement and was interviewed before Aug 2021. There were 3 interview rounds.

Round 1 - Aptitude Test 

You get questions from moderate to high level

Round 2 - Coding Test 

Pseudo codes in moderate and high level

Round 3 - One-on-one 

(2 Questions)

  • Q1. Tell me about yourself and your project.
  • Q2. Oops concepts, java features, coding, embedded systems, new technologies like AI and ML

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and know basics of everything what you write in your resume.
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Oracle receivables core setup
  • Q2. Oracle bill in advance accounting entries
  • Ans. 

    Oracle bill in advance accounting entries

    • When billing in advance, recognize revenue over the service period

    • Debit Accounts Receivable and credit Unearned Revenue upon billing

    • Recognize revenue by debiting Unearned Revenue and crediting Revenue over time

    • Adjust entries as revenue is earned

  • Answered by AI
Round 2 - scheduled 

(1 Question)

  • Q1. Interview is scheduled

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. How you will find that some user SQL running slow without discussing with user?
  • Q2. How you will patch specific db components to reduce downtime?
  • Ans. 

    To patch specific db components to reduce downtime, follow these steps:

    • Identify the specific components that need to be patched

    • Plan the patching process during a scheduled maintenance window

    • Backup the database before applying patches

    • Apply patches to the specific components one by one

    • Test the patched components to ensure they are functioning correctly

    • Monitor the database for any issues post-patching

  • Answered by AI
Round 2 - HR 

(2 Questions)

  • Q1. Why you have so many hopping in your resume?
  • Q2. How you will rate yourself as an dba?

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared technically.
Be loyal in interview , if you don't know just tell
Try to be solution oriented person
Give genuine real time faced issues
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
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. What is the role of Oracle DBA
  • Ans. 

    The role of an Oracle DBA is to manage and maintain Oracle databases to ensure they are secure, efficient, and reliable.

    • Installing and upgrading Oracle software

    • Configuring and monitoring database performance

    • Backup and recovery of data

    • Troubleshooting and resolving database issues

    • Implementing security measures to protect data

    • Managing users and permissions

  • Answered by AI

LTIMindtree Interview FAQs

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

Some of the top questions asked at the LTIMindtree Oracle Technical Consultant interview -

  1. How does an HCM Extract wo...read more
  2. How does an interface wor...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.3k Interviews
Accenture Interview Questions
3.9
 • 8k Interviews
Infosys Interview Questions
3.7
 • 7.5k Interviews
Wipro Interview Questions
3.7
 • 5.5k Interviews
Cognizant Interview Questions
3.8
 • 5.5k Interviews
Capgemini Interview Questions
3.8
 • 4.8k Interviews
Tech Mahindra Interview Questions
3.6
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.7k Interviews
Genpact Interview Questions
3.9
 • 3k Interviews
IBM Interview Questions
4.1
 • 2.4k Interviews
View all
LTIMindtree Oracle Technical Consultant Salary
based on 15 salaries
₹3.7 L/yr - ₹8.8 L/yr
25% less than the average Oracle Technical Consultant Salary in India
View more details

LTIMindtree Oracle Technical Consultant Reviews and Ratings

based on 2 reviews

4.0/5

Rating in categories

4.0

Skill development

4.0

Work-life balance

3.6

Salary

3.0

Job security

4.5

Company culture

4.2

Promotions

4.2

Work satisfaction

Explore 2 Reviews and Ratings
Senior Software Engineer
21.2k salaries
unlock blur

₹4.7 L/yr - ₹18.5 L/yr

Software Engineer
16.2k salaries
unlock blur

₹2 L/yr - ₹10 L/yr

Module Lead
6.7k salaries
unlock blur

₹7 L/yr - ₹25 L/yr

Technical Lead
6.5k salaries
unlock blur

₹9.3 L/yr - ₹30 L/yr

Senior Engineer
4.4k salaries
unlock blur

₹4.2 L/yr - ₹16.2 L/yr

Explore more salaries
Compare LTIMindtree with

Cognizant

3.8
Compare

Capgemini

3.8
Compare

Accenture

3.9
Compare

TCS

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