Upload Button Icon Add office photos

Filter interviews by

Invesco Senior Data Analyst Interview Questions and Answers

Updated 20 Jan 2023

Invesco Senior Data Analyst Interview Experiences

1 interview found

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

I was interviewed in Dec 2022.

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 - Technical 

(1 Question)

  • Q1. About end to end Investment banking terminology. SQL Quires
Round 3 - Technical 

(1 Question)

  • Q1. Some SQL Questions and Behavioral questions Capital Market question.. Like what is CDS and how it works
Round 4 - HR 

(1 Question)

  • Q1. Is it ok for Relocation,
  • Ans. 

    Yes, I am open to relocation for the right opportunity.

    • I am willing to relocate for a position that aligns with my career goals and offers growth opportunities.

    • I am open to considering relocation packages and assistance.

    • I am excited about the prospect of exploring new cities and cultures.

    • Examples: I have previously relocated for a job and found it to be a positive experience.

    • I am willing to discuss relocation during th

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Capital Market and investment banking domain is IMP

Interview questions from similar companies

Interview experience
3
Average
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 tips
Round 2 - Aptitude Test 

Questions mainly based on capital market

Round 3 - Technical 

(5 Questions)

  • Q1. Question mainly based on 3 financial statements
  • Q2. Link between 3 financial statements
  • Ans. 

    The link between the 3 financial statements (Income Statement, Balance Sheet, Cash Flow Statement) is that they are interconnected and provide a comprehensive view of a company's financial performance.

    • Income Statement shows the company's revenues and expenses over a period of time, which affects the company's net income.

    • Balance Sheet shows the company's assets, liabilities, and equity at a specific point in time, which...

  • Answered by AI
  • Q3. What is Interest coverage ratio
  • Ans. 

    Interest coverage ratio measures a company's ability to pay interest on its debt with its earnings.

    • Interest coverage ratio is calculated by dividing a company's earnings before interest and taxes (EBIT) by its interest expenses.

    • A higher interest coverage ratio indicates that a company is more capable of meeting its interest obligations.

    • A lower interest coverage ratio may signal financial distress and an increased risk ...

  • Answered by AI
  • Q4. What is GAAP & Non-GAAP EPS
  • Ans. 

    GAAP EPS is based on generally accepted accounting principles, while Non-GAAP EPS excludes certain expenses or income that are not considered part of normal operations.

    • GAAP EPS follows accounting standards set by regulatory bodies like SEC

    • Non-GAAP EPS excludes items like one-time expenses or gains to provide a clearer picture of ongoing business performance

    • Investors often consider both GAAP and Non-GAAP EPS when evalua

  • Answered by AI
  • Q5. What is amortisation
  • Ans. 

    Amortisation is the process of spreading out the cost of an intangible asset over its useful life.

    • Amortisation is similar to depreciation, but it is used for intangible assets such as patents, copyrights, and trademarks.

    • It helps in matching the expense of the intangible asset with the revenue it generates over time.

    • The amortisation expense is recorded on the income statement and reduces the value of the intangible asse...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Good communication will help and be confident
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Mar 2023. There were 2 interview rounds.

Round 1 - One-on-one 

(3 Questions)

  • Q1. Basic & intermediate SQL questions
  • Q2. Second highest salary of employee
  • Q3. DBMS key concepts and explation with examples of use case
  • Ans. 

    DBMS key concepts and examples of use cases

    • DBMS stands for Database Management System

    • Key concepts include data modeling, query optimization, transaction management

    • Use cases include online transaction processing (OLTP), data warehousing, customer relationship management (CRM)

    • Examples: MySQL for OLTP, Oracle for data warehousing, Salesforce for CRM

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

(1 Question)

  • Q1. Techno business related questions

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Talked about previous experience in detail.
  • Q2. Asked some case studies regarding their products

Interview Preparation Tips

Interview preparation tips for other job seekers - I expected the first round to be technical, but it turned out to be causal one on one. Didn't exactly understand what they are expecting from the candidate.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Oct 2024. There was 1 interview round.

Round 1 - Aptitude Test 

Basic aptitude test like distance problem , age etc

Interview Preparation Tips

Interview preparation tips for other job seekers - Sql , logic based question
Interview experience
2
Poor
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - Coding Test 

Top 7 th employee salary
Find Duplicates

Round 2 - Technical 

(3 Questions)

  • Q1. Trigger Stored procedure
  • Ans. 

    A trigger is a special type of stored procedure that is automatically executed when certain events occur in a database.

    • Triggers are used to enforce business rules, maintain data integrity, and automate tasks.

    • They can be set to execute before or after INSERT, UPDATE, or DELETE operations on a table.

    • For example, a trigger can be created to update a log table whenever a new record is inserted into a main table.

  • Answered by AI
  • Q2. Gateway Different modes in power bi
  • Ans. 

    Power BI has different modes like View, Edit, and Data Source.

    • View mode allows users to interact with reports and dashboards

    • Edit mode enables users to modify existing reports and create new ones

    • Data Source mode allows users to connect to and manipulate data sources

  • Answered by AI
  • Q3. Nothing to get importance no words

