> > *Oracle Developer - **Direct Client* > * Immediate Interview and Start ASAP!!!* > > *Please send resume to * > *s...@cncconsulting.com <s...@cncconsulting.com>*Job Title: Oracle Developer > Location: St. Paul, MN > Duration: 6 Months > Direct Client Position > Client: State of MN > > *Note: Need 3 references* > Project Deliverables: > ? Review functional requirements. > ? Modify/Upgrade the METS Integration Layer Data Prep Job which includes: > o Trace the data processing flow from source to target system, identifying > places for performance improvement; > o Restructure existing code to improve processing performance and > traceability; > o Refactor hardcoded reference data into code tables to improve > maintainability; > o Redesign the XML processing performed by the process flow to more > efficiently utilize source XML data; > o Convert internal process flow stages to leverage the event subsystem; > o Ensure all changes, code, DDL, and data models are properly and > completely documented; and > o 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: > o Identify matches, prospective matches, etc.; > o Remove duplicates; > o Report non-matched/problem cases for evaluation; and > o 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: > 1. B.S. or B.A. degree (4 year) > OR > Associate’s degree (2 year) with 5 years’ experience in PL/SQL > Programming/Development. > 2. 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: > 1. Computer Science or Information Technology degree > 2. Experience in all aspects of the Software Development Life Cycle (SDLC) > > *3. Hands on experience working on health insurance programs.*4. > Experience in PL/SQL related to enrollment systems > 5. 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 > 6. *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 > 7. 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 > 8. > *Experience utilizing migration and version control systems.*9. > Experience with secure coding principals such as OWASP Top 10, SANS Top 25. > 10. Experience with IRS Pub 1075 and NIST 800-53 rev4. > > > * Please send resume to s...@cncconsulting.com <s...@cncconsulting.com> * > > *Thanks,* > * Sam * > * CNC Consulting, Inc.* > * 201-546-3096* > *s...@cncconsulting.com <s...@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.