AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Ameriprise Financial Data Analyst Interview Questions and Answers
Ameriprise Financial Data Analyst Interview Experiences
1 interview found
Anonymous
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
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Data Analyst Interview Questions & Answers
ANZ Operations & Technology
PRITISAGAR SAHU
posted on 8 Nov 2024
(1 Question)
- Q1. How you calculate the tdi and mdi of a customer in sql
- Ans.
To calculate TDI and MDI of a customer in SQL, you need to aggregate and analyze the customer's transaction data.
Calculate Total Daily Income (TDI) by summing up the income of the customer for each day.
Calculate Monthly Daily Income (MDI) by averaging the TDI for each day in a month.
Use SQL functions like SUM, AVG, and GROUP BY to perform the calculations.
Example: SELECT SUM(income) AS TDI, AVG(income) AS MDI FROM tran
They asked about the sas,sql,and power bi
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Dec 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Different joins
- Q2. Case study
Revenue impact for casino
(1 Question)
- Q1. Technical.purely
(1 Question)
- Q1. Purely tech..and then you present a dashboard on power bi
shivam jindal
I applied via Approached by Company and was interviewed in Jan 2024. There were 2 interview rounds.
Sql questions based on aggregate and window
(2 Questions)
- Q1. Sql on windows function
- Q2. Python data and spark questions
Study hard that's it
(1 Question)
- Q1. Tell me about yourself
Basics in aptitude to be studied
Interview Preparation Tips
Selected
I applied via Walk-in and was interviewed in Aug 2023. There was 1 interview round.
(5 Questions)
- Q1. Tell me something about your projects?
- Q2. How much salary you expect?
- Q3. What is your strength and weakness?
- Q4. Tell me about yourself
- Q5. Why we are hiring you?
Interview Preparation Tips
- Advanced Excel
- SQL
(1 Question)
- Q1. EXPLAIN ABOUT YOUR PROJECT
Tuff question paper
(5 Questions)
- Q1. Random questions for you and your family
- Q2. Tell your background
- Q3. Tell me your education
- Q4. Tell me about yourself
- Q5. How much expect salary
Interview Preparation Tips
Kriti Shikha
Selected
I applied via Referral and was interviewed before Feb 2023. There were 3 interview rounds.
(1 Question)
- Q1. Tell me about yourself
(1 Question)
- Q1. SQL questions mainly on joining data
Salon business effectiveness in an area
Interview Preparation Tips
Ameriprise Financial Interview FAQs
Tell us how to improve this page.
Ameriprise Financial Interviews By Designations
- Ameriprise Financial Financial Planning Analyst Interview Questions
- Ameriprise Financial Financial Analyst Interview Questions
- Ameriprise Financial Analyst Interview Questions
- Ameriprise Financial Associate Interview Questions
- Ameriprise Financial Business Analyst Interview Questions
- Ameriprise Financial Operations Associate Interview Questions
- Ameriprise Financial Process Associate Interview Questions
- Ameriprise Financial Senior Analyst Interview Questions
- Show more
Data Analyst Interview Questions from Similar Companies
Fast track your campus placements
Ameriprise Financial Data Analyst Reviews and Ratings
based on 5 reviews
Rating in categories
|
Team Lead
221
salaries
|  ₹7.5 L/yr - ₹28 L/yr |
|
Senior Associate
208
salaries
| ₹3.8 L/yr - ₹13 L/yr |
|
Financial Planning Analyst
174
salaries
| ₹3.8 L/yr - ₹8.1 L/yr |
|
Associate
170
salaries
| ₹2.8 L/yr - ₹9.5 L/yr |
|
Group Leader
114
salaries
| ₹10 L/yr - ₹35 L/yr |
Morgan Stanley
Charles Schwab
UBS
Prudential Financial
- Home >
- Interviews >
- Ameriprise Financial Interview Questions >
- Ameriprise Financial Data Analyst Interview Questions
