Filter interviews by
Clear (1)
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 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.
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 Walk-in
I listed a job that I was fired from after only a few weeks.
Listed a job where I was fired after a few weeks
Didn't provide a clear explanation for why I was let go
Didn't highlight any skills or accomplishments from that job
I admire Dr. Raghunath Anant Mashelkar, an IIT Bombay alumnus, for his contributions to science and technology.
Dr. Mashelkar is a chemical engineer and has made significant contributions to the field of polymer science.
He has also served as the Director General of the Council of Scientific and Industrial Research (CSIR) and has been awarded numerous honors, including the Padma Shri and Padma Bhushan.
Dr. Mashelkar has a...
The eurozone crisis refers to the economic and financial difficulties faced by some countries in the European Union.
The crisis began in 2009 with the Greek debt crisis and spread to other countries in the eurozone.
It was caused by a combination of factors including high levels of debt, low economic growth, and structural problems within the eurozone.
The crisis led to bailouts of several countries by the European Centra...
The Libor Scam was a manipulation of the London Interbank Offered Rate (Libor) by banks to benefit their own trading positions.
Libor is a benchmark interest rate used globally for financial products
Banks were found to have manipulated the rate to benefit their own trading positions
The scandal resulted in billions of dollars in fines for banks involved
Several high-profile bankers were also convicted for their involvemen...
Derivatives are financial instruments that derive their value from an underlying asset or security.
Derivatives can be used for hedging or speculation.
Examples of derivatives include futures, options, and swaps.
Derivatives can be traded on exchanges or over-the-counter.
Derivatives can be complex and involve significant risk.
Derivatives played a role in the 2008 financial crisis.
Failure to avoid fiscal cliff could lead to severe economic repercussions globally and in the US, with India also being affected.
The US economy could experience a recession, with a potential decrease in GDP and increase in unemployment rates
Global financial markets could experience volatility and uncertainty
India could be affected due to its close economic ties with the US, with potential impacts on trade and investmen...
Prime Services is a suite of financial services offered by investment banks to hedge funds and other institutional clients.
Prime brokerage
Securities lending
Cash management
Risk management
Trade execution
Reporting and analytics
Examples: Goldman Sachs Prime Services, J.P. Morgan Prime Services
QE stands for Quantitative Easing. It is a monetary policy used by central banks to stimulate the economy.
QE involves the central bank buying government bonds or other securities from the market to increase the money supply.
The increased money supply is intended to lower interest rates, encourage borrowing and spending, and boost economic activity.
QE is typically used when interest rates are already low and traditional...
Using bitwise operator to check the last bit of the number.
Use bitwise AND operator with 1 to check the last bit of the number.
If the result is 0, the number is even. If the result is 1, the number is odd.
Example: 6 & 1 = 0 (even), 7 & 1 = 1 (odd)
Implement a dynamic 2D excel sheet using DS
Use a 2D array to store the data
Implement functions to add, delete, and modify data
Use data structures like linked lists or hash tables for efficient searching and sorting
Implement dynamic resizing to handle large amounts of data
Use GUI libraries like Tkinter or PyQt for user interface
Joining tables in DBMS evolved as a solution to handle complex data relationships.
Joins allow combining data from multiple tables based on a common column.
The concept of joins originated from the need to handle complex data relationships.
Joins can be inner, outer, left, right, or cross depending on the type of data required.
Joins can improve query performance by reducing the number of queries needed to retrieve data.
Jo...
based on 1 interview
Interview experience
based on 1 review
Rating in categories
Lead Software Engineer
967
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer
896
salaries
| ₹0 L/yr - ₹0 L/yr |
Process Specialist
288
salaries
| ₹0 L/yr - ₹0 L/yr |
Principal Software Engineer
229
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Process Specialist
192
salaries
| ₹0 L/yr - ₹0 L/yr |
Vanguard
Blackrock
Charles Schwab
JPMorgan Chase & Co.