Oracle Developer with Data Warehousing, ETL, OBIEE, SQL, SLI, IIS, DBA, ODI, XML, Operational Data Stores, ER/ERWIN and government experience

IN001612 

Oracle Developer with Data Warehousing, ETL, OBIEE, SQL, SLI, IIS, DBA, ODI, XML, Operational Data Stores, ER/ERWIN and government experience

Location: Raleigh, NC

Duration: 12 months

Positions: 1

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.

Knowledge, Skills, and Abilities Requirements:

Required Skills & Experience •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.

Posted via email from innoSoul's posterous