Filter interviews by
I applied via Recruitment Consulltant and was interviewed before Feb 2023. There were 3 interview rounds.
The Windows function in SQL is used to perform calculations on a specific subset of rows in a result set.
The Windows function is used with the OVER clause to define the subset of rows to perform calculations on.
Common Windows functions include ROW_NUMBER, RANK, DENSE_RANK, and NTILE.
Example: SELECT ROW_NUMBER() OVER (PARTITION BY department ORDER BY salary DESC) AS row_num FROM employees;
I applied via Naukri.com and was interviewed before Oct 2022. There were 3 interview rounds.
The first round was with the consultancy manager and they screened my resume and felt it is good match for the role. The second round was taken by the Project Manager of LinkedIn and 3rd round from the assigned team's manager. Both the last two rounds included cases studies, Questions on the resume and previous experiences and the decision making on the situations.
There were few questions from my end to the interviewer on the 3rd round for which the interviewer(she) got irritated and asked me to check on the JD, the question was in relate to know the products of LinkedIn whereas the the details in related to the products of LinkedIn was not mentioned. Only the role and responsibilities were stated.
However she even escalated this to the consultancy. I felt the interviewer is so immature and impatient in handling situations and was skeptical of her handling the team and eventually it proved right.
She made me feel very degraded being a Contract role employee, even a small mistakes and even misunderstandings were notified to the consultancy and was been escalated. It clearly showed that there is lack of leadership qualities and taken for granted attitude. (The team is "Outsourcing and Strategy")
I wish no one should no face such situations and get departed for silly reasons, Everyone has their commitments, responsibilities and duties which will affected deeply in the midway.
Nonetheless every employee irrespective of Permanent or Contractual deserves respect, motivation and a good words from his/her hierarchy rather pointing out, escalations will take no where.
I was surprised that LinkedIn has such attitude issues with contract role employees (Some managers).
However, I wish whoever applying to any roles in LinkedIn do get a good manager at the first place and the rest all falls in its place eventually. All the best...!!!
Top trending discussions
I applied via Approached by Company and was interviewed in Jan 2024. There was 1 interview round.
SQL based test, basic to advance concepts
I applied via Approached by Company
Calculate running total
I applied via LinkedIn
What should be the metrics to track for ideal customers
I applied via Referral and was interviewed in Mar 2024. There were 2 interview rounds.
They sent a hackerrank test which had only sql questions
They asked for my last project and asked few sql questions. They also asked few statistics question which was not expected
I applied via Naukri.com and was interviewed in May 2023. There were 3 interview rounds.
I applied via Naukri.com and was interviewed in Mar 2024. There was 1 interview round.
I applied via LinkedIn and was interviewed before Aug 2022. There were 5 interview rounds.
Open-ended case study to understand your approach and considerations. Use common sense, explain your thinking and be rigorous. Can come from any field but does not require field-intensive knowledge
I applied via Recruitment Consultant and was interviewed in Jul 2019. There were 6 interview rounds.
based on 2 interviews
Interview experience
based on 2 reviews
Rating in categories
Software Engineer
88
salaries
| ₹17 L/yr - ₹70 L/yr |
Trust and Safety Specialist
73
salaries
| ₹5.5 L/yr - ₹9 L/yr |
Senior Software Engineer
63
salaries
| ₹29.6 L/yr - ₹91.8 L/yr |
Software Developer
62
salaries
| ₹17.5 L/yr - ₹40 L/yr |
Content Reviewer
37
salaries
| ₹3.6 L/yr - ₹9.9 L/yr |
Amazon
Flipkart
Udaan
BigBasket