PL/SQL Developer and Support

Job description

**Role: PL/SQL Developer and Support** **Location: Chennai( Apply only Chennai location candidates)** **Exp: 3-10 yrs** **Mode of interview** : **WALKIN INTERVIEW ON (4-JUL-26) F2F INPERSON** **Must Have Skills:** Minimum 5 mandate details are mandate with two or 3 liners 1. Strong **PL/SQL** **development** experience 2. **Expertise in SQL** query writing and optimization 3. Experience with **Stored Procedures, Packages, Functions, and Triggers** 4. Knowledge of **Joins, Indexes, Views, and Execution Plans** 5. Filtering **conditions using WHERE clause, usage of NOT IN** to derive results 6. String manipulation functions, Data Type conversions 7. Optimize performance/techniques during **MERGE operation** 8. Understanding of **Performance Tuning and Transactions** 9. Hands-on experience with SQL Developer tools 10. Data Consolidation (Transform data from multiple tables into consolidated format) 11. **Pipelined table function in PL/SQL** and best practices 12. **Nested blocks** and scope of the variables 13. **Recursive calls** 14. **Unix Basics (File Handling commands** **Good to have:** Minimum 2 mandate details are mandate with two or 3 liners 1. **Unix** (File handling commands, Shell Scripting) 2. **Autosys** (Scheduler) 3. **Jira** 4. Domain Knowledge ( **Investment Banking/Capital Markets** ) 5. **Reconciliation**