BNY Senior Technical Analyst Interview Questions and Answers

Q1. Asked questions on multithreading and deadlocks. Data flow between components in React - Parent to Child and vice versa. State management techniques in React. Life Cycle methods. HTML DOC and related ta...read more
Add your answer

Q1. General discussion on current CTC and Expected CTC.
Add your answer

Q1. Sql CTE, SP, Function, Triggers, optimization
Add your answer
Q2. Read in websites
Add your answer

2 hours coding round with 3 sections
1st being mcq aptidute+coding question 20 mins were given for this section and 20 questions were there in this section

2nd section consisted of 8 questions where we had to do the error correction in the given code 20 mins were also given for this section

3rd section consisted of 2 coding problems 20 mins were given for each one was a dp and one was a segment tree question

I was able to do everything correctly and was selected for the first interview round

Q1. Firstly they asked me to Tell me about myself Then a little bit about my projects Then 3 coding questions were ASKED 1st was a really recursion problem 2nd was a dp problem specifically a generic problem ...read more
Add your answer

Q1. Why do you want to join the company
Add your answer
Q2. Tell me what do you know about the company
Add your answer
Q3. Then I was asked about my project and cross questioned on it
Add your answer
Q4. Then i was asked about a system design question (since I didn't study about it I tanked here :))
Add your answer

Q1. For Production support role they had asked to solve a SQL query which needed your expertise in joins and how to use them
Add your answer
Q2. Another question on Autosys how to create a cyclic job that runs continuously without any downtime
Add your answer

Q1. Recent automation you did that helped in your project?
Add your answer
Q2. Why you are looking for a change?
Add your answer

Q1. Salary expectation ?
Add your answer
Q2. What really motivated you to look for a job change?
Add your answer

Technical problem comprised of searching google and then using api call and performing parallel execution

Q1. Related to Automation Scenarios
Add your answer
Q2. Parallel Execution
Add your answer

Q1. Projects on resume , basic dsa, real life example fo data struct, oops . procedure - pl /sql
Add your answer

Q1. Family backgroudn , hobbies , general discussion
Add your answer

Q1. How will you optimize the performance while reading a huge file with more than 100 columns and 1 lac rows?
Ans. 
Use efficient file reading techniques like memory mapping, parallel processing, and columnar storage.
• Utilize memory mapping to directly access file data without loading it into memory

• Implement parallel processing to read and process data concurrently for faster performance

• Consider using columnar storage to optimize data retrieval for specific columns

• Use appropriate data structures and algorithms for efficient data proc
Answered by AI
Add your answer