State Street Corporation Lead Interview Questions and Answers

Coding round of 90 mons which has 10-15 questions over sql queries from mid to hard level

Q1. This was about complete technical interviews talking about optimization and etl techniques
Add your answer

Q1. Again this round was technical discussion which talks about data warehousing concept and etl techniques
Add your answer

Q1. This was also technical round which talks about some real time scenarios based questions and challenges and then they look for some could technical solutions
Add your answer

Q1. This round was 70% about technical things and rest 30% on Personal interview
Add your answer

Q1. Basic questions on python
Add your answer
Q2. Difference between list tuple
Ans. 
Lists and tuples are both data structures in Python, but lists are mutable while tuples are immutable.
• Lists are enclosed in square brackets [], while tuples are enclosed in parentheses ().

• Lists can be modified after creation, while tuples cannot be modified (immutable).

• Lists are typically used for collections of similar items, while tuples are used for fixed collections of items.

• Example: list = [1, 2, 3] and tuple = (4
Answered by AI
Add your answer
Q3. Area of room 6D
Ans. 
The area of a room can be calculated by multiplying the length by the width.
• Calculate the area by multiplying the length and width of the room.

• For example, if the length of the room is 10 feet and the width is 12 feet, the area would be 120 square feet.

• Make sure to use the same units for length and width when calculating the area.
Answered by AI
Add your answer
Q4. Most emberacing situation u faced in your life
Ans. 
Getting caught cheating on a test in high school
• Was copying answers from a classmate during a test

• Teacher caught me and called me out in front of the whole class

• Felt embarrassed and learned my lesson about cheating
Answered by AI
Add your answer
Q5. Behavior questions like what will u do if this happens
Add your answer

Q1. About your self
Add your answer
Q2. Did any internship
Add your answer

Q1. Regarding home loan?
Add your answer

Q1. Regarding home loan rate of interest
Add your answer

Q1. Telephonic Interview Round 1
Add your answer
Q2. Tell about yourself.
Add your answer

Language English Testing through Application.

Q1. What do you know about credit cards?
Ans. 
Credit cards are financial tools that allow consumers to borrow money for purchases and pay it back later with interest.
• Credit cards are issued by financial institutions to consumers for making purchases and payments.

• They allow users to borrow money up to a certain limit, known as the credit limit.

• Users are required to pay back the borrowed amount along with interest within a specified period.

• Credit cards often come wi...read more
Answered by AI
Add your answer

Useful understand for problem solving ability. Analysis & mathematical data

Is a method of group discussions in a small or big ideas & information collect all solution get good.