PLSQL developer

Job description

TCS is hiring for PLSQL Developer

Desired Experience

Range - 3 to 8 years Location - Chennai, Bangalore, Hyderabad

• 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 Performance 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)

Qualifications

Undergraduate