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 84000 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
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 RefCursors 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. Dont process candidates who dont have exp in 12C and above.
Key skills : Oracle Plsql SQL
Work experience : 48Years
Employment type : Full Time
Work mode : Work from Office
Educational qualification : Any Graduate
Job location : Mumbai (Mahape)
Notice Period : 15 Days ( Must join within 15 Days )