Lead Software Engineer – ETL, Regulatory Risk & Compliance

PNC

. Create and lead the technical design and development of software solutions .

Posted 10/10/2026full-timeUnited StatesSenior💰 $86,250 - $172,500 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates advanced design and programming skills in Informatica PowerCenter and Oracle SQL/PLSQL, with a strong focus on developing data-intensive applications and performance tuning. Proficient in ETL code deployments and familiar with data analysis, modeling, and regulatory reporting requirements.

Highest-signal resume keywords

Informatica PowerCenter 9.6+Oracle SQL/PLSQLETL Code DeploymentData AnalysisPerformance Tuning

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Software DesignData MappingSCD MappingsHTTP TransformationsUNIX Shell ScriptingData ModelingPerformance TuningDebugging PL/SQL CodeData-Intensive Application DevelopmentComplex Problem Resolution

Soft Skills

Written CommunicationVerbal CommunicationCollaborationTechnical Guidance

Tools & Technologies

DevOps ToolsCA7 Job SchedulerAlteryxMicrosoft Power BITableauOracle BITeradata

Industry Keywords

BankingRegulatory ReportingAgile MethodologyWaterfall Methodology

Tech Stack

Tools & technologies

ETLInformaticaOracleShell ScriptingSQLTableauUnix

About the role

Key responsibilities & impact

Create and lead the technical design and development of software solutions
Propose and design software solutions addressing complex business needs
Prepare required technical and procedural documentation
Facilitate complex problem resolution
Provide technical guidance and support to colleagues
Review software coding, testing, and documentation
Apply modern principles, methodologies, and tools to advance business initiatives and capabilities
Lead, collaborate on, design, and program data-related changes from consumption through reporting
Develop data-intensive applications supporting business and regulatory requirements
Develop SCD mappings using different source formats and transformations
Tune targets, sources, mappings, sessions, and workflows for performance
Handle ETL code deployments using DevOps tools

Requirements

What you’ll need

5+ years of development experience
Strong written and verbal communication skills
Formal experience working on projects using a methodology such as waterfall or agile
Advanced design and programming skills in Informatica PowerCenter 9.6 or above and Oracle SQL/PLSQL
Proficiency developing and debugging PL/SQL code
Ability to develop SCD mappings with different source formats using necessary transformations
Performance tuning of targets, sources, mappings, sessions, and workflows
Ability to design HTTP transformations
Experience handling ETL code deployments using DevOps tools
Hands-on knowledge of UNIX shell scripting and CA7 job scheduler
Intermediate-level skills in data analysis and data modeling
Bachelor's degree
In lieu of a degree, a comparable combination of education, job-specific certifications, and experience, including military service, may be considered
Banking and regulatory reporting experience is a plus
Experience with Alteryx is preferred
Experience with Microsoft Power BI, Tableau, or Oracle BI is preferred
Hands-on knowledge using Teradata is preferred
Working knowledge of software design patterns and architecture is preferred
No required certifications
No required licenses
PNC will not provide sponsorship for employment visas or participate in STEM OPT

Benefits

Comp & perks

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 plan
Stock purchase plan
Dependent care reimbursement account
Back-up child/elder care
Adoption, surrogacy, and doula reimbursement
Educational assistance, including select programs fully paid
Robust wellness program with financial incentives
Maternity and/or parental leave
Up to 11 paid holidays each year
9 occasional absence days each year
15 to 25 vacation days each year, depending on career level