I applied through a staffing agency. The process took 1 week. I interviewed at Leiten Technologies (Chennai) in Dec 2024
Interview
Technical Screening: Online tests or coding challenges focusing on SQL, PL/SQL concepts (cursors, triggers, stored procedures).
HR Screening: Basic questions on experience, resume, and behavioral aspects.
Final Interview/Offer: Salary discussion, cultural fit evaluation, and offer negotiation.
Interview questions [1]
Question 1
1. What are the differences between a procedure and a function in PL/SQL?
2. Explain the difference between INNER JOIN, LEFT JOIN, and RIGHT JOIN.
3. What is a WITH clause, and how does it help in query optimization?
