<p>Specialist - Data Engineering</p> <p>Mandatory Certification Oracle Database PLSQL Developer Certified Professional<</p> <p>Candidate should have minimum 5 to 8 years of experience<</p> <p>Candidate should have good exposure in Oracle database with plsql and sql queries <</p> <p>o Experience of working on in data dictionary views <</p> <p>o Experience of working on complex queries <</p> <p>o Should have good knowledge of PLSQL and data processing viz functions procedures packages triggers bulk processing collection and exception handling <</p> <p>Candidate should have exposure in any CICD pipeline knowledge of Jenkits and BitBucket would added advantage <</p> <p>Should be good in verbal and written communication <</p> <p>Candidate should be proactive and should not act in passive manner to any issue escalation<</p> <p>Connect with onshore team daily to provideget the handover</p> <p><</p> <p>Candidate must have at least 6-7 years of relevant experience in Oracle SQLPLSQL<</p> <p>Must be good in communication approachable and proactive<</p> <p>Must be good in handson<</p> <p>SQL<</p> <p>Joins INNER LEFT RIGHT FULL CARTESION join of two or more tables<</p> <p>Aggregate Functions COUNT MIN MAX AVG FIRST LAST LISTAGG<</p> <p>Analytic Function LEAD LAG RANK DENSERANK FIRSTVALUE LASTVALUE ROWNUMBER<</p> <p>View and Materialized Views Basics of creating and maintaining views<</p> <p>Hierarchical queries Data retrieval from table having hierarchical data<</p> <p>Candidate must have experience in query tuning understanding explain plan reading AWR ASH reports<</p> <p>Oracle SYS tables Basic knowledge on Oracle metadata tables <</p> <p>Privileges How RoleObject level privileges works <</p> <p>Complex Queries Nested queries inline views corelated subqueries <</p> <p>Data Types Different types of oracle defined data types and their usage especially CLOB BLOB LONG<</p> <p>Table Partitioning Basic knowledge on table index partitioning<</p> <p>Oracle Functions NVL NVL2 DECODE GREATEST COLLESCE <</p> <p>Candidate should have knowledge in Oracle 19c and 21c</p> <p>Candidate should know the concept of Oracle sharding</p> <p>PLSQL</p> <p>PLSQL Objects Create and maintain objects like procedures functions packages types triggers</p> <p>Recursion Loops FOR WHILE DO Nested blocks conditional logic IF CASE statements</p> <p>Exception handling Knowledge on how to manage run time oracle defineduser defined errors</p> <p>Collection Records Ways of using collection and records in PLSQL blocks</p> <p>BULK operation Knowledge on performing operations on bulk</p> <p>Responsibility</p> <p>Work with development teams ensuring adherence to database standards</p> <p>Oversee change management process for database objects across multiple projects</p> <p>Accountable for delivery of the database objects through SIT UAT</p> <p>Candidate should have knowledge of SDLC especially in multitenant DB instancesÂ</p> <p>Should be good in verbal and written communicationÂ</p> <p>Candidate should be proactive and should not act in passive manner to any issue escalation <</p> <p>Edison - New Jersey - USA5 - 8 Years10R14-Apr-2025NACTIVE1367228Mandatory Skills : Flexcube technical PL/SQL, MS SQL</p>