Upload Button Icon Add office photos
Premium Employer

i

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

NTT Data

Compare button icon Compare button icon Compare
3.9

based on 3.6k Reviews

Filter interviews by

NTT Data Lead Consultant Interview Questions and Answers

Updated 16 May 2022

NTT Data Lead Consultant Interview Experiences

1 interview found

Round 1 - Technical 

(2 Questions)

  • Q1. SAP PP technical related
  • Q2. Willing to Travel and are you ok to work any kind of project?
Round 2 - HR 

(1 Question)

  • Q1. Salary Expectation and location preference.

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview was good as the interviewers made me comfortable. Asked relevant questions.

Lead Consultant Jobs at NTT Data

View all

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(3 Questions)

  • Q1. Tell me about the project you have worked recently?
  • Q2. Any challenges faced recently?
  • Q3. What is difference between union and union all
  • Ans. 

    UNION combines the result sets of two or more SELECT statements, while UNION ALL does the same but includes duplicate rows.

    • UNION removes duplicate rows from the result set, while UNION ALL includes all rows

    • UNION is slower than UNION ALL because it has to perform a distinct operation

    • UNION requires that all SELECT statements have the same number of columns with compatible data types

  • Answered by AI
Round 2 - Technical 

(2 Questions)

  • Q1. How do you approach performance tuning of a stored procedure?
  • Ans. 

    I approach performance tuning of a stored procedure by analyzing query execution plans, optimizing indexes, and rewriting inefficient code.

    • Analyze query execution plans to identify bottlenecks

    • Optimize indexes to improve data retrieval speed

    • Rewrite inefficient code to reduce unnecessary processing

    • Consider parameter sniffing and data distribution for optimal performance

  • Answered by AI
  • Q2. What is recursive CTE
  • Ans. 

    A recursive CTE (Common Table Expression) is a query that references itself within the query definition.

    • Allows for hierarchical data querying

    • Uses a base case and recursive member in the query

    • Example: querying a table with parent-child relationship using recursive CTE

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. Are you flexible on timing

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep it simple and straightforward

Skills evaluated in this interview

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

I was interviewed in Jun 2024.

Round 1 - Technical 

(2 Questions)

  • Q1. He asked Java related questions and java 8 coding questions.
  • Q2. Coding questions
Round 2 - Technical 

(1 Question)

  • Q1. Project related questions and asked to build api's from the scratch.
Round 3 - Technical 

(1 Question)

  • Q1. Java and projects questions
Round 4 - Technical 

(1 Question)

  • Q1. Java and project questions

Lead Consultant Interview Questions & Answers

UST user image Naeem Majjid Shikalgar

posted on 19 Oct 2024

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 Oct 2023. There were 2 interview rounds.

Round 1 - Technical 

(3 Questions)

  • Q1. Tell me the sap journey
  • Ans. 

    The SAP journey involves implementing, customizing, and optimizing SAP software to meet business needs.

    • Start with understanding the business requirements and goals

    • Implement SAP software modules based on the requirements

    • Customize the software to fit the specific needs of the organization

    • Optimize the system for efficiency and effectiveness

    • Provide training and support to users for successful adoption

  • Answered by AI
  • Q2. Subcontracting process
  • Q3. Consignment process
Round 2 - HR 

(1 Question)

  • Q1. Salary expectations
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Architecture , basic concepts, scripting
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 Oct 2022. There were 4 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 - One-on-one 

(2 Questions)

  • Q1. Your Domain technical questions based on your experience
  • Q2. Fundamentals should be strong
Round 3 - HR 

(2 Questions)

  • Q1. What challenges did you face in your last project?
  • Q2. When you see a problem what’s your first steps towards problem?
Round 4 - Aptitude Test 

Analytical skills should be strong

Interview Preparation Tips

Interview preparation tips for other job seekers - Brush up your fundamental and enhance your analytical skills. Play video games solve puzzles
Round 1 - HR 

(6 Questions)

  • Q1. What are your salary expectations?
  • Q2. Share details of your previous job.
  • Q3. Why are you looking for a change?
  • Q4. Where do you see yourself in 5 years?
  • Q5. What are your strengths and weaknesses?
  • Q6. Tell me about yourself.
