Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by BNY Team. If you also belong to the team, you can get access from here

BNY Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

BNY Database Manager Interview Questions and Answers

Updated 10 Dec 2024

BNY Database Manager Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(4 Questions)

  • Q1. What currently you are doing in your project?
  • Ans. 

    I am currently leading a team in designing and implementing a new database system for our project.

    • Leading a team in designing a new database system

    • Implementing the new database system

    • Ensuring data integrity and security measures are in place

  • Answered by AI
  • Q2. How proficient you are in SQL?
  • Ans. 

    I am highly proficient in SQL with extensive experience in writing complex queries, optimizing database performance, and designing database schemas.

    • Extensive experience writing complex SQL queries

    • Optimizing database performance through SQL

    • Designing database schemas using SQL

    • Familiar with advanced SQL concepts such as joins, subqueries, and indexing

  • Answered by AI
  • Q3. Why you have gap before MBA?
  • Ans. 

    I took a gap to gain practical work experience and save money for my MBA.

    • To gain practical work experience relevant to my field of study

    • To save money for tuition and living expenses during my MBA program

    • To take a break and reassess my career goals before committing to further education

  • Answered by AI
  • Q4. Explain procedures from SQL.
  • Ans. 

    SQL procedures are reusable blocks of code that can be called to perform a specific task.

    • Procedures are created using the CREATE PROCEDURE statement.

    • They can accept input parameters and return output parameters.

    • Procedures can be called using the EXECUTE or CALL statement.

    • They are used to encapsulate logic for tasks that need to be performed repeatedly.

    • Procedures can improve performance by reducing network traffic.

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

Associate Interview Questions & Answers

JPMorgan Chase & Co. user image SHUBHAM VINAYAK KALE shubham

posted on 4 Dec 2016

I applied via Campus Placement and was interviewed in Dec 2016. There were 5 interview rounds.

Interview Questionnaire 

8 Questions

  • Q1. Project/DDP based questions
  • Q2. Any coding done in curriculum, explain the most complex one
  • Ans. 

    Yes, I have coded in curriculum. The most complex one was a project on building a web application using React and Node.js.

    • Built a full-stack web application using React and Node.js

    • Implemented user authentication and authorization using JSON Web Tokens (JWT)

    • Used MongoDB as the database and Mongoose as the ODM

    • Implemented real-time updates using Socket.IO

    • Deployed the application on Heroku

    • Handled errors and implemented log

  • Answered by AI
  • Q3. What is 'Big data'? Why is it called 'Big'
  • Ans. 

    Big data refers to large and complex data sets that cannot be processed using traditional data processing methods.

    • Big data is characterized by its volume, velocity, and variety

    • It is used in various industries such as healthcare, finance, and retail

    • Examples of big data include social media data, sensor data, and transactional data

    • It is called 'big' because it involves processing massive amounts of data

    • Big data requires ...

  • Answered by AI
  • Q4. Why do you want to switch to IT sector from your respective branch
  • Ans. 

    I am passionate about technology and eager to learn new skills in the IT sector.

    • I have always had a keen interest in technology and enjoy working with computers.

    • I believe the IT sector offers more opportunities for growth and advancement in my career.

    • I have seen the impact of technology on various industries and want to be a part of that innovation.

    • I have taken courses in programming and networking to prepare myself fo

  • Answered by AI
  • Q5. I did a course on compute simulation and had extra curricular in chess, so was asked to simulate a chess game
  • Q6. Two friends A & B meet after long time, A asks B about his family. B says he has 3 children, product of their ages is 36, and sum of their ages is equal to the (point towards a house on street) house numbe...
  • Q7. A rat has 3000 gm of rice, he has to travel a distance of 3000m, he eats 1gm rice/m, his maximum carrying capcity is 1000 gm,how should he travel the distance to reach with maximum rice left
  • Q8. A new software has 3 functions SelectSum(), log() and exp(). You have a table of 1000 data points, how will you find product of all points using only the above mentioned functions
  • Ans. 

    To find the product of all data points using SelectSum(), log(), and exp() functions.

    • Use the log() function to convert the product into a sum of logarithms

    • Apply the SelectSum() function to calculate the sum of logarithms

    • Finally, use the exp() function to convert the sum back into the product

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: Aptitude part has easy questions, including number series, picture series, interest rate and some quant based questions.

