ICICI Bank Team Lead Interview Questions and Answers

Q1. How do you build a web performant app?
Ans. 
To build a web performant app, focus on optimizing code, reducing server requests, using caching, and optimizing images.
• Optimize code by minimizing unnecessary functions and variables

• Reduce server requests by combining files, using CDNs, and lazy loading

• Utilize caching to store data locally and reduce load times

• Optimize images by resizing, compressing, and using modern formats like WebP
Answered by AI
Add your answer
Q2. What data structure you want to use for returning database records and why?
Ans. 
I would use an array data structure for returning database records as it allows for easy access and manipulation of individual records.
• Arrays provide O(1) access time for individual records, making it efficient for returning database records.

• Arrays allow for easy iteration over all records to perform operations such as filtering or sorting.

• Arrays can easily be converted to JSON or other data formats for returning to th...read more
Answered by AI
View 1 more answer

Q1. Hiring manager was late to interview.
Add your answer
Q2. Do not join such organisations.
Add your answer

Q1. Tell about myself and background
Add your answer
Q2. Salary expectations for this role
Add your answer

Email writing, English aptitude

Q1. Project presentation after one hour of demo session
Add your answer

Q1. Tell me about yourself
Add your answer

Q1. Your job requirements
Add your answer
Q2. Any experience for this job
Add your answer
Q3. Your education with stream
Ans. 
Bachelor's in Computer Science
• Bachelor's degree in Computer Science

• Specialized in software development and programming languages

• Relevant coursework in algorithms, data structures, and software engineering

• Hands-on experience with coding projects and internships
Answered by AI
Add your answer
Q4. What type of job role are you looking
Add your answer
Q5. What kye skill do you have ?
Add your answer

There were 2 question:-
1. array(easy to medium)
2. Graph(easy to medium)

Q1. Q1. Explain joins and their type?
Ans. 
Joins are used to combine data from two or more tables based on a related column.
• Inner join returns only the matching rows from both tables

• Left join returns all rows from the left table and matching rows from the right table

• Right join returns all rows from the right table and matching rows from the left table

• Full outer join returns all rows from both tables

• Cross join returns the Cartesian product of both tables
Answered by AI
Add your answer
Q2. Q2. what is normalization?
Ans. 
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
• Normalization involves breaking down a database into smaller, more manageable tables.

• Each table should have a primary key and only contain data that is related to that key.

• Normalization helps to prevent data inconsistencies and anomalies.

• There are different levels of normalization, with each level building on t...read more
Answered by AI
View 1 more answer