7 Mastek Oracle Functional Consultant Interview Questions & Answers | Complete Prep Guide 2025

Mastek Oracle Functional Consultant Interview Experiences

1 interview found

Oracle Functional Consultant Interview Questions & Answers

Anonymous

posted on 1 Jul 2024

Interview experience

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

Add your answer

Q2. About your project

Add your answer

Q3. About internships

Add your answer

Q4. All the skills you have mentioned in the resume

Add your answer

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

Add your answer

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

Add your answer

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

Add your answer

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

Top trending discussions

View All

Salary Discussions, Hike & Promotions

I have got an offer of 34 LPA from TCS and Capgemini . I have 11 years of experience , Azure Developer. Can you please guide / suggest which company should I join . I am confused since both are offering the s... read more

Got a question about Mastek?

Ask anonymously on communities.

Interview questions from similar companies

Functional Consultant Interview Questions & Answers

ITC Infotech

Anonymous

posted on 30 Dec 2023

Interview experience

Excellent

Difficulty level

Moderate

Process Duration

Less than 2 weeks

Result

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

Add your answer

Round 2 - Technical

(1 Question)

Q1. Sap fi implementation and support questions

Add your answer

Round 3 - Behavioral

(1 Question)

Q1. Asked about past work experience

Add your answer

Functional Consultant Interview Questions & Answers

LTIMindtree

Anonymous

posted on 20 Dec 2024

Interview experience

Good

Difficulty level

Moderate

Process Duration

Less than 2 weeks

Result

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

Add your answer

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

Add your answer

Round 2 - One-on-one

(2 Questions)

Q1. Earlier company experience related quetion

Add your answer

Q2. Details on different audits

Add your answer

Round 3 - Technical

(2 Questions)

Q1. Bond valuation entry

Add your answer

Q2. Accrual entry

Add your answer

Functional Consultant Interview Questions & Answers

Wipro

Anonymous

posted on 6 Oct 2022

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

Add your answer

Q2. Project details will be asked

Add your answer

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

Functional Consultant Interview Questions & Answers

LTIMindtree

Anonymous

posted on 17 Jan 2025

Interview experience

Excellent

Difficulty level

Easy

Process Duration

Less than 2 weeks

Result

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

Add your answer

Functional Consultant Interview Questions & Answers

LTIMindtree

Anonymous

posted on 29 Aug 2024

Interview experience

Average

Difficulty level

Moderate

Process Duration

Result

Selected

I was interviewed before Aug 2023.

Round 1 - Technical

(2 Questions)

Q1. Pricing procedure related

Add your answer

Q2. Output determination

Add your answer

Functional Consultant Interview Questions & Answers

LTIMindtree

Anonymous

posted on 7 Dec 2023

Interview experience

Good

Difficulty level

Moderate

Process Duration

2-4 weeks

Result

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.

Add your answer

Round 3 - One-on-one

(3 Questions)

Q1. Detailed question on resume

Add your answer

Q2. Most of the questions on procure to pay process

Add your answer

Q3. A little bit on sql queries

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Go through your resume, do not add any irrelevant data.

Functional Consultant Interview Questions & Answers

LTIMindtree

Anonymous

posted on 19 Nov 2024

Interview experience

Good

Difficulty level

Moderate

Process Duration

2-4 weeks

Result

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

Add your answer

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

Add your answer

Round 2 - Technical

(2 Questions)

Q1. Accounting questions

Add your answer

Q2. Previous work experience questions

Add your answer

Functional Consultant Interview Questions & Answers

Infosys

Anonymous

posted on 4 Oct 2021

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

Add your answer

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

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared with basics of SQL

Functional Consultant Interview Questions & Answers

HCLTech

Anonymous

posted on 5 Jul 2024

Interview experience

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

Add your answer

Q2. Your Challenges

Add your answer

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 -

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

Tell us how to improve this page.

Mastek Interviews By Designations

Interview Questions for Popular Designations

Mastek Oracle Functional Consultant Interview Process

based on 3 interviews

Interview experience

Good

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

Hexaware Technologies Interview Questions

3.6

• 723 Interviews

Persistent Systems Interview Questions

3.5

• 615 Interviews

Cyient Interview Questions

3.6

• 285 Interviews

NeoSOFT Interview Questions

3.9

• 264 Interviews

View all

Parul Institute of Management and Research, Vadodara Placement Questions

4 Interviews

St Francis Institute of Technology, Mumbai Placement Questions

2 Interviews

Mumbai University Placement Questions

1 Interview

Malviya National Institute of Technology (NIT), Jaipur Placement Questions

1 Interview

Maulana Azad National Institute of Technology (NIT), Bhopal Placement Questions

1 Interview

Symbiosis Institute of Business Management (SIBM), Pune Placement Questions

1 Interview

A. D. Patel Institute of Technology, Vallabh Vidyanagar Placement Questions

1 Interview

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 Salaries in India

Senior Software Engineer 548 salaries	₹0 L/yr - ₹0 L/yr
Software Engineer 396 salaries	₹0 L/yr - ₹0 L/yr
Associate Consultant 269 salaries	₹0 L/yr - ₹0 L/yr
Software Specialist 266 salaries	₹0 L/yr - ₹0 L/yr
Consultant 1 191 salaries	₹0 L/yr - ₹0 L/yr