Job Description

About Company:Our Company is a global technology consulting and digital solutions company that enables enterprises to reimagine business models and accelerate innovation through digital technologies. Powered by more than 84,000 entrepreneurial professionals across more than 30 countries, caters to over 700 clients. Our extensive domain and technology expertise helps drive superior competitive differentiation, customer experiences, and business outcomes

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

Key skills : Oracle, Plsql, SQLWork experience : 4-8Years
Employment type : Full Time
Work mode : Work from Office
Educational qualification : Any GraduateJob location : Mumbai (Mahape)Notice Period : 15 Days ( Must join within 15 Days )

People Prime Worldwide