Position Overview

At PNC, our people are our greatest differentiator and competitive advantage in the markets we serve. We are all united in delivering the best experience for our customers. We work together each day to foster an inclusive workplace culture where all of our employees feel respected, valued and have an opportunity to contribute to the company’s success. As a Software Architect within PNC's C/IB organization, you will be based in Pittsburgh PA.

PNC is an in-office company that fosters a supportive culture where employees can thrive and achieve balance. We encourage candidates to connect with their recruiter and hiring manager to understand workplace expectations and ensure the role aligns with their goals.

 

PNC will not provide sponsorship for employment visas or participate in STEM OPT for this position.

Job Description

Position Overview

We are seeking an experienced ETL / Informatica Architect to lead the design, development, and optimization of enterprise data integration solutions. This role partners closely with business analysts and technology teams to translate business requirements into scalable, efficient ETL workflows and data models that support analytics, reporting, and operational use cases across the organization.

Description

As an ETL / Informatica Architect at PNC, you will play a critical role in designing, developing, and optimizing enterprise data integration solutions. You will work closely with business analysts, data engineers, and application teams to translate business requirements into scalable, high‑performance ETL workflows and data movement architectures. This role requires strong analytical skills, deep experience with Informatica, and hands‑on expertise across multiple database platforms.

Primary Responsibilities

• Partner with business analysts and stakeholders to understand business requirements and translate them into technical ETL and data movement solutions
• Design, develop, and maintain Informatica workflows, mappings, sessions, and reusable components
• Analyze and enhance existing data movement patterns to improve performance, scalability, and reliability
• Develop, analyze, and optimize database tables, views, and schemas to support downstream analytics and reporting
• Ensure data accuracy, consistency, and integrity across systems
• Provide architectural guidance on ETL best practices, data standards, and performance tuning
• Support production deployments, troubleshooting, and root‑cause analysis for data-related issues
• Collaborate with cross‑functional teams to ensure solutions align with enterprise architecture and governance standards

Preferred Skills & Qualifications

• Proficiency with Informatica (version 10.5.9), including advanced workflow and mapping design
• Strong experience working with relational and analytical databases, including:
  • Oracle
  • Exadata
  • SQL Server
  • Teradata
• Advanced SQL development and performance tuning expertise
• Ability to analyze complex data flows and recommend architectural improvements

Nice to Have Skills

• Experience using Python for data processing, automation, or ETL enhancement
• Exposure to enterprise data warehousing or large-scale data integration environments
• Experience working within financial services or highly regulated industries
• Strong analytical and problem‑solving skills
• Ability to communicate complex technical concepts to both technical and non‑technical audiences
• Self‑starter with the ability to manage multiple priorities in a fast‑paced environment

PNC Employees take pride in our reputation and to continue building upon that we expect our employees to be:

• Customer Focused - Knowledgeable of the values and practices that align customer needs and satisfaction as primary considerations in all business decisions and able to leverage that information in creating customized customer solutions.
• Managing Risk - As