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