ICICI Securities Customer Care Officer Interview Questions and Answers

Q1. Interview was mostly structured around prior experiences and scenario based questions.
Add your answer

Scenario based questions

Q1. Salary expectations and culture fit
Add your answer

Q1. What was my current CTC
Add your answer

Q1. How much is my book size
Add your answer

Q1. Pure SQL technical round
Add your answer

Q1. SQL realtime questions
Add your answer
Q2. Unix Realtime questions
Add your answer

Q1. Datawarehousing and BI related questions
Add your answer

Q1. Unix realtime questions
Add your answer
Q2. Managerial questions
Add your answer

Q1. It is related to compensation
Add your answer

Q1. Data structure interview questions
Add your answer
Q2. Queue , Stack questions asked
Add your answer

Leet code medium problem related to arrays

Core Java multithreading serialization Treemap indepth working

Design parking lot with multiple in and out gates

Q1. Design Kafka and microservices around it
Ans. 
Designing Kafka and microservices architecture for scalability and fault tolerance
• Use Kafka as a distributed streaming platform to handle large volumes of data

• Implement microservices architecture to break down the application into smaller, independent services

• Use Kafka Connect to integrate Kafka with microservices for seamless data flow

• Leverage Kafka Streams for real-time data processing within microservices

• Ensure faul...read more
Answered by AI
Add your answer

Q1. Cultural fit round and salary expectations
Add your answer

Asked core java in depth question related to memory model, exception handling multithreading, and indepth question of collection ask to make some collection your self like linked list

Hacker rank test with 2 questions to solve

Q1. Just technical round, you should know basic in your language
Add your answer

Online test for 1 hr

Tree implementation : search, add

Q1. Design pattern used
Ans. 
The design pattern used is the Singleton pattern.
• Ensures a class has only one instance and provides a global point of access to it

• Commonly used in scenarios where only one instance of a class is needed, such as database connections or logging

• Implemented by creating a static method to return the same instance of the class each time it is called
Answered by AI
Add your answer
Q2. Design project and classes
Add your answer

Q1. Current project
Ans. 
Currently leading a cross-functional team in developing a new product launch strategy.
• Leading a cross-functional team

• Developing a new product launch strategy

• Ensuring alignment with company goals and objectives
Answered by AI
Add your answer
Q2. Discussion on prod
Add your answer