State Street Corporation
Proud winner of ABECA 2025 - AmbitionBox Employee Choice Awards
Filter interviews by
I applied via Campus Placement and was interviewed in Sep 2023. There were 2 interview rounds.
It was good but prepared on technical basis
Primary key is a unique identifier for each record in a database table.
Primary key ensures each record in a table is unique
It can be a single column or a combination of columns
Primary key values cannot be NULL
Example: In a table of students, student ID can be a primary key
Foreign key is a column or a set of columns in a table that uniquely identifies a row in another table.
A foreign key establishes a relationship between two tables in a database.
It ensures referential integrity by enforcing a link between the data in the two tables.
Foreign key constraints prevent actions that would destroy links between tables, such as deleting a row that is referenced by another table.
Example: In a dat...
I applied via Recruitment Consulltant and was interviewed in Feb 2023. There were 2 interview rounds.
I applied via LinkedIn and was interviewed before Aug 2020. There were 4 interview rounds.
I applied via Company Website and was interviewed in Jul 2020. There were 4 interview rounds.
What people are saying about State Street Corporation
Design a system similar to YouTube for video sharing and streaming
Implement user authentication and authorization for uploading and viewing videos
Create a database to store video metadata, user information, and comments
Develop a recommendation algorithm based on user preferences and viewing history
Utilize a content delivery network (CDN) for efficient video streaming
Include features like video monetization, live stream...
Kafka is a distributed streaming platform used for building real-time data pipelines and streaming applications.
Kafka uses a publish-subscribe model for messaging, allowing multiple producers and consumers.
Topics in Kafka are partitioned for scalability; for example, a topic with 3 partitions can handle 3 consumers simultaneously.
Kafka ensures message durability through replication; if one broker fails, others can stil...
Java 8 introduced several new features including lambda expressions, streams, and default methods.
Lambda expressions allow for functional programming and concise code.
Streams provide a way to process collections of data in a parallel and functional manner.
Default methods allow for adding new functionality to interfaces without breaking existing implementations.
Method references provide a way to refer to methods without...
Customised immutable java class can be written by declaring all fields as final and not providing any setters.
Declare all fields as final
Do not provide any setters
Provide a constructor to initialize all fields
Override equals() and hashCode() methods
Make the class final
I applied via Referral and was interviewed in May 2021. There were 4 interview rounds.
I applied via Naukri.com and was interviewed before Oct 2022. There were 3 interview rounds.
Bigdata systems architecture involves distributed storage, processing, and analysis of large volumes of data.
Utilize distributed file systems like HDFS for storage
Use parallel processing frameworks like Apache Spark or Hadoop for data processing
Implement data pipelines for ETL processes
Leverage NoSQL databases like Cassandra or MongoDB for real-time data querying
Consider data partitioning and replication for fault tole...
Big data system distribution for storage and compute involves partitioning data across multiple nodes for efficient processing.
Data is partitioned across multiple nodes to distribute storage and processing load.
Hadoop Distributed File System (HDFS) is commonly used for storage distribution.
Apache Spark utilizes a cluster computing framework for distributed computing.
Data locality is important to minimize data transfer ...
I applied via Referral and was interviewed before Sep 2019. There were 3 interview rounds.
I approach dynamic objects by analyzing their behavior and adapting my approach accordingly.
I start by understanding the nature of the dynamic object and its expected behavior
I then analyze its movement patterns and any potential obstacles or hazards
Based on this analysis, I adapt my approach to ensure safe and efficient interaction with the dynamic object
For example, when working with a moving conveyor belt, I would e...
Implicit and explicit wait are two types of wait in Selenium used to synchronize the test execution with the application.
Implicit wait is used to set a default waiting time for the web elements to load before throwing an exception.
Explicit wait is used to wait for a specific condition to occur before proceeding with the test execution.
Implicit wait is set globally for the entire test script while explicit wait is set f...
based on 1 interview experience
Difficulty level
Duration
Senior Associate
5.1k
salaries
| ₹2.8 L/yr - ₹13.5 L/yr |
Associate2
4.1k
salaries
| ₹2.4 L/yr - ₹7.9 L/yr |
Team Lead
2.1k
salaries
| ₹6.1 L/yr - ₹15.5 L/yr |
Assistant Manager
2k
salaries
| ₹9.5 L/yr - ₹29.5 L/yr |
Associate
1.6k
salaries
| ₹2 L/yr - ₹8 L/yr |
Wells Fargo
JPMorgan Chase & Co.
HSBC Group
Cholamandalam Investment & Finance