*Oracle Developer - **Direct Client* * Immediate Interview and Start ASAP!!!*
*Please send resume to * *[email protected] <[email protected]>*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 [email protected] <[email protected]> * *Thanks,* *Sam * *CNC Consulting, Inc.* *201-546-3096* *[email protected] <[email protected]>* -- You received this message because you are subscribed to the Google Groups "SAP BASIS" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/sap-basis. For more options, visit https://groups.google.com/d/optout.
