10+ ICICI Bank Interview Questions and Answers

UAT is user acceptance testing where end users validate the system, while system testing is done by testers to validate the system against requirements.

• UAT is done by end users to ensure the system meets their requirements and is ready for production.

• System testing is done by testers to validate the system against functional and non-functional requirements.

• UAT focuses on user scenarios and real-world usage, while system testing focuses on technical aspects and system behavior...read more

Create a class Employees with fields FirstName LastName, DoB, and Gender. Return avg age of employees and avg age by genders.

• Create a class Employees with fields FirstName, LastName, DoB, and Gender

• Calculate the average age of all employees

• Calculate the average age by genders

STLC is a process followed by testers to ensure high quality software by planning, designing, executing, and reporting on tests.

• STLC involves planning, designing, executing, and reporting on tests.

• It includes phases like requirement analysis, test planning, test design, test execution, and test closure.

• Each phase has specific activities and deliverables to ensure thorough testing of the software.

• STLC helps in identifying defects early in the development cycle, reducing costs ...read more

Yes, I have read SQL Execution Plans to optimize query performance.

• I have analyzed SQL Execution Plans to identify bottlenecks in queries.

• I have used SQL Execution Plans to optimize query performance by understanding how the database engine executes queries.

• I have made query optimization recommendations based on SQL Execution Plans.

• I have experience with tools like SQL Server Management Studio to view and analyze Execution Plans.

Types of indexes include clustered, non-clustered, unique, composite, and filtered indexes.

• Clustered index: Physically reorders the data in the table based on the index key.

• Non-clustered index: Contains a sorted list of references to the table data rows.

• Unique index: Ensures that no two rows have the same values in the indexed columns.

• Composite index: Index that is created on multiple columns.

• Filtered index: Index that includes only a subset of rows based on a filter conditio...read more

I am familiar with design patterns such as Singleton, Factory, Observer, and MVC.

• Singleton pattern ensures a class has only one instance and provides a global point of access to it.

• Factory pattern creates objects without specifying the exact class of object that will be created.

• Observer pattern defines a one-to-many dependency between objects so that when one object changes state, all its dependents are notified and updated automatically.

• MVC (Model-View-Controller) pattern se...read more

Optimizing SQL queries involves using indexes, minimizing data retrieval, avoiding unnecessary joins, and optimizing query structure.

• Use indexes on columns frequently used in WHERE clauses

• Minimize data retrieval by selecting only necessary columns

• Avoid unnecessary joins by using EXISTS or IN clauses instead

• Optimize query structure by using appropriate joins and subqueries

I prioritize tasks, take deep breaths, and seek help from colleagues or supervisors.

• Prioritize tasks to focus on what needs to be done first

• Take deep breaths to calm down and think clearly

• Seek help from colleagues or supervisors if feeling overwhelmed

• Practice time management techniques to stay organized and reduce stress

Bug lifecycle refers to the stages a bug goes through from identification to resolution in software testing.

• Bug is identified by tester

• Bug is reported in a bug tracking system

• Bug is assigned to a developer

• Developer fixes the bug

• Bug is retested by tester

• If bug is fixed, it is closed. If not, it is reopened

• Bug lifecycle can include stages like New, Assigned, Fixed, Retest, Closed

Entity Framework (EF) has a lifetime scope tied to the DbContext instance.

• Lifetime scope of EF is tied to the DbContext instance

• DbContext should be short-lived and disposed of after use

• DbContext should not be shared across multiple threads

• DbContext should be created and disposed of within a using block

Rotate an array of strings by D places.

• Create a temporary array to store elements that will be rotated

• Copy elements from original array to temporary array based on rotation

• Copy elements back from temporary array to original array

To find the maximum value in a subarray within an array of numbers.

• Iterate through the array and keep track of the maximum value seen so far.

• For each subarray, compare the maximum value with the current element and update if necessary.

• Return the maximum value found in the subarray.

Conducted benchmarking studies to compare compensation and benefits practices with industry standards.

• Researched industry trends and best practices in compensation and benefits

• Analyzed data to identify areas for improvement

• Implemented changes based on benchmarking results

• Regularly reviewed and updated benchmarking studies to ensure competitiveness