DBA Oracle Data Integrator ETL XML Advanced Entity Relationship Diagrams Developer<   Requirement id 10417 Job title Developer Job location in Raleigh, NC Skills required Oracle Database Developer, Database Designer, DBA, Oracle Data Integrator ETL XML Advanced Open Date 03-Jul-2012 Close Date Job type Contract Duration 12 Months Compensation DOE Status requirement --- Job interview type Face to Face interview Apply    Email Recruiter: coolsoft Job Description Developer: Oracle Database Developer, Database Designer, DBA, Oracle Data Integrator ETL XML Advanced [Note: Submission Deadline : 7/11/2012 5:00 PM] [Note: The resource will be required to work onsite] [Note : Phone interviews will be conducted if the candidate is not local] Description: The Client is seeking to fill a short term (approx. 12) month contractor Database Programmer/Developer position. The selected candidate will be assigned to teh IIS project. 1. Facilitate the interfaces between up to 30 source systems and the IIS, including writing interface extract files when source system support staff is not available. 2. Understand how data is mapped from source systems, through the Extraction Transform Load (ETL) process and into the IIS. 3. Build needed ETL process for importing data from source systems to IIS. 4. Help design and document interfaces and data mapping between IIS and the ODS (when it is available). 5. Understand and document how data maps from source systems to the various IIS reports and dashboards 6. Work with the OBIEE Dashboard developer to support dashboard development as needed. 7. Build database views or materialized views to support the IIS dashboards as needed. 8. Analyze database performance and work with the IIS vendor and ITS to design and implement database indexes and partitions to improve application and dashboard performance. 9. Tune SQL queries as needed. 10. Run custom IIS extracts and reports as required. 11. Design IIS Data Warehouse to serve IIS Dashboards and reports. 12. Using the SLI load file(s) specifications written by the Business Analysts, develop the data files that will be used to load the SLI data store. a.Where possible, leverage the DPI Agency files that DPI source systems are creating for submission to MFTS. This approach will reduce the need for writing custom extracts from each DPI source system. b.Transform data in accordance with the data transformation business rules to convert the data from the existing state to the state needed to support the EdFi standard and load into the SLI data repository. 13. Support the quality assurance testing being performed by the Business Analysts. Work with the Business Analysts to make modifications to the SLI load file(s) as required following the quality assurance testing activities. 14. Schedule the SLI load file generation and submission in accordance with the schedules defined in the SLI load file(s) specifications. Required Skills: * Minimum of eight (8) years of experience working with Oracle Database products (including Oracle 10g and 11g) as a database developer, database designer, or DBA. * MInimum of two (2) years of experience using Oracle Data Integrator (ODI) to do Extract, Transform, Load (ETL) activities. * Minimum of one (1) years of experience integrating XML schemas in ODI and generating output in XML against these schemas. * Must have excellent SQL skills. * Minimum of two (2) years of experience working with Operational Data Stores and Data warehouses. * Minimum of two (2) years of experience designing data bases using Entity Relationship Diagrams and tools such as ERWIN to document the database designs.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 10417 while calling.   Other jobs in NC: Chapel Hill (2), Charlotte (58), Dix Campus (1), Greensboro (3), Morrisville (2), North Charlotte (2), Raleigh (96), St Raleigh (2), Winston Salem (3),         (Developer: Oracle Database Developer, Database Designer, DBA, Oracle Data Integrator ETL XML Advanced in Raleigh, NC)

Featured Jobs COTS SASS Communication Analyst (Jobs in Henrico, Virginia) IBM Active Consultant (Jobs in Des Moines, Iowa) - - Engineer (Jobs in Austin, Texas) Consultant (Jobs in Richmond, Virginia) Business Analyst - Analyst (Jobs in Austin, Texas) ASP.Net IIS Developer (Jobs in Pontiac, Michigan) Data Architect SQL Architect (Jobs in Tallahassee, Florida) SQL Analyst (Jobs in Lansing, Michigan) CPM PMI Risk Manager (Jobs in Richmond, Virginia) FMS Manager (Jobs in Tallahassee, Florida)