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.
posted on 25 Oct 2021
I was interviewed in Jun 2021.
Round duration - 75 minutes
Round difficulty - Easy
It was an online round taken through hackerrank. There were two coding questions of Easy level, Technical and Aptitude MCQs, that we had to solve.
You are provided with 'N' intervals, each containing two integers denoting the start time and end time of the interval.
Your task is to merge all overlapping intervals a...
Merge overlapping intervals and return sorted list by start time.
Sort the intervals based on start time.
Iterate through intervals and merge overlapping ones.
Return the merged intervals sorted by start time.
You are provided with a string S
. Your task is to determine and return the number of distinct substrings, including the empty substring, of this given string. Implement the solut...
Implement a function to count the number of distinct substrings in a given string using a trie data structure.
Create a trie data structure to store the substrings of the input string.
Traverse the trie to count the number of distinct substrings.
Handle empty string as a distinct substring.
Return the count of distinct substrings for each test case.
Round duration - 15 Minutes
Round difficulty - Easy
It was a mix of Technical and Behavioural round.
Round duration - 30 minutes
Round difficulty - Easy
Final HR round for checking Compatibility with the Company.
Tip 1 : Practice as many DSA questions as possible.
Tip 2 : Focus on Core Subjects like OS, CN, DBMS as Well.
Tip 3 : Do some projects to have a good grasp on development also.
Tip 1 : Make a 1-page Resume.
Tip 2 : Keep it short and crisp, include only relevant experiences and skills.
I was interviewed in Sep 2016.
The Internet is a global network of computers that communicate with each other using standardized protocols.
The Internet is made up of millions of interconnected devices, including computers, servers, routers, and switches.
Data is transmitted over the Internet in the form of packets, which are small units of information.
The Internet uses a set of protocols, such as TCP/IP, to ensure reliable and efficient communication...
HTTP is unsecured while HTTPS is secured with SSL/TLS encryption.
HTTP stands for Hypertext Transfer Protocol, while HTTPS stands for Hypertext Transfer Protocol Secure.
HTTP operates on port 80, while HTTPS operates on port 443.
HTTP data is transmitted in plain text, while HTTPS data is encrypted using SSL/TLS.
HTTPS provides authentication, integrity, and confidentiality of data exchanged between a client and a server.
W...
White box testing is a method of testing where the internal structure and implementation details of the software are known and tested. Black box testing is a method of testing where the internal structure and implementation details of the software are unknown and only the inputs and outputs are tested.
White box testing is also known as clear box testing, glass box testing, or structural testing.
It focuses on testing th...
Print a pattern using code
Use nested loops to iterate through rows and columns
Use string concatenation to build each row of the pattern
Print each row to display the pattern
Merge two arrays without using a third array.
Use the concat() method to merge the arrays.
Alternatively, you can use the push() method to add elements from one array to another.
Remember to handle the case where the arrays have different lengths.
The probability that three ants at the corner of a triangle will never meet.
The ants can move randomly in any direction.
The probability depends on the shape and size of the triangle.
The probability can be calculated using geometric probability or simulation.
Assumptions need to be made about the ants' movement patterns.
I have regretted decisions in the past but learned from them to make better choices in the future.
Regretted not studying enough for a crucial exam, leading to a lower grade. Learned to prioritize studying and time management.
Regretted not speaking up in a meeting when I had a valuable idea. Learned to be more assertive and confident in sharing my thoughts.
Regretted not taking a job opportunity that could have advanced ...
I come from a close-knit family with a passion for outdoor activities. We recently celebrated my brother's graduation, which was a proud moment for all of us.
Family: Close-knit and supportive
Hobbies: Outdoor activities like hiking and camping
Proud moment: Brother's graduation ceremony
posted on 2 Dec 2015
posted on 20 May 2017
I was interviewed in May 2017.
Yes, the string class can be extended in most programming languages.
Inheritance can be used to extend the functionality of the string class.
By creating a new class that inherits from the string class, additional methods and properties can be added.
Extending the string class allows for customization and adding specific functionality to strings.
Example: In Python, the string class can be extended by creating a new class
Implicit objects in JSP are predefined objects that are available for use without any declaration or initialization.
Implicit objects in JSP include request, response, session, application, out, config, pageContext, page, exception, and others.
These objects provide access to various aspects of the JSP environment and can be used to perform common tasks.
For example, the request object allows access to HTTP request parame...
A hash map is a data structure that uses a hash function to map keys to values.
Hash map stores key-value pairs
It uses a hash function to compute an index for each key
Collisions can occur when two keys hash to the same index
Hash maps provide fast access to values based on their keys
StringBuffer and StringBuilder are both used to manipulate strings, but StringBuffer is thread-safe while StringBuilder is not.
StringBuffer is synchronized, making it safe for use in multi-threaded environments.
StringBuilder is not synchronized, making it faster but not thread-safe.
StringBuffer is preferred when multiple threads are involved, while StringBuilder is preferred for single-threaded scenarios.
Both classes p...
MVC is a software architectural pattern that separates an application into three main components: Model, View, and Controller.
Model represents the data and business logic of the application.
View is responsible for displaying the user interface.
Controller handles user input, updates the model, and interacts with the view.
MVC promotes separation of concerns and modularity in software development.
Example: In a web applica...
Annotations used in RESTful web services
1. @Path - Specifies the URI path for the resource
2. @GET - Specifies that the method handles HTTP GET requests
3. @POST - Specifies that the method handles HTTP POST requests
4. @PUT - Specifies that the method handles HTTP PUT requests
5. @DELETE - Specifies that the method handles HTTP DELETE requests
6. @PathParam - Binds the value of a URI template parameter to a method paramete...
I was interviewed before Jun 2016.
I prefer to work in a location that offers a vibrant and diverse community, with access to cultural events and opportunities for personal growth.
I value a location that has a strong sense of community and offers a variety of cultural activities.
Access to educational and personal growth opportunities is important to me.
I am open to considering different locations that meet these criteria.
I was interviewed before Aug 2016.
I have the analytical skills, experience, and passion to excel in this role.
I have a strong background in data analysis and interpretation
I have experience in using various analytical tools and techniques
I am detail-oriented and have a proven track record of delivering accurate and insightful analysis
I am a quick learner and can adapt to new challenges and environments easily
posted on 13 May 2017
I was interviewed before May 2016.
I was interviewed in Dec 2016.
based on 1 interview
Interview experience
based on 1 review
Rating in categories
Lead Software Engineer
963
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer
906
salaries
| ₹0 L/yr - ₹0 L/yr |
Process Specialist
296
salaries
| ₹0 L/yr - ₹0 L/yr |
Principal Software Engineer
229
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Process Specialist
196
salaries
| ₹0 L/yr - ₹0 L/yr |
Vanguard
Blackrock
Charles Schwab
JPMorgan Chase & Co.