Filter interviews by
Clear (1)
Window functions in SQL are used to perform calculations across a set of table rows related to the current row.
Window functions are used to calculate values based on a specific subset of rows within a table.
They allow for ranking, aggregation, and other calculations without grouping the rows.
Examples of window functions include ROW_NUMBER(), RANK(), and SUM() OVER().
Delta Lake is an open-source storage layer that brings ACID transactions to Apache Spark and big data workloads.
Delta Lake is built on top of Apache Spark and provides ACID transactions for big data processing.
It allows for schema enforcement and evolution, data versioning, and time travel queries.
Delta Lake is compatible with popular data science and machine learning libraries like TensorFlow and PyTorch.
Top trending discussions
posted on 6 Oct 2022
I applied via Referral and was interviewed before Oct 2021. There were 3 interview rounds.
CFA and DFA are Change-Tracking and Database-First Approaches in Entity Framework Core.
CFA (Change-Tracking Approach) is used to track changes made to entities in memory and then save them to the database.
DFA (Database-First Approach) is used to generate entity classes and DbContext from an existing database schema.
CFA is useful when working with disconnected entities, while DFA is useful when working with an existing ...
posted on 19 Jul 2022
I applied via Recruitment Consulltant and was interviewed in Jan 2022. There were 2 interview rounds.
I applied via Campus Placement and was interviewed in Oct 2022. There were 4 interview rounds.
1 easy sql and 1 easy python for 55 min
1 easy python and very hard sql for 1 hr 50 min
Answering a question on writing a join and implementing left join using pandas for Data Analyst role.
To write a join, we need to identify the common column(s) between two tables and use the JOIN keyword in SQL.
Example: SELECT * FROM table1 JOIN table2 ON table1.common_column = table2.common_column
To implement left join using pandas, we can use the merge() function with how='left' parameter.
Example: pd.merge(table1, tab
I applied via Company Website and was interviewed in May 2022. There were 2 interview rounds.
General questions related to reasoning. Not much hard to crack.
Hackerrank test in Java and Angular
I applied via Walk-in and was interviewed before Mar 2023. There were 2 interview rounds.
Excel and sql test duration 2 hrs
I applied via Naukri.com and was interviewed in May 2024. There were 3 interview rounds.
I applied via Campus Placement and was interviewed in Mar 2024. There were 2 interview rounds.
60 minutes 60 questions
based on 2 interviews
Interview experience
based on 2 reviews
Rating in categories
Data Processing Analyst
795
salaries
| ₹0 L/yr - ₹0 L/yr |
Data Analyst
468
salaries
| ₹0 L/yr - ₹0 L/yr |
Data Processing Specialist
347
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer
242
salaries
| ₹0 L/yr - ₹0 L/yr |
Research Associate
182
salaries
| ₹0 L/yr - ₹0 L/yr |
Kantar
GfK MODE
Dun & Bradstreet
Euromonitor International