Job ID :
Company :
Commonwealth of Pennsylvania
Location :
Type :
Duration :
6 Months
Status :
Openings :
Posted :
21 Sep 2012
Job Seekers, Please send resumes to

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).



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.



Experience leading a team of 4+ Developers.



Excellent oral and written communication.



Experience with Business Objects XI or similar BI tool.



DB2 and SQL Server experience.