PLSQL Developer
- Quess Corp Magna
- 5 to 10 Yrs
- Multi-City, India
- 2 years ago
- Email to a friend
- Report this job
Job Description
We are hiring for PL/SQL Developer,
Np- 15days to Immediate
Experience Required: 4-15 Years
Location: Bangalore/ Hyderabad/ Chennai/ Pune/ Kolkata/ Gurgaon
Detailed JD:
Candidate must have at least 5-8 years of relevant experience in Oracle SQL/PLSQL
Must be good in communication, approachable and proactive.
Must be good in hands-on SQL;
Joins : INNER, LEFT, RIGHT, FULL, CARTESION join of two or more tables
Aggregate Functions : COUNT, MIN, MAX, AVG, FIRST, LAST, LISTAGG
Analytic Function : LEAD, LAG, RANK, DENSE_RANK, FIRST_VALUE, LAST_VALUE, ROW_NUMBER
View and Materialized Views : Basics of creating and maintaining views
Hierarchical queries : Data retrieval from table having hierarchical data
Oracle SYS tables : Basic knowledge on Oracle metadata tables
Privileges : How Role/Object level privileges works
Complex Queries : Nested queries, inline views, co-related subqueries
Data Types : Different types of oracle defined data types and their usage (especially CLOB, BLOB, LONG)
Table Partitioning : Basic knowledge on table & index partitioning
Oracle Functions : NVL, NVL2, DECODE, GREATEST, COLLESCE,
Candidate should know the concept of Oracle sharding
PL/SQL;
PL/SQL Objects : Create and maintain objects like procedures, functions, packages , types, triggers,
Recursion, Loops (FOR, WHILE DO), Nested blocks, conditional logic (IF, CASE statements)
Exception handling : Knowledge on how to manage run time oracle defined/user defined errors
Collection & Records : Ways of using collection and records in PL/SQL blocks
BULK operation : Knowledge on performing operations on bulk
URL to apply : https://talentflow.in/Search/Jobs/ 66431-PL/SQL-Developer
Employement Category:
Employement Type: Full timeIndustry: IT - Software
Role Category: Application Programming / Maintenance
Functional Area: Not Applicable
Role/Responsibilies: PLSQL Developer
Contact Details:
Company: Quess Corp MagnaLocation(s): Multi-City, India
Keyskills: oracle sql oracle pl/sql development desnse functions analytic first rank value
Quess Corp Magna
Magna Infotech is a division of USD 400 + million Quess Group (quesscorp.com) which in turn is a subsidiary of USD 37+ billion - Canadian Multinational, Fairfax Financial Holding Group. Magna Infotech is the largest staff Augmentation and Solutions Company in India, USA and APAC regions. We are a ...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in