Upload Button Icon Add office photos
Engaged Employer

i

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

Mastek Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Mastek Oracle Functional Consultant Interview Questions and Answers

Updated 1 Jul 2024

Mastek Oracle Functional Consultant Interview Experiences

1 interview found

Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Group Discussion 

The Group discussion was good but the company isn't punctual the timing of company's arival was 8:45 and they arrived at 10:30 and then they started the group discussion at 12:30-01:00 previousliy they have mentioned only 3 rounds 1st-GD 2nd-L1 Interview and 3rd-L3 Interview
but suddenly at the day of interviews they added additional round of Apptitude round after Group Discussion of 15 minutes they announced the result at 02:15

Round 2 - Aptitude Test 

By adding this round suddenly they started the test around 3:30 and after the test they anounced the test results by 4:50

Round 3 - One-on-one 

(4 Questions)

  • Q1. They ask questions from the resume
  • Q2. About your project
  • Q3. About internships
  • Q4. All the skills you have mentioned in the resume
Round 4 - 7 people pannel 

(3 Questions)

  • Q1. This was the wierdest round i've seen first they ask tell me somthing which is not in your resume
  • Q2. And then after 1 2 questions like this they ask questions like do you see the remote tell me 10 uses of the remote apart from changing channels adjusting volumes
  • Q3. And if you give them around 7-8 right uses of remote then they give you toughest they ask that give me 20 uses of empty water bottle or 50 uses of water bottle

Interview Preparation Tips

Interview preparation tips for other job seekers - It was around 1:30 at night we were 18 candidates who was shortlisted for different roles and for function consultant there were 11 candidates from which they hired only 1 just 1 candidate and out of 18 they selected 9 waiting for the company from morning to the last face at 1 30 at night and they selected only 9 candidates out from which there was only 1 who's job role is functional consultant they rejected 10 candidates and the fact is that there was total of 400+ opening in the company (we were 150+ students who were there for campus interview out of which we 18 were selected for last interview and out of 11 they selected only 1) and there were 400+ opening

Interview questions from similar companies

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

I applied via Referral and was interviewed in Nov 2023. There were 3 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Salary and past experience discussion
Round 2 - Technical 

(1 Question)

  • Q1. Sap fi implementation and support questions
Round 3 - Behavioral 

(1 Question)

  • Q1. Asked about past work experience
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Dec 2023. There were 3 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Forex transaction journal entry
  • Q2. Golden rules of accounting
  • Ans. 

    The golden rules of accounting are basic principles that guide the process of recording financial transactions.

    • The golden rules include: Debit what comes in, Credit what goes out; Debit the receiver, Credit the giver; Debit expenses and losses, Credit income and gains.

    • These rules ensure that the accounting equation (Assets = Liabilities + Equity) remains balanced.

    • For example, when a company receives cash from a custome...

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

(2 Questions)

  • Q1. Earlier company experience related quetion
  • Q2. Details on different audits
Round 3 - Technical 

(2 Questions)

  • Q1. Bond valuation entry
  • Q2. Accrual entry
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 Resume tips
Round 2 - Technical 

(2 Questions)

  • Q1. Domain Knowledge will be checked
  • Q2. Project details will be asked
Round 3 - Aptitude Test 

Total work expericne will be asked

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepared more and really work hard. have some practice in Application
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed before Jan 2024.

Round 1 - Aptitude Test 

Easy mostly simple maths related to ratios, percentages

Round 2 - Technical 

(1 Question)

  • Q1. Oops, basic java programs, shell scripting
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
-
Result
Selected Selected

I was interviewed before Aug 2023.

Round 1 - Technical 

(2 Questions)

  • Q1. Pricing procedure related
  • Q2. Output determination
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Dec 2022. There were 3 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 Resume tips
Round 2 - HR 

(1 Question)

  • Q1. Basic question about the previous job profile.
Round 3 - One-on-one 

(3 Questions)

  • Q1. Detailed question on resume
  • Q2. Most of the questions on procure to pay process
  • Q3. A little bit on sql queries

Interview Preparation Tips

Interview preparation tips for other job seekers - Go through your resume, do not add any irrelevant data.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Oct 2024. There were 2 interview rounds.