The coding part is difficult.2-3 coding questions, Codes will be related to linked lists , trees or sorting.
Tips: Try to get maximum marks in aptitude, which should be fine with some practice . One of the code will be easy, so complete it and make a try for second
Duration: 1 hour
Total Questions: 30

Round: Puzzle Interview
Experience: very easy puzzles, I was able to solve all puzzles in first attempt
Tips: Be confident in your approach they are locking for approach more than result

Round: Technical Interview
Experience: I answered all resume based questions, he liked my choice of projects, though they were not exactly related to the profile. He liked me and said I would recommend you directly to HR round
Tips: Prepare in details about all points in resume, course work mentioned and projects, Based on performance in this interview, they decide to whether to take one more technical interview or send directly to HR

Skills: Behavioural Skills, Puzzle Solving Capability, Approaching A Problem, Basic Coding
College Name: IIT Madras

Skills evaluated in this interview

I applied via Campus Placement and was interviewed in Dec 2016. There were 5 interview rounds.

Interview Questionnaire 

13 Questions

  • Q1. Tell me about yourself?
  • Ans. 

    I am a highly motivated individual with a passion for learning and achieving my goals.

    • I have a degree in computer science and have worked as a software developer for 3 years.

    • I am proficient in multiple programming languages including Java, Python, and C++.

    • I enjoy working in a team environment and collaborating with others to solve complex problems.

    • In my free time, I enjoy hiking and exploring new places.

  • Answered by AI
  • Q2. Tell me about your family or life before college?
  • Ans. 

    I grew up in a small town with my parents and younger sister. We were a close-knit family.

    • Grew up in a small town

    • Close-knit family

    • Parents and younger sister

    • Participated in community events

    • Enjoyed outdoor activities

  • Answered by AI
  • Q3. What do you do in free time?
  • Ans. 

    I enjoy reading, hiking, and trying new recipes in my free time.

    • Reading books on various topics, including fiction, non-fiction, and self-improvement

    • Hiking in local parks and nature reserves to explore new trails and enjoy the outdoors

    • Experimenting with new recipes and cooking techniques in the kitchen

    • Attending cultural events such as concerts, plays, and art exhibits

    • Spending time with family and friends, playing board

  • Answered by AI
  • Q4. What would you expect from this company?
  • Ans. 

    I would expect a supportive work environment, opportunities for growth and development, and a commitment to excellence.

    • Supportive and collaborative team culture

    • Clear communication and feedback

    • Opportunities for professional development and advancement

    • Commitment to high-quality work and customer satisfaction

    • Competitive compensation and benefits package

  • Answered by AI
  • Q5. Questions related to family and past life?
  • Q6. Do you have any family member or friend in Bangalore?
  • Ans. 

    Yes, I have a cousin who lives in Bangalore.

    • I have a cousin who has been living in Bangalore for the past 5 years.

    • We keep in touch and he has shown me around the city during my visits.

    • He works in the IT industry and enjoys the vibrant culture of Bangalore.

  • Answered by AI
  • Q7. How will you find loop in the circular linked list?
  • Ans. 

    Loop in a circular linked list can be found using Floyd's cycle-finding algorithm.

    • Initialize two pointers, slow and fast, both pointing to the head of the linked list.

    • Move slow pointer by one node and fast pointer by two nodes in each iteration.

    • If there is a loop, both pointers will eventually meet at some point.

    • If there is no loop, fast pointer will reach the end of the linked list.

    • Time complexity of this algorithm is

  • Answered by AI
  • Q8. How will you perform pre-fix and post-fix operation for the given string expression?
  • Ans. 

    Pre-fix and post-fix operations can be performed on a string expression using appropriate operators.

    • Pre-fix operation involves placing the operator before the operand in the expression.

    • Post-fix operation involves placing the operator after the operand in the expression.

    • Examples of pre-fix operators include ++, --, !, and ~.

    • Examples of post-fix operators include ++ and --.

  • Answered by AI
  • Q9. What is data analytics(cause I had mentioned it on the resume)? Just explain the basic and tell them how it can help us make decision/inference
  • Ans. 

    Data analytics is the process of examining data sets to draw conclusions about the information they contain.

    • Data analytics involves collecting, cleaning, and analyzing data to identify patterns and trends.

    • It can help businesses make informed decisions by providing insights into customer behavior, market trends, and operational efficiency.

    • For example, a retail company can use data analytics to analyze sales data and ide...

  • Answered by AI
  • Q10. In my final year project I have used random forest. So he asked me to explain random forest. And other projects related questions
  • Q11. What is your strength and weakness? why J P Morgan Chase? What do you expect from this company? I am from Mechanical Engineering, so she asked me why non-core?
  • Ans. 

    Strengths include adaptability and teamwork. Weaknesses include public speaking. Non-core background allows for diverse perspective. JPMorgan Chase's reputation and opportunities attract me.

    • Strengths: adaptability, teamwork

    • Weakness: public speaking

    • Non-core background brings diverse perspective

    • Attracted to JPMorgan Chase's reputation and opportunities

  • Answered by AI
  • Q12. Few behavioral questions: What will you do if you have enough money and good idea to start your own company?
  • Ans. 

    I would pursue my entrepreneurial dream and start my own company.

    • I would conduct market research to validate my idea and identify potential competitors.

    • I would create a business plan outlining my goals, strategies, and financial projections.

    • I would secure funding through investors or loans.

    • I would assemble a team of talented individuals with diverse skills and experiences.

    • I would continuously evaluate and adapt my busi

  • Answered by AI
  • Q13. How would you resolve team conflict between your idea and other idea, supported by majority?
  • Ans. 

    I would listen to both sides, gather more information, and try to find a compromise that satisfies everyone.

    • Listen to both sides and understand their perspectives

    • Gather more information about both ideas

    • Try to find common ground and a compromise that satisfies everyone

    • Encourage open communication and respect for each other's ideas

    • Consider the potential impact and benefits of each idea

    • Involve a neutral third party if nec

  • Answered by AI

