i
Coverfox
Filter interviews by
I applied via Recruitment Consulltant and was interviewed before Mar 2023. There were 2 interview rounds.
posted on 9 May 2024
The output of 4 joins is a result set that combines data from multiple tables based on specified conditions.
Joins are used to combine rows from two or more tables based on a related column between them.
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
Processing of joins involves matching rows from the tables based on the specified join condition.
The output of 4 joins would involve combining data ...
Self joins between tables with CTE are used to join a table to itself using Common Table Expressions.
Self joins are used when you need to compare rows within the same table.
CTE is used to create a temporary result set that can be referenced multiple times in a query.
Example: SELECT e1.employee_id, e2.manager_id FROM employees e1 JOIN employees e2 ON e1.manager_id = e2.employee_id
Optimizations in Spark involve tuning configurations, partitioning data, using efficient transformations, and caching intermediate results.
Tune configurations for memory and parallelism
Partition data to distribute workload evenly
Use efficient transformations like map, filter, and reduce
Cache intermediate results to avoid recomputation
I applied via Referral and was interviewed before Jan 2022. There were 3 interview rounds.
Zonal manger taken the interview along with Area manager
posted on 4 Mar 2025
posted on 11 Nov 2024
I applied via Referral and was interviewed before Nov 2023. There was 1 interview round.
posted on 13 Jan 2023
posted on 30 Jul 2021
I applied via Referral and was interviewed in Jun 2021. There were 3 interview rounds.
posted on 13 Aug 2020
I applied via Recruitment Consultant and was interviewed before Aug 2019. There were 3 interview rounds.
posted on 13 Jul 2022
I applied via Referral and was interviewed before Jul 2021. There was 1 interview round.
posted on 2 Sep 2021
I applied via Walk-in and was interviewed before Sep 2020. There was 1 interview round.
based on 1 interview
Interview experience
based on 3 reviews
Rating in categories
Customer Advisor
38
salaries
| ₹2.4 L/yr - ₹4 L/yr |
SME
27
salaries
| ₹3.2 L/yr - ₹5.6 L/yr |
Team Lead
23
salaries
| ₹3.2 L/yr - ₹5.6 L/yr |
Quality Analyst
20
salaries
| ₹2.5 L/yr - ₹5.2 L/yr |
Sales Executive
18
salaries
| ₹2.4 L/yr - ₹3.5 L/yr |
Bajaj Allianz Life Insurance
SBI Life Insurance Company
AXA Business Services
Kotak Mahindra General Insurance