Need OBIEE Database developer @ NC

Contractor: Oracle database developer

Location: Raleigh, NC

Duration: 12 months

Start date: 1^st July 2012

 

DUTIES - EXPERIENCE REQUIRED

· Understanding of how data is mapped from source systems, through the Extraction Transform Load (ETL) process and into the IIS

· Understand and document how data maps from source systems to the various IIS reports and dashboards

· Work with the IIS vendor and ITS to design and implement database indexes and partitions to improve application and dashboard performance

· Work with the OBIEE Dashboard developer to support dashboard development

· Work with the Business Analysts to make modifications to the SLI load file(s) as required following the quality assurance testing activities

· Facilitating interfaces between up to 30 source systems and the IIS

· Writing interface extract files

· Building ETL process for importing data from source systems

· Design and document interfaces and data mapping between IIS and the ODS

· Build database views or materialized views to support the IIS dashboards

· Analyze database performance

· Tune SQL queries as needed

· Run custom IIS extracts and reports

· Design IIS Data Warehouse to serve IIS Dashboards and reports

· Develop data files that will be used to load the SLI data store

· Leverage the DPI Agency files that DPI source systems are creating for submission to MFTS

· 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

· Support quality assurance testing

· Schedule the SLI load file generation and submission in accordance with the schedules defined in the SLI load file(s) specifications

 

ADDITIONAL SKILLS REQUIRED

· Minimum of three (3) years experience as a Data Base Programmer/Developer with skills / experience as detailed above.

· Bachelor's degree with (9) nine semester hours in programming and (4) four years Experience

· Motivated self-starter – independent person requiring minimum supervision

· Positive attitude – works well with other team members

· Excellent communication skills (both written and oral)

 

 

Thank you very much.

Harry Arora

International Projects Consultancy Services, Inc. (IPCS) ...Delivering Business Value from Information Technology...
Interchange Tower, Suite 1595, 600 South Highway 169, Minneapolis, MN 55426
Tel: 925-353-3884
Fax: 952-541-1222
Harry@ipcs.net
www.ipcs.net
· Our Specialization: SOA I Microsoft .NET Technologies I Data Warehouse & Business Intelligence I Network Security I ERP & SAP Implementation
· Technologies: Business Process Rules Management (BPRM) driven Next Generation, Smart and Innovative Service Delivery Platforms
· IPCS is SBA 8(a) Certified /WBE/MBE/DBE/SDB Company
· IPCS is Certified Minority Company by Midwest Minority Supplier Diversity Council -MMSDC
· IPCS is on Federal GWAC 8a STARS -2 Contract

 

 

You are currently subscribed to arora as: shekhar.altus.jobs@blogger.com Add harry@ipcs.net to your email address book to ensure delivery Forward to a Friend  |  Manage Subscription  |   Subscribe  |   Unsubscribe