Software Engineer Lead (ETL/Regulatory Risk & Compliance)

PNC

Confirmed live today High trust

Quick summary

Work type
On-site
Location
Pittsburgh, PASterling, VA
Employment
Full-time
Posted
20 days ago
Freshness
Confirmed live today

Market check

Salary context

How this pay compares to similar roles

Similar $191k
$126k $245k
below market most similar roles pay here above market

This listing doesn't post a salary. Most similar roles pay $167,192–$215,000.

Based on 240 similar postings.

Employer

About PNC

PNC is one of the largest diversified financial services institutions in the U.S., based in Pittsburgh, PA, it provides retail banking, corporate banking, and asset management.

PNC currently has 159 open roles on FindRole.

Listed pay typically runs $91,000–$179,200 across 22 roles with salary data.

Most-posted roles

View all roles at PNC

At a glance

TL;DR · Software Engineer Lead (ETL/Regulatory Risk & Compliance)

The Software Engineer Lead (ETL/Regulatory Risk & Compliance) joins the Finance Accounting Technology organization within the Regulatory Risk and Compliance Reporting team. This role involves leading the technical design, development, and deployment of data-intensive applications that support essential business and regulatory requirements. The successful candidate will propose software solutions, provide technical guidance to colleagues, and oversee procedural documentation. Key responsibilities include developing SCD mappings, performance tuning, and debugging code. Required technical skills include Informatica PowerCenter 9.6, Oracle SQL/PLSQL, UNIX shell scripting, and CA7 job scheduler. Preferred competencies include Alteryx, Teradata, and BI tools like Power BI or Tableau. The role focuses on solving complex data problems to ensure accurate regulatory submissions and compliance reporting within a banking environment.

What you'll do

  • Lead the technical design and development of software solutions to address complex business needs.
  • Develop and debug PL/SQL code and Informatica PowerCenter mappings for data-intensive applications.
  • Perform performance tuning of targets, sources, mappings, sessions, and workflows.
  • Design and implement SCD mappings and HTTP transformations using various source formats.
  • Manage ETL code deployments using DevOps tools and UNIX shell scripting.
  • Provide technical guidance, support, and code reviews to colleagues and solution development teams.
  • Oversee the creation of technical and procedural documentation for software projects.
  • Facilitate complex problem resolution and apply modern software development methodologies.

What we're looking for

  • 5+ years of development experience.
  • Bachelor's degree or a comparable combination of education, certifications, and experience.
  • Advanced design and programming skills in Informatica PowerCenter 9.6 and above and Oracle SQL/PLSQL.
  • Proficiency in developing and debugging PL/SQL code and designing SCD mappings with necessary transformations.
  • Experience with performance tuning of targets, sources, mappings, sessions, and workflows.
  • Hands-on knowledge of UNIX shell scripting, CA7 job scheduler, and handling ETL code deployments using DevOps tools.
  • Intermediate level skills in data analysis and data modeling.
  • Experience with Alteryx, BI tools (Power BI/Tableau/Oracle BI), Teradata, or software design patterns (preferred).

More like this

Similar roles

Software Engineer Lead (ETL)

PNC

Pittsburgh, PA +2 124 days ago
Informatica ETL Teradata Oracle Hadoop CA7 Java Spring Boot REST SOAP OBIEE Salesforce Siebel SAML Udeploy Artifactory GitHub Agile Data Warehousing
3+ yrs exp

Software Engineer Lead

PNC

Pittsburgh, PA +3 119 days ago
Application Development System Development Life Cycle Application Design Release Management Application Testing Technical Troubleshooting UX) Design Packaged Application Integration Application Delivery Process
3+ yrs exp

Software Engineer Lead

PNC

TX +1 11 days ago
Agile Methodology Cloud Computing DevOps Software Development System Design Technical Design Application Design Application Development Tools Application Testing System Development Life Cycle Requirements Analysis Code Reviews Debugging Technical Troubleshooting Packaged Application Integration
3+ yrs exp

Software Engineer Lead

PNC

Pittsburgh, PA +2 119 days ago
Java Spring Boot GraphQL Angular SQL NoSQL Oracle MySQL PostgreSQL MongoDB Kafka Dynatrace ELK CI/CD OpenShift Kubernetes OAuth 2.0 OIDC JUnit Karate Cypress Domain-Driven Design Agile Scrum
3+ yrs exp

Software Engineer Lead

PNC

Pittsburgh, PA 12 days ago
Application Development System Development Life Cycle Application Design Release Management Application Testing UX) Design Technical Troubleshooting Packaged Application Integration Application Delivery Process
3+ yrs exp