NTT Data Associate Consultant Interview Questions and Answers

Q1. Explain about your project and the stack
Add your answer
Q2. Explain about the oops concepts
Ans. 
Object-oriented programming concepts that focus on data encapsulation, inheritance, polymorphism, and abstraction.
• Encapsulation: Bundling data and methods that operate on the data into a single unit (class).

• Inheritance: Ability of a class to inherit properties and behavior from another class.

• Polymorphism: Ability to present the same interface for different data types.

• Abstraction: Hiding the complex implementation detai...read more
Answered by AI
Add your answer

Basics of maths,logical,technical

Q1. Write a code to find the prime number
Ans. 
Code to find prime numbers
• Iterate through numbers from 2 to n

• Check if number is divisible by any number from 2 to its square root

• If not divisible, it is a prime number
Answered by AI
Add your answer
Q2. SQL questions about select all employees in a dpt
Add your answer

Try on reasoning,basics of maths,oops,dsa etc...

Q1. What is firewall? Firewall types?VPN?
Add your answer

Q1. Mysql query for 3rd highest salary
Ans. 
Use a subquery to find the third highest salary from the employees table in MySQL.
• Use a subquery to select distinct salaries from the employees table.

• Order the salaries in descending order and use LIMIT to get the third highest salary.

• Example: SELECT DISTINCT salary FROM employees ORDER BY salary DESC LIMIT 2, 1;
Answered by AI
Add your answer
Q2. What are the steps to connect to a database?
Ans. 
Steps to connect to a database involve specifying the database type, providing credentials, and establishing a connection.
• Specify the type of database you want to connect to (e.g. MySQL, PostgreSQL, MongoDB).

• Provide the necessary credentials such as username and password.

• Establish a connection using a programming language or tool like JDBC, ODBC, or ORM frameworks.
Answered by AI
Add your answer

A 60-minute aptitude test.

In this round, you will receive multiple questions tailored to your area of expertise.

Q1. What motivated you to pursue a career in UI/UX design?
Add your answer
Q2. Could you please showcase your previous work experiences?
Add your answer

Q1. About different joins in SQL
Add your answer
Q2. 1)About previous projects done in detail 2) Regarding any certification like dp-203 or spark certification 3) spark architecture 4) about delta table
Add your answer
Q3. Some questions about adf pipelines scenario based
Add your answer
Q4. Spark actions and transformation
Add your answer

Genpact company established in year 1997 in the city of new york. 1250000 peoples across world wide service 30 countries..

Q1. What security policy benefits is in this company
Ans. 
Security job work at office work at home and travel for job .policy health insurance gud terms and conditions to the company For job guidelines for freshers
Answered by Sandra shirisha
Add your answer
Q2. What is hybrid adìvce in job or work
Ans. 
Hybrid advice in job or work refers to a combination of traditional and modern approaches to problem-solving or decision-making.
• Hybrid advice involves using both traditional methods and modern technologies to address challenges in the workplace.

• It combines the wisdom and experience of older employees with the innovative ideas and tools of younger generations.

• Examples include using a mix of in-person meetings and virtua...read more
Answered by AI
View 1 more answer
Q3. What help us working in company
Ans. 
Community opportunity learning skill development training skills teams work success...
Answered by Sandra shirisha
Add your answer
Q4. Company were at located some of them area names
Add your answer
Q5. Explain company benefits to work and culture in genpact
Ans. 
Genpact offers competitive benefits and a positive work culture for its employees.
• Genpact provides comprehensive health insurance coverage for employees and their families.

• Employees have access to professional development opportunities and training programs.

• The company promotes a diverse and inclusive work environment.

• Genpact offers flexible work arrangements, such as remote work options.

• Employees can participate in va
Answered by AI
Add your answer

Q1. Oops, java , collections basic questions asked
Add your answer