Job ID :
1634
Company :
Commonwealth of Pennsylvania
Location :
harrisburg, PA
Type :
Contract
Duration :
6 Months
Status :
Active
Openings :
1
Posted :
6 years ago
Job Seekers, Please send resumes to resumes@hireitpeople.com or Call: (202) 719-0200 Ext: 127

Short Description:

Senior Architect responsible for designing, developing, and implementing application infrastructure to provide highly-complex, reliable, and scalable applications and systems to meet the organization's objectives and requirements.

 

Complete Description:

Position Description:  The position serves as a senior Oracle and Informatica architect for DW/BI solutions within the Bureau of Business Solutions & Services.  The candidate will lead and provide architecture support for DW/BI projects and initiatives related to the expansion of the enterprise data warehouse and development of new BI applications.  Responsibilities will include Informatica architecture support, leading the Informatica ETL development and troubleshooting, dimensional modeling, pl/sql development, Oracle performance tuning, and support for BI developers among other duties.  Technologies leveraged include Oracle 10g/11g, PL/SQL, Informatica PowerCenter 9.5 and Business Objects XI. 

 

Specific Duties:

 

1.Lead the full SDLC for DW/BI projects and initiatives, including business analysis, project leadership as well as technical design and development leadership.

2.Provide Informatica Architecture and Troubleshooting support

3.Perform data architecture duties, including leading OLAP and OLTP modeling efforts.

4.Lead Oracle and Informatica ETL development efforts.

5.Hands-on DW development required, not only lead/architect duties.

6.Perform intensive data analysis on source system databases.  Analyze and understand source system database, find required data, and profile the data.

7.Oracle Performance tuning and troubleshooting

8.Support BI development with Business Objects XI suite (including Crystal reports, WebI, Xcelsius).

 

Skills:

Overall Database experience.

Required 10 Years

 

Data Warehousing experience (with at least 3 years as Architect or Lead).

Required 5 Years

 

Oracle 9i,10g,11g experience (SQL, PL/SQL, Tuning, DDL, etc.).

Required 7 Years

 

Data Modeling experience.

Required 7 Years

 

Dimensional Modeling experience

Required 3 Years

 

Informatica Powercenter 8.x,9.x experience.

Required 3 Years

 

Data Warehouse Architect level experience.

Required

 

Experience leading a team of 4+ Developers.

Required

 

Excellent oral and written communication.

Required

 

Experience with Business Objects XI or similar BI tool.

Desired

 

DB2 and SQL Server experience.

Desired