T
PLSQL developer
Tata Consultancy Services (TCS)
Chennai, Bengaluru, Hyderābād
Full-Time
0-3 Years experience
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)
About Tata Consultancy Services (TCS)
TCS is a global IT services, consulting, and business solutions organization that partners with leading businesses worldwide. It provides technology and engineering services driven by innovation and digital transformation.