iCIMS Interview Questions and Answers

Q1. Discuss the types of Joins in SQL
Ans. 
Types of Joins in SQL include Inner Join, Left Join, Right Join, and Full Outer Join.
• Inner Join: Returns rows when there is a match in both tables.

• Left Join: Returns all rows from the left table and the matched rows from the right table.

• Right Join: Returns all rows from the right table and the matched rows from the left table.

• Full Outer Join: Returns rows when there is a match in either table.
Answered by AI
Add your answer
Q2. What are the ways to optimize Tableau dashboard?
Ans. 
Optimizing Tableau dashboard involves improving performance, usability, and visual appeal.
• Limit the number of worksheets on a dashboard to improve performance

• Use filters and parameters effectively to allow for interactivity

• Optimize data source connections for faster loading times

• Utilize dashboard actions to create dynamic interactions

• Design with user experience in mind to ensure clarity and ease of use
Answered by AI
Add your answer
Q3. What are the different types of LOD functions? Give examples of situations where you used them.
Ans. 
Different types of LOD functions include INCLUDE, EXCLUDE, and FIXED.
• INCLUDE LOD function is used to compute the level of detail for a specific dimension while keeping all other dimensions constant.

• EXCLUDE LOD function is used to compute the level of detail for all dimensions except the specified dimension.

• FIXED LOD function is used to compute the level of detail independently of the visualization's dimensions.

• Examples...read more
Answered by AI
Add your answer

There is a codility test given with one coding and one test cases

Q1. LRU cache and its implementation
Ans. 
LRU cache is a data structure that stores the most recently used items, discarding the least recently used items when full.
• LRU cache stands for Least Recently Used cache

• It is typically implemented using a combination of a doubly linked list and a hashmap

• When a new item is accessed, it is moved to the front of the list. If the cache is full, the least recently used item at the end of the list is removed

• Example: If the c...read more
Answered by AI
Add your answer

Q1. What is transaction management and how is it handled in microservices
Ans. 
Transaction management is the process of ensuring data consistency and integrity in a system.
• In microservices, each service has its own database, making distributed transactions challenging.

• Two popular approaches to handle transaction management in microservices are Saga pattern and two-phase commit protocol.

• Saga pattern involves breaking a transaction into multiple smaller transactions that can be rolled back individu...read more
Answered by AI
Add your answer
Q2. Statefull vs stateless
Ans. 
Stateful vs stateless refers to whether a system retains information about the state of a user's interactions.
• Stateful systems store client session information on the server side, requiring more resources and making scaling more complex.

• Stateless systems do not store client session information, making them easier to scale and more fault-tolerant.

• Stateful systems are typically used for applications that require maintain...read more
Answered by AI
Add your answer

Q1. Are you willing to participate in rotational shifts?
Ans. 
I am open to participating in rotational shifts, as I understand the importance of flexibility in technical support roles.
• Adaptability: Working in rotational shifts allows me to adapt to different schedules and maintain a work-life balance.

• Team Collaboration: Rotational shifts enable better coverage and support for the team, ensuring that customer issues are addressed promptly.

• Experience: In my previous role, I success...read more
Answered by AI
Add your answer
Q2. Can you provide details about your family background?
Ans. 
I come from a supportive family that values education and hard work, which has greatly influenced my career choices.
• Parents: My father is an engineer and my mother is a teacher, both instilling a strong work ethic and the importance of education.

• Siblings: I have one younger sister who is pursuing a degree in computer science, showcasing our family's commitment to technology.

• Family Values: We prioritize open communicati...read more
Answered by AI
Add your answer

Q1. He asked about the introduction
Add your answer
Q2. About the projects that I have worked on
Add your answer