Tagcor

Required Skills

Oracle PL SQL Developer

Work Authorization

US Citizen
Green Card

Preferred Employment

Corp-Corp

Employment Type

Consulting/Contract

education qualification

UG :- - Not Required
PG :- - Not Required

Other Information

No of position :- ( 1 )
Post :- 16th Jun 2022

JOB DETAIL

"Looking for PL/SQL developer with Minimum: 7 to 8 years of experience in PL/SQL; candidate shall be available in EST time zone? Well versed and strong hands on PL/SQL, ? Thorough understanding and analysis techniques for going through existing packages to find out what tables/cols being used and come up with plan what needs to be changed ? Strong impact analysis techniques to arrive at impacted modules/packages/ reports due to the changes done to tables, columns, packages etc.? Strong trouble shooting techniques ? Excellent knowledge of Oracle SQL, PL/SQL (ideally Oracle 11g/12c/19c)? Good knowledge of Oracle database architecture and overview of object-oriented programming in Oracle database? Familiar with database management programs (SQL Developer)? Solid Experience of creating PL/SQL Packages, Procedures, Functions, Materialized views, Triggers (specifically Instead of), Views and Exception handling for retrieving, manipulating, checking complex data sets in Oracle.? Good in understanding packages/Stored Procedures, functions based on existing script or code in another tech stack.? Script queries for the drill-down reports.? Develop SQL statements to improve back-end communications.? Ability?of?unit?testing,?integrated?testing?&?Documentation?of?codes.?? Knowledge on Database jobs and Scheduler? Good to have any earlier experience in ERP, ERP databases