PL/SQL Developer

Greetings from TCS!!!

JD :

Position: PL/SQL Developer

Job Location: Pune

Experience: 6-8 years

Role & responsibilities:

Must Have:

• Having minimum of 5 + Years of IT experience as an ORACLE PL/SQL Developer
• Involved in Requirement Gathering, analysis,
• Design, Development
• Unit Testing
• Production Deployment and Support.

Detailed Job requirements for both positions:-

• Understanding and Collecting requirements from Business user side or Business Analyst and try to convert that requirement to SQL queries or PL SQL.
• Convert the Business need into Technical complex queries.
• Use different strategies of database development to meet the client functional requirement.
• Expertise in SQL and PL/SQL programming, developing complex code units.
• Solid Experience of creating PL/SQL Packages, Procedures, Functions, Triggers, Views and Exception handling for retrieving, manipulating, checking and migrating complex data sets in Oracle.
• Experience in data migration/conversation using SQL*Loader.
• Experience in Data migration using import and export.
• Expertise in creating the indexes on tables and partitioning the table for SQL tuning purpose.
• Expertise in writing procedures, functions, views, materialized views as required.
• Responsible for performance tuning activities in the project.