Interview Preparation Tips

Round: Resume Shortlist
Experience: The company came to our campus on day 3 and agreed to take walk-ins.
Therefore resume shortlisting was the procedure.
They had a cut off of 7 CGPA.
Tips: It would be good if you have some coding background with few projects. It could anything from class projects to your internships, extra-curricular or final year projects. Don't forget to mention what all programming language you know on your resume.

Round: Technical + HR Interview
Experience: The first round consists of two panels. One of them was asking HR. And the other was asking technical questions. They were just looking whether you have the basic technical knowledge and if given an offer you will join or not.
Tips: For technical knowledge, you can refer OOPs basic concepts, standard coding interview problems, geeksforgeeks, cracking the coding interview by Laxman Gayle etc. It would be better if you can first practice hr questions among your friends instead of going directly to interview. I found a youtube channel explains technical relatively easier and simpler way. you can follow that. Just try to show that you are interested in that company.
For HR questions, one can prepare from 64 HR questions.
For the basic OOPs concepts, one can read first 10 chapters from E.Balaguruswamy but any other OOPs book will also be fine.
Confidence is the key ace any interview!!

Round: HR Interview
Experience: This round was mainly to check your personality. He was trying to know whether you will fit in the company or not. Most of the question was from my personal life. They will see whether you are serious about your life or not.
Tips: Be ready to give them instances of your life where you did things differently. Try to show that you are passionate about the company. Try to show you have a clear vision in your life and working hard to achieve that.

Round: HR Interview
Experience: This round was just a formality. The HR from the second round interview introduced me to the third interviewer. He asked few question related to the family.
Tips: One important thing I would like to is that NEVER ASSUME THAT WHATEVER YOU TOLD TO YOUR PREVIOUS INTERVIEWER WILL BE KNOWN TO THE NEXT INTERVIEW. So, if you think some specific points will help you do good in an interview...just let him know. I could be anything your project, conference, paper presentation or your past life as well.

