AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Guardian India
Compare
Filter interviews by
Guardian India Data Engineer Interview Questions and Answers
Guardian India Data Engineer Interview Experiences
1 interview found
(1 Question)
- Q1. What is joins in SQL?
- Ans.
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
Joins are used to retrieve data from multiple tables based on a related column.
Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;
(1 Question)
- Q1. How do you maintain your work life balance?
Skills evaluated in this interview
Interview questions from similar companies
Software Engineer Interview Questions & Answers
Bajaj Allianz Life Insurance
Anonymous
posted on 27 Jul 2024
General SQL Questions.
(1 Question)
- Q1. Salary Negotiation.
Interview Preparation Tips
Selected
I applied via Naukri.com and was interviewed before Mar 2022. There were 3 interview rounds.
(1 Question)
- Q1. Interview questions were related to basic SQL questions, few problem statements and approach based scenarios. Optimized ways to solve a problem was being stressed upon.
(1 Question)
- Q1. It was less technical and more about salary expectations and job role related.
Interview Preparation Tips
All the questions are based on the MCQ , and the syllabus is covered python SQL Power BI
Some questions from the Pandas Data Frame scenario based
(1 Question)
- Q1. Ask about work and coding
Interview Preparation Tips
Data Engineer Interview Questions & Answers
Axis Max Life Insurance
Hamdy Tawfeek
posted on 28 Jul 2024
I applied via Job Portal
Sql interiew, you will be asked to answer it on google meet chat
Simple cases of sql in 1 hr interview
I applied via Recruitment Consulltant and was interviewed in Oct 2023. There were 4 interview rounds.
20 min for 25 question that are related to u r profile
(3 Questions)
- Q1. They dont have knowledge about the profile asking some stupied questions
- Q2. You are working before on MNC clients
- Ans.
Yes, I have worked with MNC clients before.
I have experience working with multinational clients in my previous roles.
I have successfully managed projects for MNC clients, delivering high-quality data analysis.
I am familiar with the challenges and requirements of working with MNC clients, such as cultural differences and complex data sets.
I have collaborated with cross-functional teams to meet the specific needs of MNC ...
- Q3. They dont know this compeny is MNC asking again and again u r working in MNC
Assignment on Sales data to find revenue ,split column
(4 Questions)
- Q1. How much project you done in last year ?
- Ans.
I have completed multiple projects in the last year.
I have completed 5 projects in the last year.
One of the projects involved analyzing customer data to identify trends and patterns.
Another project focused on optimizing inventory management using data analysis techniques.
I also worked on a project that involved creating a predictive model for sales forecasting.
In addition, I collaborated on a project to analyze social ...
- Q2. After clering all rounds they arrange the salary discussion round but not done salary discussion round and not getting any response on email & call
- Q3. HR not given proper feedback about selection not getting any response on call & email
- Q4. It is so difficult to decide U r selected or not & u can wait or join another
Interview Preparation Tips
- Advanced Excel
- SQL
- Power Bi
First round will be aptitude test
(2 Questions)
- 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
- Q2. Tell me about your self
(2 Questions)
- Q1. Salary expectation
- Q2. Position of the candidate
Selected
I applied via LinkedIn and was interviewed in Mar 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Basic Excel function
- Q2. Scenario based questions
More questions about my experience & reason to join.
Interview Preparation Tips
Friendly behavior
Prepare more on scenario based questions
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
Analyst Interview Questions & Answers
ICICI Prudential Life Insurance
Anonymous
posted on 7 Feb 2017
I appeared for an interview in Dec 2016.
Interview Questionnaire
7 Questions
- Q1. Tell me about yourself
- Ans.
I am a dedicated and detail-oriented analyst with a strong background in data analysis and problem-solving.
I have a Bachelor's degree in Statistics and experience in analyzing large datasets
I am proficient in using statistical software such as R and Python
I have a proven track record of identifying trends and providing actionable insights to drive business decisions
- Q2. How does Insurance companies work ?
- Ans.
Insurance companies work by providing financial protection to individuals or organizations against potential risks or losses.
Insurance companies collect premiums from policyholders in exchange for coverage.
They assess risks and determine the appropriate premiums to charge based on factors such as age, health, and occupation.
Insurance companies invest the collected premiums to generate income and ensure they have suffic...
- Q3. Who is an actuary and what are his roles ?
- Ans.
An actuary is a professional who assesses and manages financial risks using mathematics, statistics, and business knowledge.
Analyzing data to calculate probabilities of events such as death, sickness, injury, and property loss
Designing insurance policies and pension plans based on risk assessments
Helping companies make informed decisions on managing risks and setting premiums
Advising on investment strategies to ensure ...
- Q4. What is India's GDP and its growth rate ?
- Ans.
India's GDP is $2.7 trillion with a growth rate of 4.2%.
India's GDP is one of the largest in the world.
As of 2020, India's GDP was $2.7 trillion.
The growth rate of India's GDP in 2020 was 4.2%.
India's GDP growth rate has been fluctuating over the years.
The COVID-19 pandemic had a significant impact on India's GDP growth.
- Q5. What are the Pros and Cons of Demonetization ?
- Ans.
Demonetization has pros and cons that impact various aspects of the economy and society.
Pros: Curbing black money, reducing corruption, promoting digital transactions
Cons: Initial economic disruption, inconvenience to the public, impact on informal sector
Example of a pro: Demonetization helped uncover undisclosed income and led to an increase in tax compliance.
Example of a con: Small businesses and daily wage workers f
- Q6. If there are two data sets each with 100 variables and having 10000 and 12000 policies verify the validity of the second data set assuming the first one is accurate.
- Ans.
The validity of the second data set can be verified by comparing it with the first data set.
Compare the variables in both data sets to ensure they are the same.
Check if the number of policies in the second data set matches the number stated.
Perform statistical analysis on both data sets to identify any discrepancies or inconsistencies.
Validate the accuracy of the second data set by cross-referencing it with external so
- Q7. Why do you want to work as an analyst ?
- Ans.
I am passionate about analyzing data and deriving insights to drive informed decision-making.
I enjoy problem-solving and critical thinking, which are essential skills for an analyst.
I have a strong attention to detail and excel at organizing and interpreting complex information.
I am interested in utilizing data to identify trends, patterns, and opportunities for improvement.
I believe that my analytical skills can contr...
Interview Preparation Tips
Guardian India Interview FAQs
Tell us how to improve this page.
Guardian India Interviews By Designations
- Guardian India Senior Engineer Interview Questions
- Guardian India Senior Associate Interview Questions
- Guardian India Software Engineer Interview Questions
- Guardian India Associate Interview Questions
- Guardian India Analyst Interview Questions
- Guardian India Assistant Manager Interview Questions
- Guardian India Senior Software Engineer Interview Questions
- Guardian India Graduate Engineer Trainee (Get) Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Database Admin Interview Questions
- Data Analyst Interview Questions
- System Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Show more
Guardian India Data Engineer Interview Process
based on 1 interview
Interview experience
Data Engineer Interview Questions from Similar Companies
Guardian India Data Engineer Reviews and Ratings
based on 3 reviews
Rating in categories
|
Associate
375
salaries
|  ₹2 L/yr - ₹5.8 L/yr |
|
Lead Engineer
239
salaries
| ₹9.3 L/yr - ₹26 L/yr |
|
Analyst
165
salaries
| ₹3.2 L/yr - ₹10.9 L/yr |
|
Senior Engineer
143
salaries
| ₹6.6 L/yr - ₹23.9 L/yr |
|
Team Member
138
salaries
| ₹2 L/yr - ₹3.5 L/yr |
HDFC Life
ICICI Prudential Life Insurance
ICICI Lombard General Insurance Company
Axis Max Life Insurance
- Home >
- Interviews >
- Guardian India Interview Questions >
- Guardian India Data Engineer Interview Questions
