Upload Button Icon Add office photos

AIG

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

AIG Data Integration Analyst Interview Questions and Answers

Updated 23 Aug 2015

AIG Data Integration Analyst Interview Experiences

1 interview found

Interview Questionnaire 

3 Questions

  • Q1. Tell something about yourself
  • Ans. 

    I am a data integration analyst with experience in data mapping, ETL processes, and data warehousing.

    • I have a degree in computer science and have worked in the field for 5 years.

    • I am proficient in SQL, Python, and ETL tools such as Informatica and Talend.

    • I have experience working with various databases such as Oracle, MySQL, and SQL Server.

    • I have worked on projects involving data migration, data cleansing, and data int...

  • Answered by AI
  • Q2. Hobbies?
  • Q3. About Gaming?

Interview Preparation Tips

Round: Test
Experience: It was a higher level difficulty test with negative marking . The Aptitude section was difficult and question were mainly involved from Statistics/Probability/Range.It emphasized mainly mathematical ability of an individual.Puzzle section solutions also landed on numbering/series equations which provided the solution.
Duration: 60 minutes

Round: Technical Interview
Experience: This round will have questions specific to the position offered.This round will more specifically test the Analytical skills of an individual.
They digged into my final year project . It was more about how much I can enhance the existing system. Since it was based on Cloud Computing, they thoroughly checked basics as well as advanced concepts of cloud computing.Questions were also related to Data warehousing and Mining/Data discretization.

Round: HR Interview
Experience: This was a general one-on-one interaction round n the most easiest in the selection process.

General Tips: Must have a strong hold on general mathematics and analytics to crack the process.
Skills: Analytics, Mathematics, English Language Fluency
College Name: VIT VELLORE

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Newspaper Ad and was interviewed in Dec 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Aptitude Test 

English
Reasoning
Mathematics
General knowledfe

Round 3 - One-on-one 

(3 Questions)

  • Q1. Why do you want to join this company
  • Q2. Overall questions
  • Q3. Where sector 13 is situated in Chandigarh
  • Ans. 

    Sector 13 is situated in Chandigarh, India, known for its residential area and proximity to various amenities.

    • Sector 13 is a residential sector in Chandigarh

    • It is located near Sector 12 and Sector 14

    • The sector has parks, schools, and other amenities for residents

    • Sector 13 is well-connected to other parts of Chandigarh

  • Answered by AI

Interview Preparation Tips

Topics to prepare for The New India Assurance Co. Manager interview:
  • Current Affairs
  • Related to your study
  • Technical skills if any
  • Your family and visiion
  • Whereabouts and your goal
Interview preparation tips for other job seekers - Confident
Knowledgeable
Well dressed
Answer with peaceful.mind and smiling face
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Technical 

(1 Question)

  • Q1. IT GRC Audits Patching
Round 3 - Technical 

(1 Question)

  • Q1. Technology GRC Certification Audit
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. Why do you want to join
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(4 Questions)

  • Q1. Tell me something about yourself?
  • Q2. What is IRR and how to calculate?
  • Ans. 

    IRR stands for Internal Rate of Return, a metric used to evaluate the profitability of an investment. It is the discount rate that makes the net present value of all cash flows from a particular investment equal to zero.

    • IRR is used to determine the potential profitability of an investment or project.

    • It takes into account the time value of money, considering both the magnitude and timing of cash flows.

    • IRR is calculated ...

  • Answered by AI
  • Q3. Why you leave past companies?
  • Q4. How you like to see yourself in next 5 years

Interview Preparation Tips

Interview preparation tips for other job seekers - Stay cool.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-

I applied via Job Portal

Round 1 - HR 

(1 Question)

  • Q1. What is your CTC?
  • Ans. 

    My current CTC is $80,000 per year.

    • My current CTC is $80,000 per year.

    • I am currently earning $80,000 annually.

    • My current salary package is $80,000 per annum.

  • Answered by AI
Round 2 - One-on-one 

(1 Question)

  • Q1. Tell me about yourself
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before May 2023. There was 1 interview round.

Round 1 - HR 

(2 Questions)

  • Q1. About sales and marketing
  • Q2. Experiences and about city geographical details

I applied via LinkedIn and was interviewed before May 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. About previous sales profile. They check how maturely you answer questions (since it is insurance). Que on recruitment of agents. They check u r immediate market contacts, like how many people u know.

Interview Preparation Tips

Interview preparation tips for other job seekers - Confidence is the key.
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - One-on-one 

(2 Questions)

  • Q1. What is your M0 Activation What is your M12 retention Definitions of Accrued, reversionary Bonus Define bonus Underwriting
  • Ans. 

    M0 Activation refers to the initial engagement of customers, M12 retention is the percentage of customers retained after 12 months, accrued bonus is earned over time, reversionary bonus is paid upon certain conditions, bonus is an extra reward, underwriting is assessing risk.

    • M0 Activation is the percentage of customers who engage with a product or service initially

    • M12 retention is the percentage of customers who contin...

  • Answered by AI
  • Q2. How do you increase advisors walk-in
  • Ans. 

    To increase advisors walk-in, focus on improving visibility, offering incentives, providing excellent customer service, and utilizing marketing strategies.

    • Improve visibility by increasing signage and advertising in the local area.

    • Offer incentives such as discounts or promotions for walk-in customers.

    • Provide excellent customer service to encourage repeat visits and positive word-of-mouth referrals.

    • Utilize marketing stra...

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. Background of Experience
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Feb 2024. There was 1 interview round.

Round 1 - HR 

(2 Questions)

  • Q1. Related to your Undergraduation
  • Q2. General questions about hospitals

Interview Preparation Tips

Interview preparation tips for other job seekers - Be bold enough to answer questions
Contribute & help others!
anonymous
You can choose to be anonymous

Recently Viewed

INTERVIEWS

Virtuoso

No Interviews

INTERVIEWS

Allerin Tech

No Interviews

INTERVIEWS

AIG

No Interviews

LIST OF COMPANIES

Gujarat Gas

Locations

SALARIES

Allerin Tech

INTERVIEWS

Gujarat Gas

No Interviews

INTERVIEWS

Suresh Gyan Vihar University

No Interviews

INTERVIEWS

AIG

No Interviews

INTERVIEWS

Akal Academy

No Interviews

INTERVIEWS

Akal Academy

No Interviews

Tell us how to improve this page.

Assistant Manager
199 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Junior Manager
176 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Manager
104 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Process Developer
48 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Lead Manager
42 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare AIG with

ICICI Lombard General Insurance Company

3.7
Compare

HDFC Life

4.0
Compare

Bajaj Allianz General Insurance

3.9
Compare

Tata AIG

4.1
Compare
Did you find this page helpful?
Yes No
write
Share an Interview