ICICI Securities Software Engineer Interview Questions and Answers

During the coding round, I was asked a question about performing insertion sort using recursion. Additionally, there were theoretical questions regarding DBMS and some puzzles. The interview lasted for 45 minutes.

Q1. What questions were asked regarding your projects, particularly those that required a deep dive into the programming languages you utilized, including inquiries about how the server operates and various ap...read more
Add your answer

Q1. How was your college experience? Where do you live? Your interests and hobbies?
Ans. 
My college experience was enriching, I live in a bustling city, and my interests include coding, hiking, and playing the guitar.
• College experience was enriching with challenging coursework and extracurricular activities

• I live in a bustling city with access to diverse cultural events and opportunities

• Interests include coding, hiking, and playing the guitar for relaxation and creativity
Answered by AI
Add your answer

Q1. Find the character with the maximum frequency
Ans. 
Iterate through each character in the array of strings and keep track of the frequency of each character. Return the character with the maximum frequency.
• Create a dictionary to store the frequency of each character

• Iterate through each string in the array and then through each character in the string

• Update the frequency count of each character in the dictionary

• Return the character with the maximum frequency
Answered by AI
Add your answer
Q2. Valid parenthesis
Add your answer

Q1. Have you used Junit? What is the difference between SQl and NoSQl Databases? have you worked with Kafka? Kafka based questions. explain dockerization/ containerization. which java8 feature did you work wit...read more
Ans. 
Yes, I have experience with Junit, SQL and NoSQL databases, Kafka, Dockerization, Java 8 features, stream() operations, and shell scripting in Unix.
• I have used Junit for unit testing in Java projects.

• SQL databases are relational databases that use structured query language for data manipulation, while NoSQL databases are non-relational databases that provide flexible schema design and horizontal scalability.

• I have work...read more
Answered by AI
Add your answer

Q1. What is the most complex sql query you have written till date. Why did you use nested query to achieve your goal? explain the query. which join did you use in the query. have you implemented hashset? how w...read more
Ans. 
The most complex SQL query involved nested queries for data manipulation. Used inner join. Implemented hashset and avoided trees due to their drawbacks.
• Nested SQL query used for complex data manipulation

• Inner join used for combining data from multiple tables

• Implemented hashset for efficient data storage and retrieval

• Avoided trees due to their drawbacks such as unbalanced structure and slower traversal times
Answered by AI
Add your answer
Q2. Find and replace words in a file using shell scripting. add an index in the beginning of each line in a file using shell scripting. what is multithreading? difference between single threaded and multithrea...read more
Ans. 
Shell scripting for find and replace, adding index to lines, multithreading, hashmap vs hashtable, stack vs queue
• Use sed command for find and replace in shell scripting

• Use awk command to add an index at the beginning of each line in a file

• Multithreading is the ability of a CPU to execute multiple threads concurrently

• Single threaded means only one thread is executed at a time, while multithreaded allows multiple threads...read more
Answered by AI
Add your answer

Q1. Behavioral questions- tell me about yourself. do you have any questions for us?
Add your answer