AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
State Street Bank Data Analyst Interview Questions and Answers
State Street Bank Data Analyst Interview Experiences
1 interview found
Anonymous
Selected
I applied via Referral and was interviewed in May 2023. There were 3 interview rounds.
In 1st round they ask both aptitude and coding questions and the time given is 3 hours.
They ask about your project of mentioned in resume and some subject questions and other questions form resume
Interview Preparation Tips
- Python
- SQL
Coming to 2nd round mainly they focus on communication skills that's it. But in 2nd round 2 members will take the interview 1 will ask subject questions and another will ask common questions to check communication skills and English fluency.
That's it about SSB interview
Interview questions from similar companies
I applied via Referral and was interviewed before Jun 2021. There were 3 interview rounds.
SQL server
SQL DBA
(1 Question)
- Q1. Salary discussed, Appts test
Interview Preparation Tips
I appeared for an interview before Jun 2016.
Interview Questionnaire
6 Questions
- Q1. Tell me about yourself from the day u were born till today (Stopped mid way when I mentioned the finance course)
- Q2. What is a Brownian motion? Properties of Brownian motion?
- Ans.
Brownian motion is the random motion of particles in a fluid due to collisions with other particles.
Brownian motion was first observed by Robert Brown in 1827.
It is named after the botanist Robert Brown.
The motion is caused by the random movement of fluid molecules.
Brownian motion is a continuous-time stochastic process.
It is often used to model various phenomena in physics, finance, and biology.
Properties of Brownian ...
- Q3. What is a Martingale? What are Markov Processes? Is Martingale a Markov Process? Are Markov Processes Martingales?
- Ans.
A Martingale is a mathematical concept used in probability theory and statistics. Markov Processes are stochastic processes that satisfy the Markov property.
A Martingale is a sequence of random variables where the expected value of the next variable, given the current and past variables, is equal to the current variable.
Markov Processes are stochastic processes where the future state depends only on the current state a...
- Q4. Then the HR guy asked me One trait of mine that I’m not proud of?
- Q5. Then there was a puzzle m2 = n2 + 32294 ( It was also asked in last year’s interview)
- Q6. Then there was another HR question, In a group would it be better for me to assume a leadership position or simply be a part of it? Why?
Interview Preparation Tips
Experience: The Maths section had questions on basic probability and statistics. Also the Maths section had a higher weight age than the other sections (Questions carrying 3 marks each while other sections had 1 or 2 marks for each question. They were here, offering a quant profile so that justifies the distribution.) The DI/Quant (2 marks each) and English (1 Mark Each) section were similar to CAT. The finance section had questions on Basic Accounting. Anyone who did well in the Maths section could find his name in the shortlist.
Round: Technical + HR Interview
Experience: Possible Lapses: I
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
(3 Questions)
- Q1. Sas proc format
- Q2. How have you debug macros
- Ans.
I have debugged macros by reviewing code, checking for errors, using print statements, and stepping through code.
Reviewing the macro code line by line to identify any syntax errors or logical mistakes
Using print statements to output variable values and check for unexpected results
Stepping through the code using a debugger tool to track the flow of execution and pinpoint issues
Testing the macro with different inputs to
- Q3. How big data handled by you
- Ans.
I handle big data by using advanced analytics tools and techniques to extract valuable insights.
Utilize data visualization tools like Tableau or Power BI to analyze and present data
Use programming languages like Python or R for data manipulation and statistical analysis
Implement machine learning algorithms to uncover patterns and trends in large datasets
Leverage cloud computing platforms like AWS or Google Cloud for sc...
Skills evaluated in this interview
Selected
I applied via LinkedIn and was interviewed in Sep 2023. There was 1 interview round.
(1 Question)
- Q1. Would you send a mail to stakeholder in place of your colleague
(1 Question)
- Q1. Explain different type of SQL query?
- Ans.
Different types of SQL queries include SELECT, INSERT, UPDATE, DELETE, JOIN, and more.
SELECT: Retrieves data from a database
INSERT: Adds new records to a table
UPDATE: Modifies existing records in a table
DELETE: Removes records from a table
JOIN: Combines rows from two or more tables based on a related column
Interview Preparation Tips
Hackerrank test of 2 medium questions
(1 Question)
- Q1. ALL technical from your resume
(1 Question)
- Q1. Typical HR Interview
Selected
I applied via LinkedIn and was interviewed before Dec 2023. There was 1 interview round.
(1 Question)
- Q1. Automation you have done
I applied via Company Website and was interviewed before Sep 2022. There were 5 interview rounds.
Having 10 mcqs with 2 coding questions of medium level
(1 Question)
- Q1. Find missing number from 1 to n without using extra space and O(n) tc
- Ans.
Find missing number from 1 to n without using extra space and O(n) tc
Use XOR operation to find the missing number
Iterate through the array and XOR each element with its index and the result
The missing number will be the final result after XORing all elements and indices
General aptitude questions
(1 Question)
- Q1. Some behavior questions with company values
Interview Preparation Tips
Skills evaluated in this interview
I applied via Recruitment Consultant and was interviewed in Mar 2021. There were 3 interview rounds.
Interview Questionnaire
2 Questions
- Q1. Completey about your perivious experience and it's challenges .
- Q2. Just give your comments as per your previous experience, don' t try to protrate some one else.
Interview Preparation Tips
State Street Bank Interview FAQs
Tell us how to improve this page.
State Street Bank Interviews By Designations
- State Street Bank Accountant Interview Questions
- State Street Bank Analyst Interview Questions
- State Street Bank Emerging Leader Interview Questions
- State Street Bank Data Analyst Interview Questions
- State Street Bank Assistant Manager Interview Questions
- State Street Bank SAP Abap Developer Interview Questions
- State Street Bank Senior Software Engineer Interview Questions
- State Street Bank Senior Java Developer Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
State Street Bank Data Analyst Interview Process
based on 1 interview
Interview experience
Data Analyst Interview Questions from Similar Companies
State Street Bank Data Analyst Reviews and Ratings
based on 2 reviews
Rating in categories
|
Senior Associate
330
salaries
|  ₹3 L/yr - ₹11 L/yr |
|
Associate2
295
salaries
| ₹2.8 L/yr - ₹6.5 L/yr |
|
Team Lead
169
salaries
| ₹5.1 L/yr - ₹15.7 L/yr |
|
Associate
131
salaries
| ₹2.4 L/yr - ₹6 L/yr |
|
Assistant Manager
129
salaries
| ₹8.2 L/yr - ₹21.5 L/yr |
AU Small Finance Bank
IndusInd Bank
IDFC FIRST Bank
Yes Bank
- Home >
- Interviews >
- State Street Bank Interview Questions >
- State Street Bank Data Analyst Interview Questions
