Fidelity Investments
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
I applied via LinkedIn and was interviewed in May 2024. There was 1 interview round.
Use GROUP BY and HAVING clause to find duplicate values in SQL.
Use GROUP BY clause to group the data based on the column you want to check for duplicates.
Use HAVING clause to filter out groups that have more than one entry, indicating duplicates.
Example: SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name HAVING COUNT(*) > 1;
Top trending discussions
posted on 13 Nov 2024
I applied via Company Website and was interviewed in Oct 2024. There was 1 interview round.
Develop rate limiter logic which blocks an IP address when incoming request are > 50 within an arbitrary time frame that you determine.
I applied via Referral and was interviewed in Apr 2024. There was 1 interview round.
I worked with technologies such as React, Node.js, MongoDB, and AWS in my last internship.
React
Node.js
MongoDB
AWS
I applied via Naukri.com and was interviewed in Aug 2024. There was 1 interview round.
GAVE AN ARRAY AND ASKED TO MOVE ZEROES TO THE END AND GROUPBY IN STREAMS JOINS IN SQL
posted on 20 Oct 2023
I applied via Recruitment Consulltant and was interviewed in Sep 2023. There were 3 interview rounds.
Asked about the resume and more technical questions about APIS
posted on 13 Mar 2024
I applied via Recruitment Consulltant and was interviewed before Mar 2023. There was 1 interview round.
Microservices offer scalability, flexibility, and easier maintenance in software development.
Scalability: Microservices allow for individual components to be scaled independently, leading to better resource utilization.
Flexibility: Microservices enable teams to work on different services simultaneously, promoting faster development and deployment.
Easier maintenance: With microservices, it's easier to identify and fix i...
I have worked with various design patterns such as Singleton, Factory, Observer, and MVC.
Implemented Singleton pattern to ensure only one instance of a class exists
Utilized Factory pattern to create objects without specifying the exact class
Implemented Observer pattern to establish a one-to-many dependency between objects
Utilized MVC pattern to separate the concerns of data, presentation, and user input
I applied via Approached by Company and was interviewed before Dec 2023. There were 5 interview rounds.
One-on-one coding discussion problem.
Coding problem and 1-2 discussing
Coding statement and 1-1 discussions
posted on 18 Oct 2022
There are 30 questions Mixed with Aptitude, AWS, OS
OOPS (Object-Oriented Programming) is a programming paradigm that uses objects to represent and manipulate data.
OOPS focuses on the concept of objects, which are instances of classes.
It emphasizes encapsulation, inheritance, and polymorphism.
Encapsulation ensures data hiding and abstraction.
Inheritance allows classes to inherit properties and behaviors from other classes.
Polymorphism enables objects to take on multiple...
posted on 12 Jul 2022
Interview experience
based on 1 review
Rating in categories
Lead Software Engineer
972
salaries
| ₹10 L/yr - ₹35 L/yr |
Software Engineer
915
salaries
| ₹7 L/yr - ₹22 L/yr |
Process Specialist
294
salaries
| ₹3.4 L/yr - ₹7.2 L/yr |
Principal Software Engineer
221
salaries
| ₹19.8 L/yr - ₹55 L/yr |
Senior Process Specialist
186
salaries
| ₹4 L/yr - ₹9 L/yr |
Vanguard
Blackrock
Charles Schwab
JPMorgan Chase & Co.