Round 1 - HR 

(2 Questions)

  • Q1. Resume overview
  • Q2. Expected ctc and location
  • Ans. 

    Expected ctc and location

    • Research typical salary range for Functional Consultants in the industry

    • Consider cost of living in the desired location

    • Negotiate based on your experience and skills

  • Answered by AI
Round 2 - Technical 

(2 Questions)

  • Q1. Accounting questions
  • Q2. Previous work experience questions

Interview Questionnaire 

2 Questions

  • Q1. Explain DB Architecture
  • Ans. 

    DB Architecture refers to the design and structure of a database system.

    • It includes the physical and logical components of the database.

    • Physical components include storage devices, memory, and processing units.

    • Logical components include tables, views, indexes, and relationships.

    • DB architecture can be centralized, distributed, or cloud-based.

    • It is important for scalability, performance, and security of the database syst

  • Answered by AI
  • Q2. Explain Index
  • Ans. 

    An index is a data structure that improves the speed of data retrieval operations on a database table.

    • Indexes are created on one or more columns of a table.

    • They allow the database to quickly find the rows that match a search condition.

    • Indexes can be unique or non-unique.

    • Unique indexes ensure that no two rows have the same value in the indexed columns.

    • Non-unique indexes allow duplicate values in the indexed columns.

    • Inde...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared with basics of SQL
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Tell me about yourself
  • Ans. 

    Experienced Functional Consultant with a background in business analysis and process improvement.

    • Over 5 years of experience in implementing ERP systems and optimizing business processes

    • Skilled in conducting requirements gathering, gap analysis, and user training

    • Strong communication and problem-solving skills

    • Certified in relevant software applications such as SAP or Oracle

  • Answered by AI
  • Q2. Your Challenges
Contribute & help others!
anonymous
You can choose to be anonymous

Mastek Interview FAQs

How many rounds are there in Mastek Oracle Functional Consultant interview?
Mastek interview process usually has 4 rounds. The most common rounds in the Mastek interview process are Group Discussion, Aptitude Test and One-on-one Round.
What are the top questions asked in Mastek Oracle Functional Consultant interview?

Some of the top questions asked at the Mastek Oracle Functional Consultant interview -

  1. and if you give them around 7-8 right uses of remote then they give you toughe...read more
  2. and then after 1 2 questions like this they ask questions like do you see the r...read more
  3. they ask questions from the res...read more

Recently Viewed

JOBS

Browse jobs

Discover jobs you love

COMPANY BENEFITS

KNR Constructions

20 benefits

COMPANY BENEFITS

IRB Infrastructure

60 benefits

COMPANY BENEFITS

Dilip Buildcon

304 benefits

COMPANY BENEFITS

Dilip Buildcon

304 benefits

INTERVIEWS

Loadshare Networks

No Interviews

INTERVIEWS

Loadshare Networks

10 top interview questions

SALARIES

Trane Technologies

INTERVIEWS

Trane Technologies

10 top interview questions

INTERVIEWS

Boston Scientific

No Interviews

Tell us how to improve this page.

Mastek Oracle Functional Consultant Interview Process

based on 3 interviews

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.5k Interviews
Infosys Interview Questions
3.6
 • 7.7k Interviews
Wipro Interview Questions
3.7
 • 5.7k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.9k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
LTIMindtree Interview Questions
3.8
 • 3k Interviews
Cyient Interview Questions
3.6
 • 285 Interviews
NeoSOFT Interview Questions
3.9
 • 264 Interviews
View all
Mastek Oracle Functional Consultant Salary
based on 61 salaries
₹3.2 L/yr - ₹10 L/yr
29% less than the average Oracle Functional Consultant Salary in India
View more details

Mastek Oracle Functional Consultant Reviews and Ratings

based on 10 reviews

4.0/5

Rating in categories

3.7

Skill development

3.3

Work-life balance

3.3

Salary

4.0

Job security

3.6

Company culture

3.2

Promotions

3.8

Work satisfaction

Explore 10 Reviews and Ratings
Senior Software Engineer
548 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
396 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Consultant
269 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Specialist
266 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Consultant 1
191 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Mastek with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

HCLTech

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent