Oracle PL / SQL Developer

Confidential Company  •  Pennington, NJ

5 - 7 years experience  •  Financial Services

Salary depends on experience
Posted on 08/07/17
Confidential Company
Pennington, NJ
5 - 7 years experience
Financial Services
Salary depends on experience
Posted on 08/07/17

Job Description:

  • In this role you will work directly with data architects, project managers and other developers to migrate an analytics application database from multiple databases to an integrated Oracle platform. 
  • Your in-depth experience with problem solving capabilities, solution design, PL SQL development and Linux shell scripting will be crucial to migrating/developing complex procedural SQL code to PL/SQL.
  • Minimum Educationrequirements:
  • Degree in Computer Science, MIS, or other related Engineering field

Responsibilities:

  • Learn the application specific subject matter behind the procedural code to be migrated
  • Formulate high-performing technical design/solution to solve for complex data models.
  • Hands on developer – migrating procedural SQL code from other DBMS to robust, high quality and performant PL/SQL code and Linux shell scripts.
  • Test and promote code from DEVELOPMENT through QA, UAT to PRODUCTION.
  • Create data to support, and maintain unit test cases, scenarios, and data.
  • Present innovative ideas for product improvements based on understanding of complex data models.

Required:

  • 5+ years experience in Oracle PL/SQL development.
  • Having Knowledge and Experience with Cloud.
  • 5+ yearsexperience developing Linux/Unix shell scripts
  • 5+ yearsexperience with data loading into Oracle databases
  • Must have experience implementing External tables for data loading
  • Experience with PL/SQL bulk read and write code
  • Must have experience with PL/SQL package driven development
  • Experience and knowledge in the performance design aspects of PL/SQL coding
  • Experience with complex SQL statements and performance aspects of SQL
  • Understanding of data modeling concepts
  • Excellent verbal and communications skills
  • Prior experience in defining coding standards and best practices for Oracle PL/SQL development
  • Minimum Oracle v11 experience. Knowledge/experience in 12c PL/SQL enhancements a plus
  • Ability to come up with technical design for loading based on a complex data model
  • Working experience in data mapping for data loading, bulk data loading and External tables
  • Ability to perform SQL tuning of queries, optimize reports and data retrieval response times
  • Strong in debugging and understanding  existing code for modifications
  • Strong analytical and problem solving skills and ability to work in a fast paced environment
  • Ability to think creatively and work independently on complex tasks
  • Must have strong work ethics and past accomplishments
  • Recent PL/SQL development experience
  • Must be able to pass technical interview with high ratings
Not the right job?
Join Ladders to find it.
With a free Ladders account, you can find the best jobs for you and be found by over 20,0000 recruiters.