I have a very urgent DIRECT CLIENT requirement for *Oracle Developer* in *St. Paul, MN*. Please Let Me Know If you have available candidate, please reply with their word resume, location, rate and contact number.
Please send the resumes at pe...@cncconsulting.com Job Title: Oracle Developer Location: St. Paul, MN Duration: 6 Months *The more exp the candidate has with the desirables, the better. Only able to submit 1 candidate* Project Deliverables: Review functional requirements. Modify/Upgrade the METS Integration Layer Data Prep Job which includes: Trace the data processing flow from source to target system, identifying places for performance improvement; Restructure existing code to improve processing performance and traceability; Refactor hardcoded reference data into code tables to improve maintainability; Redesign the XML processing performed by the process flow to more efficiently utilize source XML data; Convert internal process flow stages to leverage the event subsystem; Ensure all changes, code, DDL, and data models are properly and completely documented; and Design and implement a more robust error logging subsystem to enable faster process flow tracking and reporting. Design PL/SQL solutions to implement a data cleansing/reconciliation process, which will: Identify matches, prospective matches, etc.; Remove duplicates; Report non-matched/problem cases for evaluation; and Support re-incorporation of externally modified/marked up data. Prepare solutions to load “final/cleansed” data into the primary set of tables. Implement PL/SQL solutions to support/replace/update processes on the Integration Layer and enrollment tables. Implement PL/SQL solutions to support efficient common queries of enrollment data. Implement PL/SQL solutions to support regular exports of selected enrollment data for use in downstream systems (reporting, etc.). Write PL/SQL code and documentation to support the “reconcile” functionality. Write PL/SQL code and documentation to support updated logic and related functionality. Document and unit test all code. Provide knowledge transfer to staff on solution implemented. Mandatory Qualifications: B.S. or B.A. degree (4 year) OR Associate’s degree (2 year) with 5 years’ experience in PL/SQL Programming/Development. A minimum of seven (7) years of experience in designing, developing, and testing applications utilizing PL/SQL or Oracle (10g, 11g, or 12g). Desired Skills: Computer Science or Information Technology degree Experience in all aspects of the Software Development Life Cycle (SDLC) Hands on experience working on health insurance programs. Experience in PL/SQL related to enrollment systems Experience working with the following: Data Architecture, Data Analysis, Data Modeling Enterprise Data Warehousing Oracle Database Administration Account Creation, password reset Role management Oracle Audit Vault Oracle Data Vault Oracle Database Firewall Advanced SQL and Oracle PL/SQL Development and experience with functions, procedures, packages and triggers, such as: Oracle Job Scheduler Oracle performance tuning, including: Query tuning Index tuning Partitioning Experience with Oracle Fine Grain Access Control (FGAC) development, configuration, and troubleshooting, which includes the following: Forensic data analysis/troubleshooting Oracle 11g Hadoop Subversion Toad JIRA Confluence Experience utilizing migration and version control systems. Experience with secure coding principals such as OWASP Top 10, SANS Top 25. Experience with IRS Pub 1075 and NIST 800-53 rev4. Thanks Peter Smith Direct: 201-546-3164 Email ID: pe...@cncconsulting.com -- You received this message because you are subscribed to the Google Groups "oraapps" group. To unsubscribe from this group and stop receiving emails from it, send an email to oraapps+unsubscr...@googlegroups.com. To post to this group, send email to oraapps@googlegroups.com. Visit this group at https://groups.google.com/group/oraapps. For more options, visit https://groups.google.com/d/optout.