Upload Button Icon Add office photos

Filter interviews by

Tata Group Functional Consultant Interview Questions and Answers

Updated 15 Jul 2022

Tata Group Functional Consultant Interview Experiences

1 interview found

I applied via Referral and was interviewed before Jul 2021. There was 1 interview round.

Round 1 - One-on-one 

(5 Questions)

  • Q1. Oracle Forms Sequence of Triggers
  • Ans. 

    Oracle Forms triggers are executed in a specific sequence.

    • The first trigger to fire is PRE-FORM.

    • The last trigger to fire is POST-FORM.

    • Other triggers include WHEN-NEW-FORM-INSTANCE, WHEN-NEW-BLOCK-INSTANCE, etc.

    • Triggers can be used to validate data, perform calculations, and control navigation.

  • Answered by AI
  • Q2. Collections Types and Collection Types
  • Ans. 

    Collections types refer to the different types of data structures used to store and organize data in programming.

    • Some common collection types include arrays, lists, sets, and maps.

    • Arrays are a collection of elements of the same data type, accessed by index.

    • Lists are similar to arrays but can dynamically resize and have additional methods.

    • Sets are collections of unique elements with no specific order.

    • Maps are collection...

  • Answered by AI
  • Q3. Trigger Types and Mutual Lock
  • Q4. Performance Tuning and Bulk Collect
  • Q5. Package and Procedures Difference
  • Ans. 

    Packages are collections of procedures, functions, and other database objects. Procedures are a type of package that contains executable code.

    • Packages are used to group related procedures and functions together.

    • Procedures are standalone units of code that can be called from other code.

    • Packages can be used to organize code into logical groups, making it easier to manage and maintain.

    • Procedures can be used to encapsulate...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare all the Topics specially on performance tuning when ur expp is after 5 yrs

Skills evaluated in this interview

Interview questions from similar companies

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 experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Capital market and implementation
  • Q2. Client handling and requirements
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Why Accenture yur dreams n goals
  • Ans. 

    I believe Accenture aligns with my dreams and goals due to their reputation for innovation and global impact.

    • Accenture is known for its cutting-edge technology solutions, which align with my passion for innovation.

    • The global reach of Accenture provides opportunities to work on diverse projects and collaborate with talented professionals from around the world.

    • Accenture's focus on making a positive impact on society thro...

  • Answered by AI
  • Q2. Name yur client whom u have worked with

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare brd frd
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Cognitive test 

(1 Question)

  • Q1. It was a gaming round related to reasoning and decision making skill
Round 2 - One-on-one 

(3 Questions)

  • Q1. Question related to accounting terminology
  • Q2. Question related to accounting standards
  • Q3. Advanced Excel formula
Round 3 - HR 

(2 Questions)

  • Q1. Basic personal information
  • Q2. Accounting and tax related questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Stay calm and answer well, if you are doubtful for the answer atleast try it sometimes interviewer helps to understand the same
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Tell me about yourself
  • Q2. Your Challenges
Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. ALl technical queries
Round 2 - Technical 

(2 Questions)

  • Q1. Interview qtn in interview qtn
  • Q2. Interview answers in interview answers
Round 3 - HR 

(1 Question)

  • Q1. How much salary you want

Interview Preparation Tips

Interview preparation tips for other job seekers - good job it is good job it is yes yes yes yes its an good job
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Paybels module questions
Interview experience
4
Good
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Mar 2023. There were 6 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 

(1 Question)

  • Q1. Based on the resume.
Round 3 - HR 

(1 Question)

  • Q1. Overall experience & achievement.
Round 4 - HR 

(2 Questions)

  • Q1. Assignment in past
  • Q2. Communication skills
Round 5 - Case Study 

Aptitude test questions

Round 6 - HR 

(1 Question)

  • Q1. Face to face interview
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 - 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

Tata Group Interview FAQs

How many rounds are there in Tata Group Functional Consultant interview?
Tata Group interview process usually has 1 rounds. The most common rounds in the Tata Group interview process are One-on-one Round.
What are the top questions asked in Tata Group Functional Consultant interview?

Some of the top questions asked at the Tata Group Functional Consultant interview -

  1. Oracle Forms Sequence of Trigg...read more
  2. Collections Types and Collection Ty...read more
  3. Package and Procedures Differe...read more

Tell us how to improve this page.

People are getting interviews through

based on 1 Tata Group interview
Referral
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
Assistant Manager
116 salaries
unlock blur

₹3.8 L/yr - ₹15 L/yr

Manager
105 salaries
unlock blur

₹9 L/yr - ₹34 L/yr

Software Engineer
83 salaries
unlock blur

₹5 L/yr - ₹21 L/yr

Senior Manager
70 salaries
unlock blur

₹12 L/yr - ₹40 L/yr

Engineer
57 salaries
unlock blur

₹2.1 L/yr - ₹6.5 L/yr

Explore more salaries
Compare Tata Group with

Reliance Industries

4.0
Compare

Aditya Birla Group

4.1
Compare

Mahindra & Mahindra

4.1
Compare

Bharti Enterprises

3.8
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