Skills: Programming, Object Oriented Programming (OOP) Basics, Team Working Ability, Passion, Data Strrutures, Algorithm
College Name: IIT Madras

Skills evaluated in this interview

I applied via Campus Placement and was interviewed in Dec 2016. There were 3 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Tested DSA and Aptitude
  • Q2. Checked design aspect questions
  • Q3. What do you know about company
  • Ans. 

    Company is a global technology company known for its innovative products and services.

    • Founded in 1976 by Steve Jobs, Steve Wozniak, and Ronald Wayne.

    • Known for products such as iPhone, iPad, Mac computers, and Apple Watch.

    • Offers services like Apple Music, iCloud, and Apple Pay.

    • Has a strong focus on design and user experience.

  • Answered by AI

Interview Preparation Tips

College Name: IIT Madras

I was interviewed in Dec 2016.

Interview Questionnaire 

5 Questions

  • Q1. Write the algorithm for reversing the string
  • Ans. 

    The algorithm reverses a given string.

    • Iterate through the string from the last character to the first character.

    • Append each character to a new string or an array in reverse order.

    • Return the reversed string or array.

  • Answered by AI
  • Q2. Write an algorithm to select the number between min and maximum from a number series and that number shouldn't be a multiple of 10
  • Q3. This was puzzle: you have 2 eggs and 100 floors. Eggs will start break beyond a particular floor. You can throw eggs from any of the floor. How will you minimise the total number of throws.
  • Q4. Assume yourself as CEO of a company. You have vacancies and you are conducting interviews. 4 candidates (1. An IITian, 2. A woman, 3. Gay, 4.Physically handicapped) are equally capable and qualified have a...
  • Ans. 

    As the CEO, I would select the candidate based on their qualifications and skills, regardless of their background or personal characteristics.

    • I would focus on the qualifications, skills, and experience of each candidate.

    • I would consider their ability to contribute to the company's goals and objectives.

    • I would ensure a fair and unbiased selection process.

    • I would prioritize diversity and inclusion in the workplace.

    • I woul...

  • Answered by AI
  • Q5. My interview was just after demonetization. So question was, assume you are CEO of Paytm. What will be your key values and what will be your strategy to add more customers.

Interview Preparation Tips

Round: Test
Experience: Aptitude part was pretty straightforward. Make sure you don't loose too much time on one question. Most of the questions were very easy. Number series, men working hours, probability and simple math calculations are enough to crack the test.
Coding part will definitely have one easy question (mostly will be on sorting algos). Basic coding knowledge is enough for this part.
Tips: Aptitude : Speed is the key. Since questions are easy, one who gets more than others will be shortlistled for the Interviews.
Coding: Make sure you solve atleast 1 problem correctly. And then try to attempt others.
Duration: 1 hour
Total Questions: 28

Round: Behavioural Interview
Experience: They also asked basic interview hr questions. Be prepared with your stories. If One of your story can make you look out of the stand, it will definitely work for this round. Strengths, weakness and where do you see yourself after 5 years.
Tips: Be confident. And be ready to defend your answers.

Skills: Math Puzzles, Algorithms And Data Structures, HR Skills, Inter Person Communication Skills
College Name: IIT Madras

Skills evaluated in this interview

Interview Questionnaire 

1 Question

  • Q1. Asked many Dbsa questions. You need to be thorough about the joins in the databases.

Interview Preparation Tips

Round: Test
Experience: Practice questions on Indiabix.

Round: Technical Interview
Experience: Operating Systems basics, Dbsa basics

