Detailed Job Description:
5+ years of experience in all phases of SDLC including requirement gathering, analysis, application design, development, testing, implementation and maintenance.
• Extensive SQL and PL/SQL programming experience including packages, stored procedures, functions, triggers, indexes, and exception handling. Create database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL*Plus, SQL Developer, toad.
• Strong working knowledge of Loading Data using SQL* Loader and PL/SQL using different file format.
• Extensive experience in trouble shooting, Query Optimization and performance tuning use of explain plans.
• Experience in using the features Ref-Cursors, PL/SQL Tables, Materialized Views, Dynamic SQL and Oracle RAC.
• Experience to write scheduler jobs and Troubleshoot issue if any failures.
• Analyze application requirements and provide recommended design. Support code migration from development to staging environment.
• Write complex SQL queries and PL/SQL procedures to extract data from various source tables.
• Ability to work independently and as part of a team, deliver under pressure and tight deadlines.
Mandatory pointers for PLSQL sourcing:
- Minimum relevant experience should be more than 4 years. Any less than 4 yrs will not be considered.
- Sourcer need to ask basic screening questions to all the candidates. Candidate should have to answer at least 4 Out of 5 questions. [ Questionnaire along with answers is attached in the mail.]
- Oracle version 12C and above is mandatory. Don’t process candidates who don’t have exp in 12C and above.