Upload Button Icon Add office photos

Filter interviews by

IPAC Lead Analyst Interview Questions and Answers

Updated 9 Nov 2022

IPAC Lead Analyst Interview Experiences

1 interview found

Lead Analyst Interview Questions & Answers

user image Anonymous

posted on 9 Nov 2022

I applied via Company Website and was interviewed in May 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 tips
Round 2 - HR 

(1 Question)

  • Q1. Expected Salary - Overall CTC
Round 3 - One-on-one 

(1 Question)

  • Q1. Why do you want to work in Politics?

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well. Practice your answers in your mind before the call. Don't panic.

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Aug 2024. There were 5 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Questions to write SQL Queries
  • Q2. Questions on data analytics using python
Round 2 - One-on-one 

(2 Questions)

  • Q1. Tell me about yourself (Team, Collaboration and Project Management aspects)
  • Ans. 

    I have a strong background in leading teams, collaborating with stakeholders, and managing projects effectively.

    • Led cross-functional teams to successfully deliver projects on time and within budget

    • Collaborated with stakeholders to gather requirements and ensure project alignment with business goals

    • Utilized project management tools such as Jira and Trello to track progress and communicate updates

    • Facilitated team meeting...

  • Answered by AI
  • Q2. How do you deal with tough stakeholders?
  • Ans. 

    I address tough stakeholders by actively listening, understanding their concerns, finding common ground, and maintaining professionalism.

    • Actively listen to their concerns and perspectives

    • Seek to understand their motivations and priorities

    • Find common ground and areas of agreement

    • Maintain professionalism and remain calm in challenging situations

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

(1 Question)

  • Q1. General discussion on team management, documentation, stakeholder handling
Round 4 - One-on-one 

(1 Question)

  • Q1. Similar Discussion as previous round
Round 5 - HR 

(1 Question)

  • Q1. People Mangement, Role priorities, Relocation and Travel Flexibility
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
-

I applied via Job Portal

Round 1 - Technical 

(1 Question)

  • Q1. Round 1: This is an initial screening round. You will be tested on the foundation of multiple technologies. SQL (Majority), Python, Visualization skillset and some basic statistics. Round 2 : Advance t...

Interview Preparation Tips

Topics to prepare for Target Data Analyst interview:
  • SQL
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Work about and sallery
  • Q2. Work about and sallary
Round 2 - One-on-one 

(1 Question)

  • Q1. Work about and sallery
Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Jul 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Excel formulas and pivot tables
  • Q2. SQL queries like Joins and CTE

Interview Preparation Tips

Interview preparation tips for other job seekers - Good interview process

Analyst Interview Questions & Answers

Tesco user image Alex Jarman-Jones

posted on 18 Oct 2024

Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Sep 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Standard psychometric test you get online

Round 2 - HR 

(1 Question)

  • Q1. Standard interview you get with hr
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Job Portal and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. How would you share data with impact
  • Ans. 

    I would create visually appealing presentations, use storytelling techniques, and provide real-life examples to share data with impact.

    • Create visually appealing presentations to make data more engaging

    • Use storytelling techniques to help the audience connect with the data on a personal level

    • Provide real-life examples to illustrate the impact of the data in practical terms

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
-
Result
Selected Selected

I applied via Campus Placement and was interviewed before Nov 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

Exam of 30 to 40 questions

Round 2 - Technical 

(1 Question)

  • Q1. Basic rules of accounting, meaning of accountung, golden rules of accounting
  • Ans. 

    Basic rules of accounting include the meaning of accounting and the golden rules of accounting.

    • Accounting is the process of recording, summarizing, analyzing, and reporting financial transactions.

    • The basic rules of accounting include the principles of conservatism, consistency, materiality, and full disclosure.

    • The golden rules of accounting are: Debit the receiver, Credit the giver; Debit what comes in, Credit what goe...

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. Salary discussions

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare about accounts and company info

Interview Questionnaire 

1 Question

  • Q1. Mention some key financial ratios
  • Ans. 

    Financial ratios are used to evaluate a company's financial performance and health.

    • Liquidity ratios: measure a company's ability to meet short-term obligations

    • Profitability ratios: measure a company's ability to generate profits

    • Solvency ratios: measure a company's ability to meet long-term obligations

    • Efficiency ratios: measure how well a company utilizes its assets and liabilities

    • Examples include current ratio, return ...

  • Answered by AI
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via Naukri.com and was interviewed in Apr 2024. There were 2 interview rounds.

