Tagcor

Required Skills

Oracle PL SQL Developer

Work Authorization

US Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit

Preferred Employment

Corp-Corp

Employment Type

Consulting/Contract

education qualification

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

Other Information

No of position :- ( 1 )
Post :- 15th Aug 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 "