General Tips: 1: Be Confident.
2: Keep Smiling.
3: Do not be Panic.
4: Remember they are here to hire you but not reject you.
5: Do not loose hope.
6: Believe at yourself.
7: Start preparing early.
8: Do demo interviews with your friend.
Skill Tips: Make sure you do a course on object oriented programming
Skills: C, Sql, Java
College Name: BITS PILANI
Motivation: Every body joins a comapny for making a software or earning money. But I was always motivated to MAKE MONEY. I have taken this job because they have very extensive work in Share Market and they have lots of MBA from IIM's, Lots of CAs, CS. Thats why i have choosen Edelweiss. I have rejected epic System USA for this profile.

Interview Questionnaire 

4 Questions

  • Q1. Tell me about your internship, B.Tech project(BTP), CV
  • Q2. Implement LRU cache.
  • Ans. 

    Implement LRU cache

    • LRU stands for Least Recently Used

    • It is a cache eviction policy that removes the least recently used item

    • It can be implemented using a doubly linked list and a hash map

    • Newly accessed items are moved to the front of the list

    • When the cache is full, the item at the end of the list is removed

  • Answered by AI
  • Q3. What is virtual memory? Will we need virtual memory even if we have infinite amount of RAM?
  • Ans. 

    Virtual memory is a memory management technique that allows a computer to use more memory than it physically has.

    • Virtual memory uses a combination of RAM and hard disk space to store data.

    • It allows programs to use more memory than is physically available.

    • If a program tries to access memory that is not currently in RAM, it will be swapped in from the hard disk.

    • Even if we had infinite RAM, virtual memory would still be n...

  • Answered by AI
  • Q4. Given an array, Find out maximum length of subarray where max of subarray <= 2*min of subarray
  • Ans. 

    Find maximum length of subarray where max <= 2*min.

    • Iterate through array and keep track of max and min values.

    • Update max length when condition is met.

    • Time complexity: O(n)

  • Answered by AI

Interview Preparation Tips

Round: Resume Shortlist
Experience: No CPI cut off and It was open for all departments.

Round: Test
Experience: In muliple choice question Mostly questions were base on maths, probability, c programs, algorithms, Systems. If you are prepared then Questions were not that much tough. Keep strong concepts of Operating systems. For subjective part, Some problems were from maths proofs, some were from probability, some were from algo. We had to write algorithms. etc
Duration: 180 minutes

Round: Problem Statement
Experience: Questions were doable.

Round: Interview
Experience: Everyone was cool, They made me feel comfortable and then started asking questions.
Tips: If you have good rank in online coding competition, do mention it in CV.Most of the students think that GS asks only probability-puzzles. They did not asked me any question on probability or puzzle. Everything they asked was based on Algorithms problems and Operating system. I think it depends on team for which they are hiring. Most important point is don’t lose hope because you have low CPI or you are not good at something. Keep Operating systems fundamental concepts strong.

General Tips: We should balance in Placement and Compititive online coding. Keep in mind Placements and Compititive online coding are some what different things. Keep on improving our mistakes on daily basis. I would strongly suggest you to do introspection daily it will help you to find out your weaknesses and strong points, where we are going wrong etc. There are two thing on which we shoud focus.1. Preparation (I have told everything requered for preparation).2. Get output of all hard work. How to keep our mind on 100% output while the actual exam(placement).For this, I used to go for physical exercise daily in the morning and medidate for 20-30 minutes. Along with exercise i used to do Sudarshan Kriya(Art of Living). Meditation has lot of power :).
Skill Tips: Keep your OS fundamentals strong. To improve codgin skills practice as many problems as you can. Regularly participate in online coding competitions it really helps to solve or approach any new problem. Many time instead of correct answer the approach to solve the problems is very important. How you think, How you approach the problem is checked in interview.
Skills: Coding Skills, Operating Systems , Problem solving skills
College Name: IIT Guwahati
Motivation: The name GS itself enogh for motivation.

Skills evaluated in this interview

Interview Preparation Tips

Round: Test
Experience: The written test was quite similar to the typical CAT pattern. It contained sections on Reading Comprehension, Data Interpretation and Mathematics.

Round: Technical + HR Interview
Experience: There were 2 interviewers in the first interview, one was a technical guy and the other was from HR. They asked me a few very simple puzzles, a few basic programming questions (swapping the value of two variables etc.), questions related to the development cycle of software products. The HR guy asked stuff like what do you want to achieve in life? Strengths, weaknesses etc.

