AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
i
Gallagher
Compare
Filter interviews by
Gallagher Interview Questions and Answers
Gallagher Interview Experiences
221 interviews found
Anonymous
I appeared for an interview in Feb 2025.
(2 Questions)
- Q1. Types of sql joins
- Ans.
SQL joins combine rows from two or more tables based on related columns, enabling complex queries and data retrieval.
INNER JOIN: Returns records with matching values in both tables. Example: SELECT * FROM A INNER JOIN B ON A.id = B.id;
LEFT JOIN: Returns all records from the left table and matched records from the right table. Example: SELECT * FROM A LEFT JOIN B ON A.id = B.id;
RIGHT JOIN: Returns all records from the r...
- Q2. What is having clause
- Ans.
HAVING clause filters records after GROUP BY, allowing conditions on aggregated data in SQL queries.
Used in SQL to filter results of aggregate functions like COUNT, SUM, AVG.
Example: SELECT department, COUNT(*) FROM employees GROUP BY department HAVING COUNT(*) > 10;
It follows the GROUP BY clause in a SQL statement.
Allows for conditions on grouped data, unlike WHERE which filters before grouping.
Trainee Interview Questions asked at other Companies
I applied via Recruitment Consulltant and was interviewed in Sep 2024. There were 2 interview rounds.
Basics of grammer and mathematics are few of the things
(2 Questions)
- Q1. Insurance domain knowledge
- Q2. Flexibility test
Senior Associate Interview Questions asked at other Companies
Basic Questions like financial anaysis
(2 Questions)
- Q1. Many Insurance analysis questions
- Q2. Credit ratings
Financial Service Advisor Interview Questions asked at other Companies
Selected
I applied via Referral and was interviewed in Aug 2024. There were 2 interview rounds.
Logical reasoning, communication and english grammer
(2 Questions)
- Q1. Insurance and its types
- Ans.
Insurance is a financial product that provides protection against financial losses.
Types of insurance include life insurance, health insurance, auto insurance, and property insurance.
Insurance can also be categorized as personal insurance and commercial insurance.
Insurance policies typically involve a contract between the insurer and the insured party.
Premiums are paid by the insured in exchange for coverage against sp...
- Q2. Accounting basics like receivable and payalble
Process Analyst Interview Questions asked at other Companies
Gallagher interview questions for popular designations
Selected
I appeared for an interview in Dec 2024.
(1 Question)
- Q1. Test approach test plan doc prep
(1 Question)
- Q1. Test plan doc prep
Senior Specialist Interview Questions asked at other Companies
Selected
I appeared for an interview in Dec 2024.
It's about our self intro
It contains 4 phases - Total 90 marks - 70 minutes duration
1. English grammer - 30 marks
2. Logical reasoning - 20 marks
3. Insurance - 20 marks
4. Accounting - 20 marks
(1 Question)
- Q1. They asked about job role related questions and about previous work experience .
Top Gallagher Process Associate Interview Questions and Answers
Process Associate Interview Questions asked at other Companies
Jobs at Gallagher
I applied via Walk-in and was interviewed in Aug 2024. There were 2 interview rounds.
(2 Questions)
- 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...
- 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.
Duration - 60 Minutes
Topic - Advance DAX, Joints using DAX, all except all
Skills evaluated in this interview
Data Analyst Interview Questions asked at other Companies
I applied via Campus Placement and was interviewed in Nov 2024. There was 1 interview round.
Impact of AI in IT Industry
Interview Preparation Tips
Business Analyst Interview Questions asked at other Companies
It's good but it was difficult
(2 Questions)
- Q1. I didn't select for hr round
- Q2. I don't know about hr round
(4 Questions)
- Q1. I didn't select for manager round
- Q2. I don't know about that
- Q3. I don't know how is it
- Q4. Sorry I don't know about that
Associate Finance & Accounts Interview Questions asked at other Companies
Nishank Bhade
Selected
I applied via Walk-in and was interviewed in Aug 2024. There were 2 interview rounds.
Insurance based questions
Mostly on insurance and accounting
Analyst Interview Questions asked at other Companies
Gallagher Interview FAQs
The duration of Gallagher interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
Gallagher Interviews By Designations
- Gallagher Process Associate Interview Questions
- Gallagher Process Analyst Interview Questions
- Gallagher Senior Process Analyst Interview Questions
- Gallagher Analyst Interview Questions
- Gallagher Associate Interview Questions
- Gallagher Senior Associate Interview Questions
- Gallagher Data Analyst Interview Questions
- Gallagher Team Manager Interview Questions
- Show more
Interview Questions for Popular Designations
Gallagher Interview Process
based on 231 interviews
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
Gallagher Reviews and Ratings
based on 2k reviews
Rating in categories
Kochi,
Thiruvananthapuram
4-9 Yrs
₹ 3.3-3.85 LPA
|
Process Analyst
3.9k
salaries
|  ₹1.9 L/yr - ₹5 L/yr |
|
Senior Process Analyst
1.8k
salaries
| ₹2.5 L/yr - ₹9.5 L/yr |
|
Process Associate
1.3k
salaries
| ₹1 L/yr - ₹6 L/yr |
|
Processing Executive
535
salaries
| ₹1.5 L/yr - ₹4 L/yr |
|
Analyst
285
salaries
| ₹2 L/yr - ₹7.2 L/yr |
HDFC Life
ICICI Prudential Life Insurance
Axis Max Life Insurance
Bajaj Allianz Life Insurance
- Home >
- Interviews >
- Gallagher Interview Questions
