AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
BNY
Compare
Filter interviews by
Clear (1)
BNY Senior Data Management Analyst Interview Questions, Process, and Tips
BNY Senior Data Management Analyst Interview Experiences
1 interview found
I applied via Approached by Company and was interviewed in Aug 2023. There were 3 interview rounds.
It was easy with basic financial background questions
(5 Questions)
- Q1. Difference between TWRR and MWRR
- Ans.
TWRR measures the compound rate of return over multiple sub-periods, while MWRR measures the rate of return over a single period.
TWRR considers the impact of cash flows during the investment period, while MWRR does not.
TWRR is more suitable for evaluating the performance of a portfolio over time, while MWRR is more suitable for evaluating the performance of a single investment.
TWRR is also known as the time-weighted ra...
- Q2. Does TWRR use cashflows
- Ans.
Yes, TWRR does use cashflows to calculate investment performance.
Time-Weighted Rate of Return (TWRR) takes into account the impact of cashflows on investment performance.
Cashflows are factored in to accurately measure the return on investment over time.
TWRR is commonly used in the finance industry to evaluate the performance of investment portfolios.
For example, if an investor adds or withdraws funds from their portfol...
- Q3. What is attribution
- Ans.
Attribution is the process of identifying and assigning credit to various touchpoints in a customer's journey that led to a desired outcome.
Attribution helps businesses understand the effectiveness of different marketing channels and campaigns.
Common attribution models include first touch, last touch, linear, and U-shaped.
Example: If a customer sees an ad on social media, then clicks on a Google ad, and finally makes a...
- Q4. How do you load instruments information
- Ans.
Instruments information is loaded by extracting data from various sources and importing it into a centralized database.
Extract data from external sources such as spreadsheets, databases, APIs, etc.
Transform the data into a standardized format suitable for the database.
Load the transformed data into the database using ETL tools or scripts.
Verify the accuracy and completeness of the loaded information.
Update the database...
- Q5. Which is better TWRR or MWRR and why
- Ans.
TWRR is better for measuring the performance of a portfolio over time, while MWRR is better for comparing the performance of different portfolios.
TWRR (Time-Weighted Rate of Return) is better for evaluating the performance of a portfolio over time as it eliminates the impact of external cash flows.
MWRR (Money-Weighted Rate of Return) is better for comparing the performance of different portfolios or investment options ...
Interview Preparation Tips
- MySQL
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Kautuk Kushansh
Interview Questionnaire
1 Question
- Q1. Probability based optimization problem
- Ans.
Probability based optimization problem
Probability based optimization problems involve finding the optimal solution considering uncertain outcomes
These problems often require the use of mathematical models and statistical analysis
Examples include portfolio optimization, resource allocation, and production planning
Solving such problems involves determining the probabilities of different outcomes and optimizing the decisi
Interview Preparation Tips
Experience: Basic CAT level questions of Data Sufficiency
Tips: CAT preparation would help. Strong basics in High school mathematics needed, along with some smart thinking at times.
Duration: 30 minutes
Total Questions: 50
Round: Case Study Interview
Experience: 15 minutes given for an almost impossible to get an answer problem. Later asked to explain your solution. The approach matters much much more than the final answer.
Tips: Be cool, think basics. Don't forget elementary things that units conversion, unitary methods, probability distributions etc. If while explaining, you realize you actually made a mistake while attempting the problem, acknowledge it and explain the correct approach from there on, rather than trying to disguise your mistake.
Round: Technical Interview
Experience: Things like, why Citi, prior experience with data analytics, examples from real life for mathematical concepts highlighted in Resume. Some general awareness related questions asked!
Tips: Be thorough through the resume. Act smart and reply what they want to hear. It's okay to ask them for a few minutes in case you want to think before answering something rather than mumbling what comes to your mind first!
Round: HR Interview
Experience: Again things like why Citi, why analytics. This round seemed more out of formality than for selection.
General Tips: Keep calm, and take the interview as a conversation - unless it's a stress interview. Always take your time and think before you answer anything rather than mumbling out the first thing that comes to your mind.
Skills: Probability, Statistics, Analytical skills
College Name: IIT MADRAS
Motivation: Needed a break into the Finance sector!
Anonymous
Interview Questionnaire
1 Question
- Q1. It was mostly about the instrument reference data and typical business analyst question about change management, BRD, Agile and technology we use.
I applied via Approached by Company and was interviewed before Mar 2021. There were 2 interview rounds.
(1 Question)
- Q1. SQL Questions, Case statements, Difference between Tree map and heat map, visualization charts, primary key foreign key
(1 Question)
- Q1. SSRS reporting, sql query test, group by, drill down reports
Interview Preparation Tips
I applied via Recruitment Consultant and was interviewed before Jun 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Project Overview BA/PO related questions Domain and Behavioral questions
Interview Preparation Tips
Be confident of the behaviour questions as per the past and practical experience
I applied via Naukri.com and was interviewed before Feb 2021. There was 1 interview round.
(1 Question)
- Q1. Be well prepared for technical round as this will be a make or break for you
Interview Preparation Tips
- Technical
I applied via Recruitment Consultant and was interviewed before Sep 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Do you still expect to get a hike in this pandemic
Interview Preparation Tips
Answer was
Frankly speaking getting a job in this pandemic would be enough fore but i think as per the name and big company like you should maintain the reputation and give a decent hike despite of a pandemic.
Interview Questionnaire
2 Questions
- Q1. Citi bank has to enter Indian Market where should it set up its offices?
- Ans.
Citi bank should set up its offices in major cities like Mumbai, Delhi, and Bangalore.
Citi bank should consider the economic and political stability of the region.
The bank should also consider the availability of skilled workforce and infrastructure.
Major cities like Mumbai, Delhi, and Bangalore have a large customer base and a well-established financial sector.
Setting up offices in multiple cities can help the bank re...
- Q2. If I am(interviewer) a client will you(interviewee) give me credit card?
Interview Preparation Tips
Experience: 10 single correct questions, 10 CAT based questions, 5 data sufficiency questions, 2 subjective questions were asked.
Tips: All the objective questions were easy so everyone would have solved. Subjective questions were important for selecting candidates .Final solution for subjective questions are not important ,the way you approach is important.
Duration: 45 minutes
Round: Case Study Interview
Experience: Questioned on Resume points. A case study was given and the student has to analyse it.
Round: Case Study Interview
Experience: Case study question and brain teaser were asked. Brainteaser was an easy question.
Skill Tips: Mock interviews with friends and ready with all resume points of how to explain them each helps. Solved many case studies. Updated myself with latest news. I also read Wiki questions like how to get 3 wolnes, 2 men to other side of river?.
Skills: Soft skills, Case study solving ability
College Name: IIT MADRAS
Interview Questionnaire
3 Questions
- Q1. Problem on Probability and Optimization
- Q2. Questions based on Data Analysis, General Awareness and Resume-based questions
- Q3. Basic HR Questions such as 'Tell me abour yourself.' and a few random questions
Interview Preparation Tips
Experience: It was basic 12th class maths such as probability, permutation andcombination and things, and stuff such as data sufficiency where a question is provided with some data and you will be asked whether you will able to solve it or not with the help of given data.
Overall good experience, About 40 students were selected.
Tips: Prepare well the part of quantitative and analytical analysis in CAT's syllabus.
Round: Case Study Interview
Experience: It was a good round with questions mainly focused on probability and statistics, and optimization.
Tips: Basic knowledge of probability and statistics will do.
Round: Technical Interview
Experience: The round was a long one, with questions on data analysis and about current economic affairs in the world.
They also discussed about things mentioned in resume in detail.
Tips: 1. Be through with your resume with explanation for each point in mind.
2. Gather the knowledge about current affairs. Try to read newspapers such as The Economic Times for at least 2 months prior to interview.
Round: HR Interview
Experience: Questions were asked on ourselves to judge the personality and a few random questions as per HR.
Tips: Be prepared with questions such as:
1. Tell me about yourself.
2. Strengths and Weaknesses.
3. Why this company?
4. Why should you be hired?
And a few more of typical questions. Keep your mind open for anything.
General Tips: 1. Read newspapers such as The Economic Times for at least two months prior to interview.
2. Prepare well on basic maths especially topics covered in CAT.
3. Be through with points mentioned in resume with a ready explanation for each.
Skill Tips: Basic knowledge will do. Try to practice more.
And read more stuff.
Skills: Knowledge in Probability and Statistics, Basics in Operation Research (Optimization)., Quantitative aptitude.
College Name: IIT MADRAS
Interview Questionnaire
2 Questions
- Q1. Why do you think this works? What are the drawbacks?
- Ans.
This question is asking for an analysis of the effectiveness and drawbacks of a certain approach or solution.
The question is asking for an evaluation of why a particular approach or solution is effective.
The answer should also include an analysis of the drawbacks or limitations of the approach.
Examples and evidence should be provided to support the analysis.
The response should demonstrate critical thinking and the abil...
- Q2. Why Citi? Why not higher studies?
Interview Preparation Tips
Tips: Could use C/C++/Java to solve,
Duration: 120 minutes
Total Questions: 62
Round: Other Interview
Experience: Simple puzzles, Basic data structures and algorithms based question were asked.
Round: Other Interview
Experience: Asked about my Analytics intern – Explained some Text mining, machine learning techniques like Artificial Neural Networks. Also DDP and Projects – some Regression and Time Series Concepts.
Round: HR Interview
Experience: Basic HR and background check, Also Check if you are genuinely interested and will not leave the company.
General Tips: Talk to people, read stuff, find out what interests you. Decide a few areas and prepare for those. Take part in insti clubs, get to know new stuff.There are a number of free online video courses available like coursera, edX, etc. Have a look at these, pick up one or two, learn whenever you have time. If possible, even submit the assignments and give the quizzes. A programming language cannot be learned just by reading a book or watching videos. You have to practice and do somehands-on exercises.While preparing for Puzzles and coding questions, do not directly go to the solution, always make an attempt, scribble your thoughts on a piece of paper.Participate in competitions (for both core and non-core), you ll learn a lot through such experiences than what you learn from textbooks.
Skill Tips: Speak confidently and explain your projects in simple terms. Ask if they want further explanation, and only then talk about it in depth.
College Name: IIT MADRAS
BNY Interview FAQs
Recently Viewed
REVIEWS
SMFG India Credit
No Reviews
INTERVIEWS
BNY
No Interviews
INTERVIEWS
BNY
No Interviews
SALARIES
Aurobindo Pharma
REVIEWS
Aurobindo Pharma
No Reviews
REVIEWS
SMFG India Credit
No Reviews
REVIEWS
SMFG India Credit
No Reviews
REVIEWS
SMFG India Credit
No Reviews
JOBS
Gateway Distriparks
No Jobs
SALARIES
Aurobindo Pharma
Tell us how to improve this page.
BNY Interviews By Designations
- BNY Senior Associate Interview Questions
- BNY Software Developer Interview Questions
- BNY Analyst Interview Questions
- BNY Intermediate Representative Interview Questions
- BNY Associate Interview Questions
- BNY Senior Analyst Interview Questions
- BNY Senior Representative Interview Questions
- BNY Software Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
- Data Analyst Interview Questions
- Data Engineer Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Senior Data Engineer Interview Questions
- Data Management Associate Interview Questions
- Senior Data Analyst Interview Questions
- Senior Data Scientist Interview Questions
- Show more
BNY Senior Data Management Analyst Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
BNY Senior Data Management Analyst Reviews and Ratings
based on 1 review
Rating in categories
|
Analyst
1.9k
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Senior Analyst
1.7k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Associate
1.2k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Intermediate Representative
1.1k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Vice President
1k
salaries
| ₹0 L/yr - ₹0 L/yr |
State Street Corporation
Northern Trust
HSBC Group
JPMorgan Chase & Co.
- Home >
- Interviews >
- BNY Interview Questions >
- BNY Senior Data Management Analyst Interview Questions