Round 2 - Technical 

(1 Question)

  • Q1. Questions relevant to Whatever knowledge you gained in your professional career
Round 3 - HR 

(4 Questions)

  • Q1. Share details of your previous job.
  • Q2. Why should we hire you?
  • Q3. What are your strengths and weaknesses?
  • Q4. Tell me about yourself.

Interview Preparation Tips

Interview preparation tips for other job seekers - Get the clarity on email about your roles and responsibilities. Lot of confusion internal management and leaders have.

I applied via Approached by Company and was interviewed in Dec 2021. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. PEGA technical questions
  • Q2. PEGA SLA configuration
  • Ans. 

    PEGA SLA configuration is used to define service level agreements for cases in PEGA.

    • SLA rules can be configured to define the time frame for case resolution.

    • SLA can be paused or resumed based on certain conditions.

    • SLA can be escalated to higher authorities if the case is not resolved within the defined time frame.

    • SLA can be configured to send notifications to stakeholders when the case is approaching the deadline.

    • SLA c...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Please go through the PEGA technical questions
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Solid principles with real time examples
  • Ans. 

    Solid principles are a set of design principles for writing clean, maintainable code.

    • Single Responsibility Principle - A class should have only one reason to change. Example: A class that handles user authentication should not also handle database operations.

    • Open/Closed Principle - Classes should be open for extension but closed for modification. Example: Using interfaces to allow for different implementations without ...

  • Answered by AI
  • Q2. Design patterns and its use
  • Ans. 

    Design patterns are reusable solutions to common problems in software design.

    • Design patterns help in creating flexible, maintainable, and scalable software.

    • Examples of design patterns include Singleton, Factory, Observer, and Strategy.

    • They provide a common language for developers to communicate and understand each other's code.

    • Design patterns can be categorized into creational, structural, and behavioral patterns.

  • Answered by AI

Skills evaluated in this interview

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

I applied via Naukri.com and was interviewed in Sep 2024. There were 3 interview rounds.

Round 1 - One-on-one 

(1 Question)

  • Q1. Verbal technical round related to your skills
Round 2 - Coding Test 

Mostly array problems and other coding questions related to your stack

Round 3 - HR 

(1 Question)

  • Q1. General questions and salary discussion

NTT Data Interview FAQs

How many rounds are there in NTT Data Lead Consultant interview?
NTT Data interview process usually has 2 rounds. The most common rounds in the NTT Data interview process are Technical and HR.

Tell us how to improve this page.

NTT Data Lead Consultant Salary
based on 83 salaries
₹14.8 L/yr - ₹30 L/yr
7% more than the average Lead Consultant Salary in India
View more details

NTT Data Lead Consultant Reviews and Ratings

based on 3 reviews

4.2/5

Rating in categories

4.0

Skill development

4.2

Work-Life balance

3.4

Salary & Benefits

4.5

Job Security

4.0

Company culture

3.2

Promotions/Appraisal

3.8

Work Satisfaction

Explore 3 Reviews and Ratings
ServicenowITSM/ITOM Lead consultant

Hyderabad / Secunderabad

5-10 Yrs

Not Disclosed

Digital Solution Cnslt. Lead Consultant

Bangalore / Bengaluru

4-10 Yrs

Not Disclosed

Explore more jobs
Software Engineer
932 salaries
unlock blur

₹2.8 L/yr - ₹11 L/yr

Senior Associate
767 salaries
unlock blur

₹1.1 L/yr - ₹7.5 L/yr

Network Engineer
647 salaries
unlock blur

₹1.8 L/yr - ₹10 L/yr

Software Developer
615 salaries
unlock blur

₹2.5 L/yr - ₹13 L/yr

Senior Software Engineer
512 salaries
unlock blur

₹6.5 L/yr - ₹24 L/yr

Explore more salaries
Compare NTT Data with

Tata Communications

4.1
Compare

Bharti Airtel

4.0
Compare

Reliance Communications

4.0
Compare

Vodafone Idea

4.1
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