PL/SQL Developer

Job description

TCS has been a great pioneer in feeding the fire of young techies like you. We are a global leader in the technology arena and there’s nothing that can stop us from growing together.

What we are looking for Role

PL/SQL Developer Experience Range: 5 to 8 Years Location: Chennai Must Have: · Strong PL/SQL development experience Expertise in SQL query writing and optimization Experience with Stored Procedures, Packages, Functions, and Triggers

• Knowledge of Joins, Indexes, Views, and Execution
• Plans Filtering conditions using WHERE clause, usage of NOT IN to derive results String manipulation functions, Data Type conversions
• Optimize performance/techniques during MERGE operation Understanding of Perfor mance Tuning and Transactions Hands-on experience with SQL Developer tools Data Consolidation (Transform data from multiple tables into consolidated format) Pipelined table function in PL/SQL and best practices Nested blocks and scope of the variables Recursive calls Unix Basics (File Handling commands)

Good to Have

1. Unix (File handling commands, Shell Scripting) Autosys (Scheduler) Jira Domain Knowledge (Investment Banking/Capital Markets) Reconciliation </div

Qualifications

BACHELOR OF ENGINEERING