Skills evaluated in this interview

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

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

Round 1 - One-on-one 

(2 Questions)

  • Q1. Define your dataset and what difficulties you have faced while preparing your model ?
  • Ans. 

    The dataset consists of customer purchase history and demographic information. Difficulties faced include data cleaning and missing values.

    • Dataset includes customer ID, purchase amount, purchase date, age, gender, and location.

    • Difficulties faced include handling missing values in the age and location columns.

    • Data cleaning involved removing duplicates and outliers to ensure accurate analysis.

    • Normalization and standardiz

  • Answered by AI
  • Q2. What is Normalization and standardization
  • Ans. 

    Normalization and standardization are techniques used to rescale data to have a mean of 0 and a standard deviation of 1.

    • Normalization is the process of rescaling the data to have values between 0 and 1.

    • Standardization is the process of rescaling the data to have a mean of 0 and a standard deviation of 1.

    • Normalization is useful when the features have different ranges.

    • Standardization is useful when the features have diff...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and ne honest.

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What is K means
  • Ans. 

    K-means is a popular clustering algorithm used to partition data points into K clusters based on similarity.

    • K-means aims to minimize the sum of squared distances between data points and their respective cluster centroids.

    • It requires the number of clusters (K) to be specified in advance.

    • The algorithm iteratively assigns data points to the nearest cluster centroid and updates the centroids until convergence.

    • K-means is se...

  • Answered by AI
  • Q2. Type 1 and Type 2 error

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Assignment 

Study hard that's it

Round 2 - HR 

(1 Question)

  • Q1. Tell me about yourself
Round 3 - Aptitude Test 

Basics in aptitude to be studied

Interview Preparation Tips

Interview preparation tips for other job seekers - Stay polite

I applied via Recruitment Consultant and was interviewed in Jul 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Data manipulation using pandas and SQL
  • Ans. 

    Data manipulation using pandas and SQL

    • Pandas is a Python library used for data manipulation and analysis

    • SQL is a language used for managing relational databases

    • Pandas can read data from SQL databases using the read_sql() function

    • Data can be filtered, sorted, grouped, and aggregated using pandas functions

    • SQL queries can be executed using pandas' read_sql_query() function

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep the communication simple and clear, explain the work experience clearly

Skills evaluated in this interview

Invesco Interview FAQs

How many rounds are there in Invesco Senior Data Analyst interview?
Invesco interview process usually has 4 rounds. The most common rounds in the Invesco interview process are Technical, Resume Shortlist and HR.
How to prepare for Invesco Senior Data Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Invesco. The most common topics and skills that interviewers at Invesco expect are Business Analysis, Data Analysis, Data Management, data governance and Data Quality.
What are the top questions asked in Invesco Senior Data Analyst interview?

Some of the top questions asked at the Invesco Senior Data Analyst interview -

  1. is it ok for Relocati...read more
  2. Some SQL Questions and Behavioral questions Capital Market question.. Like what...read more
  3. About end to end Investment banking terminology. SQL Qui...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

Goldman Sachs Interview Questions
3.6
 • 401 Interviews
Morgan Stanley Interview Questions
3.7
 • 296 Interviews
Morningstar Interview Questions
4.0
 • 237 Interviews
FactSet Interview Questions
4.0
 • 201 Interviews
Apex Group Interview Questions
2.7
 • 122 Interviews
Kotak Securities Interview Questions
3.7
 • 108 Interviews
Blackrock Interview Questions
3.8
 • 101 Interviews
Axis Direct Interview Questions
3.8
 • 76 Interviews
View all
Invesco Senior Data Analyst Salary
based on 8 salaries
₹14.3 L/yr - ₹18 L/yr
42% more than the average Senior Data Analyst Salary in India
View more details
Senior Analyst
140 salaries
unlock blur

₹4.8 L/yr - ₹16.8 L/yr

Analyst
66 salaries
unlock blur

₹3 L/yr - ₹12.1 L/yr

Advanced Engineer
64 salaries
unlock blur

₹7.5 L/yr - ₹22 L/yr

Team Lead
64 salaries
unlock blur

₹8.9 L/yr - ₹25 L/yr

Senior Associate
55 salaries
unlock blur

₹4.5 L/yr - ₹12 L/yr

Explore more salaries
Compare Invesco with

Blackrock

3.8
Compare

Vanguard

4.1
Compare

Fidelity Investments

4.3
Compare

State Street Global Advisors

3.7
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