Software Engineer Lead (ETL)

PNC Bank•Pittsburgh, PA

1d•Onsite

About The Position

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 Engineer Lead (ETL) within PNC's Retail Tech Core Debit Product organization, you will be based in Pittsburgh PA, Strongsville OH or Dallas TX. We are looking for a Software Engineer Lead (ETL) who is responsible for aligning business strategy with scalable technology solutions, primarily within Investments. Designs and implements complex data integrations, ETL pipelines, and data warehousing solutions using platforms such as Teradata, Oracle, Hadoop, and mainframe scheduling tools (CA7). Leads end-to-end solution delivery including architecture design, API development (REST/SOAP), and system integrations across internal and external applications, while ensuring data quality, governance, and compliance. Collaborates cross-functionally with business and technical stakeholders to translate requirements into high-performance data solutions, provides technical leadership, and drives best practices through code reviews and mentorship. Supports reporting (OBIEE), CRM integrations (Salesforce, Siebel), SSO (SAML), and disaster recovery efforts, leveraging Agile and traditional methodologies to deliver reliable, high-quality outcomes.

Requirements

Informatica ETL development and design.
Leading complex Data Warehouse applications.
CA7 Orchestration
Data Warehouse experience, and working with large amounts of data
Teradata, Oracle, Hadoop
Experience solutioning new data integrations
Experience with code deployment tools such as Udeploy, Artifactory and GitHub.
Java/ Spring Boot knowledge

Nice To Haves

Application Development
Business Management
Customer Solutions
Design
Group Problem Solving
Process Improvements
Release Management
Software Solutions
User Experience (UX) Design

Responsibilities

Creates and leads the technical design and development of software solutions.
Proposes & designs software solutions to address complex business needs.
Prepares technical and procedural documentation required.
Facilitates complex problem resolution.
Provides technical guidance and support to colleagues.
Reviews coding, testing, and documentation of software.
Applies modern principles, methodologies and tools to advance business initiatives and capabilities.

Benefits

medical/prescription drug coverage (with a Health Savings Account feature)
dental and vision options
employee and spouse/child life insurance
short and long-term disability protection
401(k) with PNC match
pension and stock purchase plans
dependent care reimbursement account
back-up child/elder care
adoption, surrogacy, and doula reimbursement
educational assistance, including select programs fully paid
a robust wellness program with financial incentives
maternity and/or parental leave
up to 11 paid holidays each year
9 occasional absence days each year, unless otherwise required by law
between 15 to 25 vacation days each year, depending on career level; and years of service.