i
NTT Data
Filter interviews by
Top trending discussions
posted on 6 Jul 2024
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
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
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
I was interviewed in Jun 2024.
I applied via Approached by Company and was interviewed before Oct 2023. There were 2 interview rounds.
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
I applied via Approached by Company and was interviewed before Oct 2022. There were 4 interview rounds.
Analytical skills should be strong
I applied via Approached by Company and was interviewed in Dec 2021. There was 1 interview round.
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...
posted on 25 Oct 2024
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 ...
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.
I applied via Naukri.com and was interviewed in Sep 2024. There were 3 interview rounds.
Mostly array problems and other coding questions related to your stack
based on 3 reviews
Rating in categories
Software Engineer
932
salaries
| ₹2.8 L/yr - ₹11 L/yr |
Senior Associate
767
salaries
| ₹1.1 L/yr - ₹7.5 L/yr |
Network Engineer
647
salaries
| ₹1.8 L/yr - ₹10 L/yr |
Software Developer
615
salaries
| ₹2.5 L/yr - ₹13 L/yr |
Senior Software Engineer
512
salaries
| ₹6.5 L/yr - ₹24 L/yr |
Tata Communications
Bharti Airtel
Reliance Communications
Vodafone Idea