BNY Interview Questions, Process, and Tips for Experienced

Competitive

Was interesting and very tough to crack

Q1. Knowledge and related questions
Add your answer

Q1. Personal question
Add your answer
Q2. Situation question
Add your answer

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
Add your answer
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
Add your answer
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
Add your answer
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
Add your answer

Q1. What is securitization
Add your answer
Q2. Explain how 2008 crisis effect structured finance market especially MBS and RMBS
Add your answer

Q1. What files are required in a framework?
Ans. 
A framework typically requires essential files for structure, configuration, and functionality.
• 1. Configuration Files: Define settings and parameters (e.g., config.json, settings.py).

• 2. Dependency Files: List libraries and packages needed (e.g., package.json, requirements.txt).

• 3. Entry Point: The main file to start the application (e.g., app.js, main.py).

• 4. Source Code Files: Contain the core logic and functionality (e...read more
Answered by AI
Add your answer
Q2. What are the best practices for successfully delivering a project while implementing continuous testing?
Ans. 
Implementing continuous testing enhances project delivery through automation, collaboration, and feedback loops.
• Integrate testing early in the development cycle to catch issues sooner, e.g., using Test-Driven Development (TDD).

• Automate repetitive tests to save time and reduce human error, such as using Selenium for web applications.

• Foster collaboration between developers and testers to ensure shared understanding of re...read more
Answered by AI
Add your answer
Q3. How do you inform others about any process changes?
Ans. 
I communicate process changes through clear documentation, meetings, and follow-ups to ensure everyone is informed and aligned.
• Create detailed documentation outlining the changes and distribute it via email.

• Hold a team meeting to discuss the changes, allowing for questions and feedback.

• Use visual aids, like flowcharts, to illustrate the new processes.

• Follow up with team members individually to address any concerns or c...read more
Answered by AI
Add your answer
Q4. What are the various specialist roles in terms of job perspectives?
Ans. 
Specialist roles vary across industries, focusing on specific skills and expertise to enhance organizational effectiveness.
• Data Scientist: Analyzes complex data to inform business decisions, e.g., predicting customer behavior.

• Cybersecurity Analyst: Protects an organization's systems from cyber threats, e.g., monitoring network security.

• UX/UI Designer: Enhances user experience through design, e.g., creating intuitive ap...read more
Answered by AI
Add your answer