ICICI Lombard General Insurance Company Deputy Vice President Interview Questions and Answers

Zonal manger taken the interview along with Area manager

Q1. What motivates you to perform better?
Add your answer
Q2. What is your professional objective in Life?
Add your answer
Q3. What are the key habits you have for success?
Add your answer
Q4. What is your salary expectation?
Add your answer

Asked to prepare a ppt

Q1. Previous experience
Add your answer
Q2. Why are you leaving current job
Add your answer

Q1. Tell me about your self
Add your answer
Q2. I will tell all Answer
Add your answer

Q1. The output of 4 joins and how the processing happens?
Ans. 
The output of 4 joins is a result set that combines data from multiple tables based on specified conditions.
• Joins are used to combine rows from two or more tables based on a related column between them.

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• Processing of joins involves matching rows from the tables based on the specified join condition.

• The output of 4 joins would involve combining data ...read more
Answered by AI
Add your answer
Q2. Spark Parameters calculation
Add your answer
Q3. Self Joins between the table with CTE
Ans. 
Self joins between tables with CTE are used to join a table to itself using Common Table Expressions.
• Self joins are used when you need to compare rows within the same table.

• CTE is used to create a temporary result set that can be referenced multiple times in a query.

• Example: SELECT e1.employee_id, e2.manager_id FROM employees e1 JOIN employees e2 ON e1.manager_id = e2.employee_id
Answered by AI
Add your answer
Q4. Optimizations in Spark
Ans. 
Optimizations in Spark involve tuning configurations, partitioning data, using efficient transformations, and caching intermediate results.
• Tune configurations for memory and parallelism

• Partition data to distribute workload evenly

• Use efficient transformations like map, filter, and reduce

• Cache intermediate results to avoid recomputation
Answered by AI
Add your answer

Q1. Explain your project and your role
Add your answer
Q2. Data Model Interview questions
Add your answer
Q3. Problem Solving Approach on few scenarios
Add your answer

Q1. Tell me something about yourself
Add your answer

Q1. Where gou see yourself in next 5 years
Add your answer