Round 1 - Technical 

(5 Questions)

  • Q1. Prepare All theoretical questions related to SQL and excel. Learn everything about your resume so that you will be able to explain each and everything about the resume.
  • Q2. Difference between Vlookup and Xlookup ?
  • Ans. 

    Vlookup searches for a value in the first column of a range and returns a value in the same row from a specified column. Xlookup is a more powerful and flexible function that can search in any direction and return multiple results.

    • Vlookup searches vertically in a table and returns a value from a specified column.

    • Xlookup can search in any direction (horizontal, vertical, or both) and return multiple results.

    • Vlookup requ...

  • Answered by AI
  • Q3. Difference between Subquery and CTE. Which is better?
  • Ans. 

    Subquery is a query nested within another query, while CTE is a temporary result set defined within a query. Both have their own use cases.

    • Subquery is enclosed in parentheses and can be used in SELECT, INSERT, UPDATE, or DELETE statements.

    • CTE is defined using the WITH keyword and can be referenced multiple times in a query.

    • CTEs are more readable and easier to maintain compared to subqueries.

    • Subqueries are useful when t...

  • Answered by AI
  • Q4. No of records returned after applying left and inner join on 2 tables.
  • Q5. Pivot the table in SQL using case when statements.
  • Ans. 

    Pivoting a table in SQL using case when statements

    • Use the CASE WHEN statement to create new columns based on specific conditions

    • Use the SUM or COUNT function to aggregate data in the pivoted table

    • Group by the remaining columns to ensure correct aggregation

    • Example: SELECT id, SUM(CASE WHEN category = 'A' THEN value END) AS A_total FROM table_name GROUP BY id;

  • Answered by AI
Round 2 - Case Study 

Business Case Questions Based on a scenario where the company's Sales is Declining. How we can address the issue using transaction data

Interview Preparation Tips

Topics to prepare for Landmark Group Business Analyst interview:
  • SQL
  • EXCEL
Interview preparation tips for other job seekers - Solve as many Business case studies as you can. Prepare well for SQL questions. You might get asked situation-based questions. Follow and show a structured approach while solving these questions. and you are good to go.

Skills evaluated in this interview

IPAC Interview FAQs

How many rounds are there in IPAC Lead Analyst interview?
IPAC interview process usually has 3 rounds. The most common rounds in the IPAC interview process are Resume Shortlist, HR and One-on-one Round.

Tell us how to improve this page.

People are getting interviews through

based on 1 IPAC interview
Company Website
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.

Interview Questions from Similar Companies

Deloitte Interview Questions
3.8
 • 2.8k Interviews
PwC Interview Questions
3.4
 • 1.3k Interviews
Ernst & Young Interview Questions
3.5
 • 1.1k Interviews
KPMG India Interview Questions
3.5
 • 767 Interviews
Landmark Group Interview Questions
4.0
 • 134 Interviews
Lowe's Interview Questions
4.2
 • 122 Interviews
Tesco Interview Questions
3.9
 • 120 Interviews
Target Interview Questions
4.2
 • 109 Interviews
Grant Thornton Interview Questions
3.7
 • 95 Interviews
View all
IPAC Lead Analyst Salary
based on 20 salaries
₹10 L/yr - ₹20 L/yr
At par with the average Lead Analyst Salary in India
View more details
Associate
157 salaries
unlock blur

₹4 L/yr - ₹13 L/yr

Senior Associate
79 salaries
unlock blur

₹10.3 L/yr - ₹21 L/yr

Analyst
61 salaries
unlock blur

₹4 L/yr - ₹10 L/yr

Campaign Manager
39 salaries
unlock blur

₹6 L/yr - ₹16 L/yr

Senior Analyst
36 salaries
unlock blur

₹8 L/yr - ₹14 L/yr

Explore more salaries
Compare IPAC with

KPMG India

3.5
Compare

Deloitte

3.8
Compare

PwC

3.4
Compare

Ernst & Young

3.5
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview