Job ID :
4368
Company :
Virginia Information Technology Agency
Location :
RICHMOND, VA
Type :
Contract
Duration :
6 Months
Status :
Active
Openings :
1
Posted :
16 Dec 2013
Job Seekers, Please send resumes to resumes@hireitpeople.com

Complete Description:

***NEW CANDIDATES REQUESTED - MUST HAVE STRONG OBIEE AND OWB EXPERIENCE

***Strong possibility that this agency may create a permenant opening in approximately 6 months that this contractor could apply to***

* Local Candidates PREFERRED

** Candidates MUST be eligible for direct hire by the agency, without sponsorship. No exceptions

*** In Person Interviews Only - No exceptions

 

SENIOR DATA WAREHOUSE AND BUSINESS INTELLEGENCE DEVELOPER

 

Responsibilities:

•          Creating dimensional (star/snowflake schema) data models,

•          Maintaining responsibility for global data definitions used in the Data Warehouse

•          Performing ETLs and validating results with business representatives,

•          Integrate data from multiple source systems into Data Warehouse

•          Cleansing data,

•          Transforming and loading data in Oracle 11G environment.

•          Building ROLAP/MOLAP solutions

•          Adhering to standards for the Data Warehouse, including security, archiving, backup and recovery

•          Participating in architectural decisions for data transitions from source to staging to ODS to EDW

•          Supporting implemented BI solutions by: monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues.

 

Knowledge/Skills Required:

•          Experience with Unix /Linux platform and SQL, PL/SQL programming (Data Staging running on Linux platform)

•          Experience with Unix scripting preferred (Korn shell, chron tab scheduler)

•          Extensive experience in complete life cycle of DW projects and able to provide end to end solutions

•          Able to work closely with supporting teams to develop integrated solutions (Legacy Systems, Web Methods, FTP, DBA’s, etc)

•          Experience and understanding with Data Modeling (powerdesigner/ERWIN tool preferred) and Dimensional Modeling

•          Experience with Data Warehouse ROLAP/MOLAP and reporting technologies ( Business Objects, OBIEE, Crystal)

•          Working knowledge of Kimball framework and Methodologies

•          Familiarity with unstructured data warehousing

 

Preferred Qualifications:

•          5+ years of experience in a Decision Support/Data Warehousing/Business Intelligence environment

•          College degree or higher ( Bachelors Degree in Computer Science, Engineering or a related technical discipline, or the equivalent combination of education and technical training)

•          Familiarity with Agile Software development

•          Working knowledge of OBIEE  and/or SAP BO

•          Working knowledge of OWB

 

Skills:

Skill

Required / Desired

Amount

of Experience

 

Experience with Unix /Linux platform

Required

5

Years

Experience with SQL, PL/SQL programming (Data Staging running on Linux platform)

Required

5

Years

Experience with Unix scripting preferred (Korn shell, chron tab scheduler)

Required

5

Years

Extensive experience in complete life cycle of Data Warehousing projects providing end to end solutions

Required

5

Years

Experience working closely with supporting teams to develop integrated solutions for Legacy Systems, Web Methods, FTP, etc.

Required

5

Years

Experience and understanding with Data Modeling (Power Designer/ERWIN tool preferred)

Required

5

Years

Experience with Dimensional Modeling with Data Warehouse ROLAP/MOLAP and reporting technologies ( Business Objects, OBIEE, Crystal)

Required

5

Years

Working knowledge of Kimball framework and Methodologies

Required

5

Years

Experience in a Decision Support/Data Warehousing/Business Intelligence environment

Required

5

Years

Familiarity with Agile Software development

Highly desired

2

Years

Strong Experience with OBIEE and/or SAP BO

Required

5

Years

Working knowledge of OWB

Required

5

Years

 

 Please list similar projects on which the candidate has worked.