Interview questions for BNY Senior Data Management Analyst
Hi everyone, this topic is for sharing Preparation guidelines and interview experience for BNY Senior Data Management Analyst
The Senior Data Management Analyst at BNY involves a multi-stage assessment and interview process, designed to evaluate both technical skills and business proficiency. Below is a summary of the process and key points from the interviews you provided:
Assessment Test Rounds:
Round 1: Resume Shortlist
Screening based on alignment of resume with role requirements. Ensure formatting is clean and experience is clearly mapped to data management and analytics responsibilities.
Round 2: Aptitude Test (Finance basics)
Basic financial background questions; described as easy by one candidate.
Round 3: Coding Test (SQL, Python, Spark)
Hands-on coding across SQL, Python, and Spark. Emphasis on writing efficient, clean solutions; candidates reported practicing on platforms like HackerRank.
Interview Rounds:
Technical Interview (Performance Measurement & Data Management)
Focus on performance measurement (TWRR vs MWRR), attribution, and reference data/instrument loading.
Technical Interview (Coding/Big Data)
Live code-pair (HackerRank) and PySpark topics, including DataFrame operations and Spark optimizations.
One-on-One/HR Interview
Standard HR and behavioral questions covering motivation, strengths/weaknesses, goals, salary expectations, and work style.
Interview Preparation Tips:
Be clear with basics of performance measurement and attribution (TWRR, MWRR, attribution methodologies).
Brush up on SQL/MySQL and data modeling concepts.
Practice SQL, Python, and Spark/PySpark extensively; review DataFrame APIs and Spark optimizations.
Do hands-on coding practice on platforms like HackerRank; focus on clean, efficient solutions and edge cases.
For banking/MNC roles, strengthen Excel, business research, email communication, and data entry fundamentals.
Use the STAR method for behavioral answers; keep responses concise and role-aligned.
Ensure your resume is well-formatted and tailored to highlight relevant data management and analytics experience.
Technical/Domain (Performance Measurement, Attribution, Data Management)
What is the difference between TWRR and MWRR?
Does TWRR use cashflows?
Which is better, TWRR or MWRR, and why?
What is attribution?
How do you load instruments information?
Basic financial background questions (unspecified in the transcript).
Programming/SQL/Python/Spark
Coding questions on SQL (unspecified by interviewers).
Coding questions on Python (unspecified by interviewers).
Coding questions on Spark (unspecified by interviewers).
PySpark-related questions (DataFrame operations and Spark optimizations).
HackerRank code pair question (live coding).
HR/Personality/Behavioral
Self-introduction.
Why should I hire you?
Why do you want to work at our company?
Can you work under pressure?
What are your ambitions or goals?
What is your salary expectation?
Your family background.
What are your strengths and weaknesses?
What is the difference between confidence and overconfidence?
What is the difference between hard work and smart work?
If you have attended the process from your campus, pls share your experiences here; Please follow [guidelines](https://discuss.boardinfinity.com/t/interview-transcript-guidelines/22428?u=abhay-gupta-ebaf4123)
Outcome: The test was easy, and I cleared it successfully.
Round 3 - Technical Round:
Questions Asked:
Difference between TWRR and MWRR.
Does TWRR use cashflows?
What is attribution?
How do you load instruments information?
Which is better, TWRR or MWRR, and why?
Your Approach: I answered based on my understanding of performance measurement and attribution concepts.
Outcome: Cleared the technical round.
Preparation Tips:
Be clear with your basics on performance measurement and attribution.
Brush up on MySQL and data modeling concepts.
Conclusion:
Overall, the interview process was smooth, and the questions were aligned with the role’s requirements. I would advise future candidates to focus on financial performance measurement concepts and ensure their SQL skills are strong.
Application Process: I applied via campus placement at Lovely Professional University (LPU) before May 2023.
Interview Rounds:
Round 1 - One-on-one Round:
Questions Asked:
Reverse a string in list.
Explain joins in SQL.
Your Approach:
For the string reversal question, I used a simple loop to iterate through the list and reverse the elements.
For the SQL joins question, I explained the different types of joins (INNER, LEFT, RIGHT, FULL) with examples.
Outcome: I successfully answered both questions and passed the round.
Preparation Tips:
Focus on fundamental programming concepts like string manipulation and data structures.
Brush up on SQL queries, especially joins, as they are commonly asked in data-related roles.
Practice explaining your thought process clearly during interviews.
Conclusion:
The interview was straightforward, and the questions were aligned with the role’s requirements. Preparing thoroughly for basic programming and SQL concepts helped me perform well. For future candidates, I recommend practicing coding problems and understanding database operations in depth.
Application Process: I applied through campus placement in September 2023.
Interview Rounds:
Round 1 - Resume Shortlist Round:
Questions Asked: Basic screening based on the resume.
Your Approach: Ensured my resume was concise and highlighted relevant skills and experiences. Avoided unnecessary personal details like photos, gender, age, or address.
Outcome: Successfully shortlisted for the next round.
Round 2 - One-on-one Round:
Questions Asked:
Basic questions related to my resume.
Technical questions related to the programming languages I mentioned.
Your Approach: Prepared thoroughly by revising my resume and brushing up on technical concepts related to the languages I knew. Stayed calm and answered confidently.
Outcome: Cleared the round with positive feedback.
Preparation Tips:
Keep your resume concise and focused on relevant skills.
Avoid including personal details that don’t add value.
Revise technical concepts thoroughly, especially those mentioned in your resume.
Conclusion:
The interview process was smooth and well-structured. Preparing my resume carefully and revising technical concepts helped me perform well. For future candidates, I’d recommend focusing on resume clarity and technical preparation.
Application Process: I applied via Naukri.com and was interviewed in June 2023.
Interview Rounds:
Round 1 - Resume Shortlist:
Questions Asked: N/A (Resume screening round)
Your Approach: Ensured my resume was concise and highlighted relevant skills.
Outcome: Passed to the next round.
Round 2 - Coding Test:
Questions Asked:
Using a loop, print the star for a triangle.
What is pandas?
Difference between tuple and list.
Your Approach: Prepared basic Python concepts and practiced coding problems beforehand.
Outcome: Cleared the round.
Round 3 - Technical Round:
Questions Asked:
What is 5G? Types of G.
Tell me about yourself.
What is machine learning? Types of machine learning.
What is tensor? Explain linear regression.
Measures of central tendency.
Your Approach: Revised key technical concepts and practiced explaining them clearly.
Outcome: Successfully answered the questions.
Preparation Tips:
Keep learning and exploring new topics.
Practice coding problems and revise fundamental concepts.
Conclusion:
The interview process was smooth, and I felt well-prepared. I could have practiced more coding problems to feel even more confident. My advice to future candidates is to stay updated with industry trends and focus on clear communication during interviews.
Application Process: I applied via LinkedIn and was interviewed in March 2024.
Interview Rounds:
Round 1 - Coding Test:
Questions Asked: Coding questions on SQL, Python, and Spark.
Your Approach: I reviewed my knowledge of SQL queries, Python scripting, and Spark operations beforehand. During the test, I focused on writing efficient and clean code.
Outcome: Passed this round and moved to the next stage.
Round 2 - Technical Round:
Questions Asked:
HackerRank code pair question.
PySpark-related questions.
Your Approach: For the HackerRank question, I ensured my solution was optimized and handled edge cases. For the PySpark questions, I demonstrated my understanding of DataFrame operations and Spark optimizations.
Outcome: Awaiting results.
Preparation Tips:
Brush up on SQL, Python, and Spark concepts.
Practice coding problems on platforms like HackerRank.
Review PySpark DataFrame operations and optimizations.
Conclusion:
The interview process was smooth, and the questions were aligned with the job role. I felt confident in my technical skills, but I could have practiced more PySpark-specific scenarios. For future candidates, I recommend focusing on hands-on coding practice and understanding Spark internals.
Application Process: I was approached by the company for this role and interviewed in August 2023.
Interview Rounds:
Round 1 - Technical Round:
Questions Asked:
Multiple SQL questions.
One DSA medium question based on string.
Your Approach: For the SQL questions, I focused on writing efficient queries and explaining my thought process. For the DSA question, I first outlined the problem, discussed edge cases, and then coded the solution.
Outcome: Cleared this round successfully.
Round 2 - Technical Round:
Questions Asked:
Explain any project architecture you have worked on. Again, multiple SQL questions.
Medium DSA question relatable to merge intervals.
Your Approach: I described a recent project, highlighting the architecture and my contributions. For the SQL questions, I ensured my answers were optimized. The DSA question was tackled by breaking it down into smaller steps and discussing the approach before coding.
Outcome: Cleared this round as well.
Preparation Tips:
Practice SQL extensively, focusing on complex queries and optimization.
Revise DSA concepts, especially string manipulation and interval-related problems.
Be prepared to explain project architectures clearly and concisely.
Conclusion:
The interview process was smooth, and the questions were aligned with the role’s requirements. I felt well-prepared for the technical rounds, but I could have practiced more real-world SQL scenarios. My advice to future candidates is to focus on both theoretical knowledge and practical problem-solving skills.
Location: National Institute of Technology (NIT), Tiruchirappalli
Application Process: I applied through campus placement at NIT Tiruchirappalli in June 2023.
Interview Rounds:
Round 1 - Technical Round:
Questions Asked:
What is JIT manufacturing?
Geeksforgeek situational questions
Your Approach: For the JIT manufacturing question, I explained the concept of Just-In-Time manufacturing and its benefits in reducing waste and improving efficiency. For the situational questions, I used logical reasoning and real-world examples to structure my answers.
Outcome: I passed this round and moved to the next stage.
Round 2 - One-on-one Round:
Questions Asked:
Why did you choose finance?
What made you interested in financial banking?
Your Approach: I highlighted my academic background in finance and my passion for the industry, linking it to my career goals. For the financial banking question, I discussed my curiosity about how financial systems operate and my desire to contribute to this field.
Outcome: The interviewers seemed satisfied with my responses, and I successfully cleared this round as well.
Preparation Tips:
Brush up on basic technical concepts related to the role, especially if they are mentioned in the job description.
Practice situational and behavioral questions to articulate your thoughts clearly.
Research the company and its core values to align your answers with their expectations.
Conclusion:
Overall, the interview process was smooth and well-structured. The technical round tested my conceptual understanding, while the one-on-one round focused on my motivations and fit for the role. I could have prepared more situational questions in advance, but my foundational knowledge helped me navigate the rounds successfully. For future candidates, I’d recommend thorough preparation and staying confident throughout the process.
Application Process: I applied through a recruitment consultant and was interviewed in February 2023.
Interview Rounds:
Round 1 - Resume Shortlist:
Questions Asked: N/A (This round was focused on resume screening.)
Your Approach: Ensured my resume was well-formatted and aligned to make it easy for the recruiter to read.
Outcome: Successfully shortlisted for the next round.
Round 2 - One-on-one Interview:
Questions Asked:
Self-introduction.
Why should I hire you?
Why do you want to work at our company?
Can you work under pressure?
What are your ambitions or goals?
What is your salary expectation?
Your family background.
What are your strengths and weaknesses?
What is the difference between confidence and overconfidence?
What is the difference between hard work and smart work?
Your Approach: Answered honestly and confidently, focusing on my skills and how they align with the role. For behavioral questions, I provided examples from past experiences.
Outcome: Awaiting results.
Preparation Tips:
Focus on resume formatting and clarity.
Prepare for common HR and behavioral questions.
Research the company and role to answer “Why this company?” effectively.
Practice differentiating between concepts like confidence vs. overconfidence and hard work vs. smart work.
Conclusion:
The interview process was straightforward, with a mix of resume screening and a one-on-one round. I felt prepared, but I could have researched more about the company’s recent projects to tailor my answers better. For future candidates, I recommend practicing common HR questions and ensuring your resume is polished.
Application Process: I applied via a recruitment consultant and was interviewed in February 2023.
Interview Rounds:
Round 1 - Resume Shortlist:
Questions Asked: N/A (Resume screening round)
Your Approach: Ensured my resume was well-formatted and aligned properly to make it easy for the recruiter to review.
Outcome: Passed this round and moved to the next stage.
Round 2 - One-on-One Round:
Questions Asked:
Self-introduction.
Why should I hire you?
Why do you want to work at our company?
Can you work under pressure?
What are your ambitions or goals?
What is your salary expectation?
Your family background.
What are your strengths and weaknesses?
What is the difference between confidence and overconfidence?
What is the difference between hard work and smart work?
Your Approach: Prepared concise and honest answers, focusing on my skills and how they align with the role. For behavioral questions, I used the STAR method to structure my responses.
Outcome: Successfully cleared this round.
Preparation Tips:
For MNCs, banks, or similar roles, focus on skills like Excel, data entry, business research, and email communication.
Practice common interview questions and refine your answers to reflect your experience and aspirations.
Conclusion:
The interview process was smooth, and the questions were standard for a role like this. I ensured my resume was well-prepared, which helped me clear the first round easily. For the one-on-one round, being honest and structured in my responses worked well. My advice to future candidates is to practice common interview questions and tailor your answers to the role you’re applying for.