An Oracle PL/SQL Developer is responsible for developing and maintaining Oracle database applications using the PL/SQL programming language.
Developing and maintaining Oracle database applications using PL/SQL.
Proficient in advanced Analytical functions.
Substantial development experience in creating stored procedures, PL/SQL packages, Triggers and functions. Strong knowledge in oracle cursor management and exceptional handling.
Optimizing database performance by tuning SQL queries and PL/SQL code.
Developing and executing test plans to ensure the quality and accuracy of PL/SQL code.
Troubleshooting and resolving issues related to PL/SQL code.
Exposure in User requirement analysis and translating them in to Technical specifications, designing, development and coding related to projects using oracle.
Developing simpler complex queries to pull relevant data points from different tables for respective reports.
Written a complex SQL(subqueries and join conditions), PL/SQL
Proficient in creation, modification and effectively use of database objects like tables, constraints, sequences, indexes, group functions and views.
Ability to business requirement and data models.
Experience and exposure in Query tuning using materialized view and indexes.
Highest Qualification
B.E/B tech with minimum 60% in 10th ,12th and UG
6 to 24 months of experience in the relevant domain
Skillset Required
Good to know on Data migration activity.
Fair knowledge in Unix/Shell scripting.
Should have experience in Oracle DB for writing back - end procedure using PL / SQL.
Enhancement and maintenance of Data integration / Exchange with various Applications.
Strong Analytical and problem solving skills.
Very good Java Knowledge for application development.
Interpersonal Skills
Strong written and oral communication skills.
Excellent documentation skills.
Strong presentation and interpersonal skills.
Ability to present ideas in user-friendly manner.
Tool Skills (Tool Skills will include but not be limited to the following)
Knowledge and experience in Oracle PL , PLSQL , Data Migration, Data Integration , Application Development , SQL Developer, Toad or ETL.
