PLSQL Developer

Tata Consultancy Services; Hyderabad, Chennai; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Tata Consultancy Services is seeking a seasoned SQL/PL/SQL developer to implement robust data processing pipelines in a Unix environment. The role focuses on writing optimized SQL, building stored procedures, and transforming data from multiple sources into consolidated outputs.

Candidates should be proficient with MERGE operations, execution plans, and performance tuning. Familiarity with Autosys, Jira, and financial domain knowledge is a plus.

Qualifications

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

Responsibilities

• 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).
• Unix (File handling commands, Shell Scripting)
• Autosys (Scheduler)
• Jira
• Domain Knowledge (Investment Banking/Capital Markets)
• Reconciliation

Skills

PL/SQL

SQL optimization

Stored procedures

Execution plans

UNIX basics

Data consolidation

Pipelined func

Nested blocks

Recursive calls

MERGE optimization

Data type conversion

String manipulation

Autosys

Jira

Investment banking

Reconciliation

Tools

SQL Developer

Job description

Role & responsibilities

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

1. Unix (File handling commands, Shell Scripting)
2. Autosys (Scheduler)
3. Jira
4. Domain Knowledge (Investment Banking/Capital Markets)
5. Reconciliation