Oracle PL/SQL Developer

ORACLE PL/SQL DEVELOPER LONG TERM CONTRACT PHILADELPHIA, PA REMOTE WITH GOING IN ON OCCASION NEED TO TAKE AN ONLINE PL/SQL TECHNICAL TEST VISA- NO CPT/OPT/H1B INTERVIEW- 2 ROUNDS Need local candidates within 1 hour of Center City Philadelphia PA. Top Technical Skills: 7 plus years of backend focused Development using PL/SQL. MUST be expert level, strong dev and troubleshooting skills ETL experience/transactions into the backend with PL/SQL (strong skills on integration of data from various sources) Strong skills with TSQL Development (intermediate level) Strong soft skills/ tech chop combo to engage the biz and IT Formal Job Description: Oracle PL/SQL developer to create back-end software. This developer will work on existing mission critical applications. In this role, the developer must be able to interpret business requirement documents, write functional code and unit test. Additionally, the developer will be required to fix defects in legacy code. The developer should be a team player and excellent communicator and must be able to work with source control on multiple simultaneous branches. Requirements Proven experience as a PL/SQL Application Developer using Toad, SQL Plus (minimum 5 years) Ability to create queries, views, packages, functions, and stored procedures Ability to work with collections Ability to work with async processes Interpret execution plans and optimize queries and functions Ability to create complex DML and debug Excellent troubleshooting and communication skills Attention to detail is of the utmost importance BS/BA in Computer Science, Engineering, or equivalent experience with at least 5 years of development experience Responsibilities Participate in requirements analysis Take direction from senior developers Collaborate with internal teams to produce software Write clean, scalable code Unit test and prepare applications for deployment Revise, update, refactor and debug code Improve existing software Create documentation as required Provide production support Available to provide third tier support to the help desk on assigned weekends and holidays if needed. Ability to work hybrid on-site