Filter interviews by
SQL window functions allow for advanced data analysis by performing calculations across a set of table rows related to the current row.
Window functions operate on a set of rows defined by an OVER() clause.
Common window functions include ROW_NUMBER(), RANK(), DENSE_RANK(), and SUM().
Example: SELECT employee_id, salary, RANK() OVER (ORDER BY salary DESC) AS salary_rank FROM employees;
Window functions do not change the nu...
I applied via Campus Placement and was interviewed before Nov 2021. There were 3 interview rounds.
Moderate level aptitude with basics
Moderate level data structure questions
What people are saying about Startup
I have a strong background in software engineering and a passion for innovation, making me a valuable asset to HSBC.
I have a proven track record of successfully delivering high-quality software solutions in previous roles.
I am highly skilled in various programming languages and technologies, including Java, Python, and SQL.
I have experience working in agile development environments, allowing me to adapt quickly to chan...
I applied via Naukri.com and was interviewed before Apr 2020. There were 3 interview rounds.
SCD Type 2 is a technique used to track historical changes in data over time in a data warehouse.
SCD Type 2 maintains a separate row for each change in data, with a start and end date.
It requires a surrogate key to uniquely identify each row.
Informatica provides a built-in SCD Type 2 transformation to implement this technique.
Example: tracking changes in customer addresses over time.
To find the frequency of each word in a sentence.
Split the sentence into words
Create a dictionary to store word frequency
Iterate through the words and update the dictionary
Return the dictionary
I appeared for an interview in May 2025, where I was asked the following questions.
I applied via Campus Placement and was interviewed before Dec 2023. There were 2 interview rounds.
Asked Two 2 DSA questions
2 hours long was the coding round
based on 1 interview experience
Software Engineer
43
salaries
| ₹11.2 L/yr - ₹23.1 L/yr |
Software Developer
37
salaries
| ₹3.4 L/yr - ₹9.6 L/yr |
Consultant
22
salaries
| ₹10.8 L/yr - ₹35.3 L/yr |
Product Manager
18
salaries
| ₹20 L/yr - ₹32.9 L/yr |
Front end Developer
18
salaries
| ₹1 L/yr - ₹5 L/yr |
HSBC Group
Cholamandalam Investment & Finance
Citicorp
BNY