Employment Spot

Job Description

As an employee of PNC Financial Services Group, you become part of an organization committed to customers, employees, investors, and the communities in which we do business. PNC is an established, growing and successful financial services company, with businesses organized around retail and commercial banking, asset management, and funds processing. Our branches are concentrated in thirteen states and the District of Columbia; additional offices are located nationwide and internationally. We are growing in size and through recent acquisitions have become the fifth largest bank by deposits in the US. We are also growing in reputation, as a leader in areas such as work/life family culture, "green" building design, frontier technology, and strong corporate social responsibility.

As an ETL Architect, you are a member of PNC's ETL Development organization. You will be based in Brook Park, OH.

The primary role of the ETL (Data Integration) Architect is to lead the strategy and implementation for the data integration solution, specifically in the area of ETL. The ETL architect must have the skills to recommend the ETL technical architecture design for load of an Enterprise Data Warehouse. The technical domain of the ETL Architect includes setting patterns for data extracts, data staging areas, Audit/Balance/Control functions, Error handling, data reconciliation (to G/L) processes, loads to foundation tables and reporting layers, and purge and archive processes.

Responsibilities may also include setting/enforcing Data Integration standards/best practices, Data Integration tools/technologies, security in the Data Integration environment, Data Integration architecture/design/development, capacity planning, performance tuning and administration, use of reusable objects, defining and estimating project proposals, collaboration with other architects to align Data Integration architecture to the business case and overall solution architecture, completion of Data Integration architecture documentation, design guidance to ensure conformity with architecture standards, oversight of QA functions for the Data Integration solution.

Required Skills:

Enterprise Data Warehouse project experience

ETL Application architecture design

ETL Development Skills

Data Warehouse testing strategies

Experience in all parts of System Development Life cycle

Good communication skills

Demonstrated planning and organization skills

Demonstrated leadership skills

Ability to work collaboratively in a team

Issue resolution skills

Additional desired Skills

Informatica Development skills

Experience with Oracle Databases

Unix Experience

Informatica Power Center

Informatica Power Exchange with Mainframe VSAM

Informatica Power Channel Data Modeling

Test Planning

PNC is committed to offering you a comprehensive and competitive benefits package. We design our full time and part time benefits programs based on PNC's benefits philosophy to provide quality levels of coverage at affordable costs over the long term for both employees and PNC. We strive to balance the cost of providing competitive benefits with the need to cover employees with a wide range of protection during and after employment.

Options you may be able to consider include:

Job Requirements