Application Process: I applied via LinkedIn and was interviewed before December 2021.
Interview Rounds:
Round 1 - Resume Shortlist:
Pro Tip: Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
Outcome: My resume was shortlisted for the next round.
Round 2 - Aptitude Test:
Questions Asked: A set of quantitative, logical reasoning, and English grammar questions.
Outcome: I cleared the aptitude test and moved to the next round.
Round 3 - Technical Round:
Questions Asked:
Introduction and questions about business analysis.
Business process mapping.
Your Approach: I answered the questions based on my understanding of business analysis principles and real-world applications.
Outcome: The round went well, and I received positive feedback.
Preparation Tips:
Go well prepared about the company and its products.
Brush up on business analysis concepts and business process mapping techniques.
Conclusion:
Overall, the interview process was smooth and well-structured. I felt confident about my preparation, especially in the technical round. For future candidates, I recommend focusing on both aptitude and technical skills, as well as thoroughly researching the company.
Application Process: The application process involved three rounds: Resume Shortlist, Aptitude Test, and a One-on-One Interview.
Interview Rounds:
Round 1 - Resume Shortlist:
Details: The first round was a resume screening process. The candidate’s resume was evaluated for relevance and qualifications.
Outcome: The candidate successfully cleared this round.
Round 2 - Aptitude Test:
Details: This round included practical questions to assess the candidate’s problem-solving and analytical skills.
Outcome: The candidate advanced to the next round.
Round 3 - One-on-One Interview:
Questions Asked:
“What are your strengths and weaknesses?”
Your Approach: The candidate answered honestly, highlighting relevant strengths for the role and framing weaknesses as areas for improvement.
Outcome: The candidate’s performance in this round determined their final selection.
Preparation Tips:
Ensure your resume is concise and tailored to the role, avoiding unnecessary personal details.
Practice aptitude tests to improve speed and accuracy.
Prepare for common interview questions like strengths and weaknesses, and relate them to the job requirements.
Conclusion:
The interview process was structured and focused on assessing both technical and interpersonal skills. Being honest and well-prepared helped the candidate navigate the rounds effectively. Future candidates should focus on presenting a strong resume and practicing common interview questions.
Application Process: [Application process details not provided]
Interview Rounds:
Round 1 - Hiring Manager Interview:
Questions Asked:
Questions about previous experience in project management and client-facing work environments.
Focus on aligning with the job description.
The hiring manager was keen on understanding my personality and fit for the role.
Your Approach:
I highlighted my relevant project management experience and how I handled client interactions in my previous roles.
I also made sure to convey my adaptability and teamwork skills to align with the company culture.
Outcome: [Result of this round not specified]
Round 2 - Coworker Interview:
Questions Asked:
Specific questions about hard skills, such as proficiency in Excel.
Inquiries about the types of clients and industries I had worked with previously.
Questions about the kind of team I expect to work with.
Your Approach:
I demonstrated my Excel skills by discussing specific tasks I had accomplished using it.
I provided examples of industries and clients I had engaged with to showcase my versatility.
I expressed my preference for collaborative and dynamic teams.
Outcome: [Result of this round not specified]
Preparation Tips:
Focus on aligning your previous experiences with the job description.
Be prepared to discuss both soft skills (like teamwork and client interaction) and hard skills (like Excel proficiency).
Research the company culture to tailor your responses accordingly.
Conclusion:
The interview process was insightful and centered around both technical and interpersonal skills. The hiring manager was more interested in understanding my personality, while the coworker focused on my hard skills. Overall, it was a balanced experience, and I would advise future candidates to prepare thoroughly for both aspects of the role.
Application Process: I applied through my college’s campus placement program. The process was straightforward, and I was shortlisted based on my resume and academic performance.
Interview Rounds:
Round 1 - HR Interview:
Questions Asked:
Tell me about yourself.
Describe your past work experience and how it relates to this role.
Why do you want to work at BNY Mellon?
How do you handle tight deadlines or stressful situations?
Your Approach: I kept my answers concise and focused on my relevant experiences. I highlighted my problem-solving skills and ability to work under pressure.
Outcome: I passed this round and moved on to the next stage.
Round 2 - Technical Interview:
Questions Asked:
Explain a project you worked on that involved data analysis.
How do you ensure accuracy in your work?
What tools or software have you used for project management or analysis?
Your Approach: I discussed a recent project where I used Excel and SQL for data analysis. I emphasized my attention to detail and how I cross-check my work to avoid errors.
Outcome: The interviewer seemed satisfied with my responses, and I advanced to the final round.
Round 3 - Case Study/Problem-Solving:
Questions Asked:
Given a hypothetical business scenario, how would you identify key issues and propose solutions?
How do you prioritize tasks when managing multiple projects?
Your Approach: I structured my answer using a step-by-step approach—identifying the problem, analyzing data, and suggesting actionable solutions. I also mentioned tools like Trello for task prioritization.
Outcome: I felt confident about my performance, and I was selected for the role.
Preparation Tips:
Brush up on your past projects and be ready to discuss them in detail.
Practice answering behavioral questions using the STAR method.
Familiarize yourself with basic project management and data analysis tools.
Conclusion:
Overall, the interview process was smooth and well-structured. The key to success was being clear and confident in my responses. I would advise future candidates to prepare thoroughly and stay calm during the interviews.
Application Process: The application process involved multiple rounds, including telephonic interviews, a project submission, and a face-to-face interview at the company office.
Interview Rounds:
Round 1 - Telephonic Technical Round:
Questions Asked: Questions focused on .NET and SQL.
Your Approach: I prepared by revising core concepts of .NET and SQL, ensuring I could explain my past projects and experiences clearly.
Outcome: Successfully cleared this round.
Round 2 - HR Interview:
Questions Asked: Questions revolved around teamwork, collaboration, and how well I gel with people.
Your Approach: I shared examples from my previous experiences where I worked effectively in teams and resolved conflicts.
Outcome: Cleared this round as well.
Round 3 - Project Submission:
Questions Asked: A small project involving .NET, WinForms, and Access programming was assigned, with a 3-day deadline to submit the solution.
Your Approach: I dedicated focused time to understand the requirements, designed a solution, and ensured it was well-documented and functional.
Outcome: Submitted the project on time and received positive feedback.
Round 4 - Face-to-Face Interview:
Questions Asked: This round included discussions with my future Team Lead and Manager, followed by an interaction with the team I was to join. There was also a video conference with the onshore manager for final approval.
Your Approach: I prepared by researching the company, understanding the role, and being ready to discuss my technical and soft skills in detail.
Outcome: Cleared all interactions and received the final approval.
Preparation Tips:
Brush up on core technical skills relevant to the role, especially .NET and SQL.
Be ready to discuss past projects and teamwork experiences in detail.
Practice time management for project submissions to ensure timely delivery.
Conclusion:
The overall experience was thorough and gave me a good understanding of the role and the team. The project round was challenging but rewarding. I would advise future candidates to focus on both technical and interpersonal skills, as both are equally important for this role.
Application Process: The process started with an HR introduction call within a week of submitting the application. This was followed by technical and managerial rounds. Once cleared, the HR discussed salary and issued the offer.
Interview Rounds:
Round 1 - HR Introduction:
Questions Asked: General introduction, details about the role, and confirmation of availability for further rounds.
Your Approach: I kept my responses concise and professional, ensuring I understood the role and next steps clearly.
Outcome: Cleared the round and moved to the technical round.
Round 2 - Technical Round:
Questions Asked: Questions related to business analysis, project management methodologies, and problem-solving scenarios.
Your Approach: I focused on explaining my past experiences and how they aligned with the role. For technical questions, I used examples to demonstrate my understanding.
Outcome: Successfully cleared the round and proceeded to the managerial round.
Round 3 - Manager Round:
Questions Asked: Behavioral questions, situational challenges, and how I would handle specific project scenarios.
Your Approach: I used the STAR method to structure my answers and provided real-life examples to showcase my skills.
Outcome: Cleared the round, and HR later contacted me for salary discussions.
Preparation Tips:
Brush up on business analysis and project management fundamentals.
Practice behavioral questions using the STAR method.
Be ready to discuss past experiences in detail.
Conclusion:
The overall process was smooth and well-structured. I felt prepared, but I could have practiced more situational questions beforehand. My advice to future candidates is to thoroughly understand the role and align your experiences with it.
Application Process: The application was submitted through the company’s career portal. After initial screening, I was invited for the interview rounds.
Interview Rounds:
Round 1 - Technical Test (VBA Macro Assignment):
Task Given: A VBA macro assignment to be completed and submitted within four days.
Your Approach: I reviewed VBA concepts and practiced writing macros beforehand. For the assignment, I focused on creating an efficient and error-free solution.
Outcome: Successfully submitted the assignment and cleared this round.
Round 2 - Technical Interview:
Questions Asked: Questions about my VBA assignment, problem-solving approach, and basic SQL queries.
Your Approach: I explained my thought process for the VBA task and demonstrated my understanding of SQL by answering the queries confidently.
Outcome: Cleared this round and moved to the next stage.
Round 3 - HR Interview:
Questions Asked: Behavioral questions like “Tell me about yourself,” “Why BNY Mellon?” and situational questions like “How do you handle tight deadlines?”
Your Approach: I prepared answers in advance, focusing on my strengths and aligning my responses with the company’s values.
Outcome: The interview went well, and I advanced to the final round.
Round 4 - Final Technical/Managerial Interview:
Questions Asked: In-depth questions about project management, handling team conflicts, and a few technical scenarios.
Your Approach: I combined my technical knowledge with examples from past experiences to answer the questions. For managerial questions, I emphasized teamwork and problem-solving.
Outcome: Successfully cleared this round and received the offer.
Preparation Tips:
Brush up on VBA and SQL basics, as they are crucial for the technical rounds.
Practice writing macros and solving SQL queries to build confidence.
Prepare for behavioral questions by reflecting on past experiences and aligning them with the job role.
Conclusion:
Overall, the interview process was thorough but fair. The VBA assignment was challenging but a great learning experience. I would advise future candidates to focus on both technical and soft skills, as BNY Mellon values a well-rounded approach. Good luck!