Job Description
Job description
Role & responsibilities
Roles and Responsibilities
- 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.
- Understanding in Java,
