PL/SQL Developer and Support

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/SQLdevelopment 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