Previous Job
Previous
PL/SQL Developer
Ref No.: 18-00679
Location: Glen Allen, Virginia
Here is the Job Description
Title: PL/SQL Developer
Location: Glen Allen, VA
Duration: 6+ Months

Summary:
This position will analyze problems and is an expert in at least two or more Data Management tools. Role will understand and develop requirements for a system (mapping documents) by working with Business and Stakeholders, including visualization. Focus on the design with emphasis on reusability, scalability, optimization and parameterization. Develop, test and maintain canonical layouts and drives standardization. Is proficient at automated testing strategies, including TDD. Integrate systems to enterprise data governance tools. Perform data and service integration. Design data as a service (DaaS). Contribute to 24x7x365 days of on-call staff coverage.

Essential Functions:
-Develops, test and maintains code using software development methodology and appropriate technologies for the system being used.
-Works closely with Business Analysts to develop detail systems design and written test plans for online and report application programs.
-Performs analysis on projects and provides a project plan that shows the tasks needing to be completed and a time estimate for each task.
-Participates in design walkthroughs with appropriate focus groups and related users to verify accuracy of design in meeting business needs.
-Prepares installation instructions and coordinates installation procedures.
-Supports and troubleshoots application code problems.
-Provides status reports that give a detailed description of the current projects progress and indicates time devoted to each task of the project.
-Coordinates, guides and mentors programming efforts performed by in-house programmers or outside consultants to ensure that all programming is completed according to the project plan.


Job Description
o Analyze problems and is an expert in at least two or more Data Management tools.
o Develop, test and maintain canonical layouts and drives standardization.
o Is proficient at automated testing strategies, including TDD.
o Integrate systems to enterprise data governance tools.
o Perform data and service integration.
o Design data as a service (DaaS).
o Contribute to 24x7x365 days of on-call staff coverage.
o 7+ years of programming experience including a minimum Strong working knowledge of modern programming languages, ETL tools
o Senior Oracle PL/SQL and Informatica Developer

Requirements/Certifications:6 month Right to Hire
o Requirements: Strong PL/SQL skills. Development of database packages and other stored PL/SQL objects to handle very large data volumes.
o Understanding of ER modeling and pulling data from multiple systems.
o 5+ years experience in Oracle PL/SQL development
o 5+ years experience developing Linux/Unix shell scripts
o 5+ years experience with data loading into Oracle databases
o Experience with PL/SQL bulk read and write code
o Experience and knowledge in the performance design aspects of PL/SQL coding
o Understanding of data modeling concepts
o Minimum Oracle v11 experience.
o Knowledge/experience in 12c PL/SQL enhancements a plus
o Ability to come up with technical design for loading based on a complex data model
o Working experience in data mapping for data loading, bulk data loading and External tables
o Ability to perform SQL tuning of queries optimize reports and data retrieval response times
o PL/SQL, Oracle, ETL, Informatica, Stored procedures, functions, triggers, Views, UNIX, Shell Scripts

Key Skills:

· Interfaces area, data loads
· Strong documentation skills
· Willing and able to learn
· Able to work independently
· Pairing experience – when developers work in pairs or triads to help with coaching others
· Healthcare industry and pharmacy claim processing is a "plus”.