I applied through a recruiter. The process took 2 weeks. I interviewed at Netcracker Technology (Pune) in Nov 2024
Interview
3 round-2 technical, 1 Managerial (All were approx 1 hr and above).
First round- Starts from basic then gradually moved to advance level plsql questions (index, tuning, procedure, exception handling, cursors, hierarchical query, etc). More focused on clarity of concepts rather than syntax.
2nd round after 5 days- Similar to first round also, asked the question which I was not able to answer in first round. some basic SQL query to write, given a situation to write a procedure.
Managerial: Asked about project, then few situational and technical question followed by salary expectation, etc.
Interview questions [1]
Question 1
Sql query to remove duplicate.
Query to convert a given sentence into multiple rows using space as delimiter.
Usage of cursor and its implementation