Autocoder

NTT DATA interview questions and answers

Last updated 2026-11-19

NTT DATA is an IT services and consulting company that builds and runs enterprise systems, including ERP and cloud platforms. Fresher interviews are commonly reported to test programming and database fundamentals, with extra questions on cloud, support processes and, for some roles, enterprise software such as SAP.

This page covers those areas with worked answers. NTT DATA has not published a fixed fresher process that we can cite, so the rounds below are commonly reported. For the test side see NTT DATA coding round questions.

Work styleIT services, consulting, enterprise applications
Rounds (commonly reported)Online test, technical interview, HR interview
Frequent topicsSQL, Java or Python, cloud, ERP basics, ITIL

Rounds as commonly reported

Candidates describe an online assessment with aptitude, English and technical sections, then a technical interview and an HR interview. Technical questions follow your resume and cover programming basics, SQL and databases, networking and operating systems. For roles tied to business applications, interviewers may ask what ERP is and how you would approach learning a platform such as SAP.

Interviewers in services firms also care about communication, as you will often work with clients in other time zones. Practise explaining something technical in plain language.

Topics worth revising

Hiring status

There is no NTT DATA hiring page on this site and we hold no sourced NTT DATA statement on fresher numbers, dates or packages, so none are quoted. Check NTT DATA's own careers site for current roles and eligibility.

NTT DATA interview questions and answers: questions with worked answers

  1. 1

    What is an ERP system, and what modules does it usually have?

    easy

    ERP (enterprise resource planning) software integrates a company core processes on one platform and database so that departments share consistent data. Typical modules are finance and accounting, procurement, sales and distribution, inventory and materials management, manufacturing, human resources and payroll. Benefits are a single source of truth and process automation; costs are heavy configuration and change management. SAP and Oracle are well-known ERP vendors.

  2. 2

    What is the difference between SQL DELETE, TRUNCATE and DROP?

    easy

    DELETE removes selected rows (with a WHERE clause), is logged row by row and can be rolled back, and fires triggers. TRUNCATE removes all rows quickly, resets identity counters in many systems, and usually cannot be filtered; rollback depends on the database. DROP removes the table itself, including its structure, indexes and permissions. Use DELETE for selective removal and DROP only when the object is no longer needed.

  3. 3

    Write a query to get the top three salaries per department.

    medium

    Use DENSE_RANK partitioned by department and ordered by salary descending, then filter rank to three or less in an outer query. DENSE_RANK keeps ties without gaps, so more than three rows can be returned for a department; ROW_NUMBER would cut ties arbitrarily. See SQL joins and window questions.

    sql
    SELECT dept_id, name, salary
    FROM (
      SELECT e.*, DENSE_RANK() OVER (PARTITION BY dept_id ORDER BY salary DESC) AS rnk
      FROM Employee e
    ) t
    WHERE rnk <= 3;
  4. 4

    Explain the main cloud service models and a deployment you know.

    easy

    IaaS offers virtual machines, storage and networks; PaaS offers a managed runtime and services for deploying applications; SaaS offers a ready-made application. Describe a real deployment if you have one, such as hosting a project on a cloud virtual machine or a managed service, with the steps and any cost or security setting you handled. If you have none, describe a plan honestly.

  5. 5

    What is normalisation and when would you denormalise?

    medium

    Normalisation removes redundancy and update anomalies by splitting data into related tables following normal forms. You might denormalise for read performance, such as a reporting table that pre-joins data, accepting duplicated values and more complex updates. In transactional systems prefer normalised designs, and in analytics prefer denormalised star schemas.

  6. 6

    What is the difference between Java and Python in terms of typing and execution?

    easy

    Java is statically typed and compiled to bytecode that runs on the JVM, catching many errors at compile time and usually running faster. Python is dynamically typed and interpreted, which is quicker to write and flexible but defers type errors to run time. Both support OOP. Choose Java for large, long-lived systems and Python for scripting, data work and rapid development.

  7. 7

    What is an incident and what is a problem in IT service management?

    easy

    An incident is an unplanned interruption to a service, handled by restoring service quickly. A problem is the root cause behind one or more incidents, handled by investigation and a permanent fix. A change is a controlled modification that may be raised to fix a problem. Support roles are measured on resolution times and on reducing repeat incidents.

  8. 8

    Explain what happens during a TCP three-way handshake.

    medium

    The client sends a SYN to open a connection, the server replies SYN-ACK to acknowledge and open its side, and the client sends ACK, after which data flows. It agrees initial sequence numbers and confirms both sides can send and receive. Connection teardown uses FIN and ACK exchanges. Mention that UDP has no handshake.

  9. 9

    How would you learn a new enterprise tool such as SAP quickly?

    medium

    Start with the official documentation and a training sandbox, learn the business process before the screens (for example, order to cash), build a small end-to-end scenario, and ask a mentor to review it. Take notes on transaction names and common errors. Showing a structured learning plan matters more than claiming existing knowledge.

  10. 10

    Tell me about a time you explained something technical to a non-technical person.

    medium

    Describe the audience and what they needed to decide, the plain-language analogy or diagram you used, and how you checked they understood. Keep jargon out of your own answer. A short, real example such as explaining your project to a family member or a faculty member from another department is fine.

  11. 11

    Are you comfortable with client-facing work and flexible timings?

    easy

    Be truthful about timings. Services work can involve calls with clients in other time zones. Show that you take communication seriously with an example of presenting or coordinating a team. If you have limits, state them clearly and calmly, and avoid agreeing to conditions you cannot keep.

  12. 12

    Why NTT DATA?

    easy

    Mention what you have actually read about its services in consulting, applications and infrastructure, and link it to a skill you want to grow, such as cloud or enterprise applications. Avoid repeating generic phrases like global leader. Show interest in the work, not just the brand.

Frequently asked questions

Does NTT DATA ask SAP questions to freshers?

Only for roles that involve enterprise applications. Most developer roles stress programming and SQL, with ERP concepts as a bonus.

What is the NTT DATA selection process?

Commonly reported as an online test, a technical interview and an HR interview. Confirm on your invitation.

Is coding tested?

Commonly reported at an easy to medium level.

Is communication important?

Yes. Services roles work with clients, so clear spoken English and structure matter.

Where do I find official openings?

On NTT DATA's own careers site.

Related guides

More in Company Interview Questions

See all in this section