AIG Cat Modelling Analyst Interview Questions and Answers

Q1. How are heard about HDFC Life?
Add your answer

Q1. Talk about your experience
Add your answer
Q2. What is your salary expectation
Add your answer

Q1. Do you know about CAMELS
Ans. 
CAMELS is a rating system used by regulators to assess the soundness of financial institutions.
• CAMELS stands for Capital adequacy, Asset quality, Management, Earnings, Liquidity, and Sensitivity to market risk.

• Each component is rated on a scale of 1 to 5, with 1 being the best and 5 being the worst.

• Regulators use CAMELS ratings to determine the overall health and stability of financial institutions.

• For example, a bank ...read more
Answered by AI
Add your answer
Q2. What is substance over form
Ans. 
Substance over form is a concept in accounting where the economic reality of a transaction is more important than its legal form.
• Focuses on the underlying economic substance of a transaction rather than its legal form

• Ensures that financial statements accurately reflect the true financial position of a company

• Helps prevent misleading financial reporting by looking beyond surface details

• Example: Recording a lease as an o...read more
Answered by AI
Add your answer

Q1. Basic Excel function
Add your answer
Q2. Scenario based questions
Add your answer

More questions about my experience & reason to join.

Mostly asked on insurance

Insurance and accounting

Q1. Type of sql Joints
Ans. 
SQL Joins are used to combine rows from two or more tables based on a related column between them.
• Types of SQL Joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• INNER JOIN returns rows when there is at least one 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 tab...read more
Answered by AI
Add your answer
Q2. Write DAX for create data modeling on inactive relationship?
Ans. 
Use DAX to create data modeling on inactive relationship in Power BI.
• Use USERELATIONSHIP function to create an inactive relationship between two tables.

• Specify the relationship between the tables and the columns to be used in the relationship.

• Use CALCULATE function along with USERELATIONSHIP to perform calculations using the inactive relationship.
Answered by AI
Add your answer

Duration - 60 Minutes
Topic - Advance DAX, Joints using DAX, all except all

Q1. Educational background
Add your answer

Q1. Some hr questions
Add your answer

First round will be aptitude test

Q1. Why should I hire you
Ans. 
I have a strong analytical background, excellent problem-solving skills, and a proven track record of delivering actionable insights.
• I have a degree in data analytics and relevant work experience

• I am proficient in statistical analysis and data visualization tools such as Python, R, and Tableau

• I have successfully completed projects where I identified trends and patterns in data to drive business decisions
Answered by AI
Add your answer
Q2. Tell me about your self
Add your answer

Q1. Salary expectation
Add your answer
Q2. Position of the candidate
Add your answer

Impact of AI in IT Industry