Round: Case Study Interview
Experience: The third interview was the most important one (and I guess that was the deciding interview). The interviewer started with questions like why finance? Which companies are you sitting for? Then he gave me a case study:

Interview Questionnaire 

2 Questions

  • Q1. Demonetization
  • Q2. Banking sector questions

Interview Preparation Tips

Round: Test
Experience: Basic aptitude test. East to clear.
Duration: 1 hour
Total Questions: 25

Skills: Reasoning Ability, Mathematical Logic, Logical Reasoning, General Knowledge
College Name: Sri Bhagawan Mahaveer Jain

Interview Questionnaire 

2 Questions

  • Q1. Oops, os, dbms, project
  • Q2. Why hsbc, why should I hire you.
  • Ans. 

    I have a strong background in software engineering and a passion for innovation, making me a valuable asset to HSBC.

    • I have a proven track record of successfully delivering high-quality software solutions in previous roles.

    • I am highly skilled in various programming languages and technologies, including Java, Python, and SQL.

    • I have experience working in agile development environments, allowing me to adapt quickly to chan...

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: 4 sections, 15 questions each. Sections on apti, english, programming, technical.
Tips: Time management, complete english and technical first
Duration: 1 hour
Total Questions: 60

Round: Group Discussion
Experience: We were asked which super hero would you like to be. Shared the information. Always present the positives and negatives and emphasize that despite of being negatives
Tips: Think everything through before speaking
Duration: 40 minutes

Round: Technical Interview
Experience: Prepare well, anything can be asked on the things written on your resume

Round: HR Interview
Experience: Sell yourself. Tell them why you would be the best candidate.
Tips: Tell your advantages of being a fresher that you would be comfortable in any technology

College Name: Acropolis institute of technology and research
Contribute & help others!
anonymous
You can choose to be anonymous

BNY Interview FAQs

How many rounds are there in BNY Database Manager interview?
BNY interview process usually has 1 rounds. The most common rounds in the BNY interview process are One-on-one Round.
How to prepare for BNY Database Manager 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 BNY. The most common topics and skills that interviewers at BNY expect are Computer science, Database Design, Database Management, Financial Services and Application Development.
What are the top questions asked in BNY Database Manager interview?

Some of the top questions asked at the BNY Database Manager interview -

  1. How proficient you are in S...read more
  2. Explain procedures from S...read more

Recently Viewed

PHOTOS

InsuranceDekho

3 office photos

LIST OF COMPANIES

Credit Bajaar

Overview

JOBS

Thatware Llp

No Jobs

SALARIES

Aurobindo Pharma

COMPANY BENEFITS

Mahindra Logistics

No Benefits

REVIEWS

State Bank of India

No Reviews

REVIEWS

Aurobindo Pharma

No Reviews

SALARIES

Aurobindo Pharma

SALARIES

Aurobindo Pharma

REVIEWS

Aurobindo Pharma

No Reviews

Tell us how to improve this page.

BNY Database Manager Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

Citicorp Interview Questions
3.7
 • 564 Interviews
Wells Fargo Interview Questions
3.8
 • 563 Interviews
Bajaj Finserv Interview Questions
4.0
 • 519 Interviews
HSBC Group Interview Questions
4.0
 • 484 Interviews
Goldman Sachs Interview Questions
3.5
 • 376 Interviews
American Express Interview Questions
4.2
 • 358 Interviews
UBS Interview Questions
3.9
 • 331 Interviews
Morgan Stanley Interview Questions
3.7
 • 291 Interviews
View all
Analyst
1.9k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Analyst
1.7k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Associate
1.2k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Intermediate Representative
1.1k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Vice President
1.1k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare BNY with

State Street Corporation

3.7
Compare

Northern Trust

3.7
Compare

HSBC Group

3.9
Compare

JPMorgan Chase & Co.

4.0
Compare
Did you find this page helpful?
Yes No
write
Share an Interview