PL/SQL Developer

Job Role: - Oracle PL SQL Developer Job Location: - Tampa, FL (3 days onsite in a week)FulltimeJob Description:-Strong understanding between OLTP and Batch Processing using SQL and PLSQLOracle Table Indexs all types Primary KeyOracle Table Partitions Fetch JSON data using PIVOT unknown number of columns applying rowlocks using SELECTStrong written knowledge on SQL Joins PLSQL collection's Deterministic function good understanding on sysrefcursorHow to capture which program is calling Oracle PLSQL Procedure function packagesStrong on Oracle SQL parsing SQL engine vs PLSQL engine PLSQL cursors To Date to timestamp Renaming table columnsVery Good understanding of SQL execution plan inline functionsBest approaches on implementing user defined referential constraint check using PLSQLComparing data between two identical tables and finding list of columns with unmatched values fastest method on storing and retrieval of JSON data from CLOB columns why should be use Execute Immediate Oracle PLSQL exceptions user defined as well Oracle providedPLSQL cursor Multiple ways to pass data from Oracle PLSQL procedure to Angular or Java or Python SQL operator in any ALLAdvantage and disadvantage of using PLSQL packages good understanding on Transaction within another Transaction in OracleKarat Industry certification in Oracle Database