> > *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 "SAP ABAP" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-abap+unsubscr...@googlegroups.com. To post to this group, send email to sap-abap@googlegroups.com. Visit this group at https://groups.google.com/group/sap-abap. For more options, visit https://groups.google.com/d/optout.
