PNC's Finance Accounting Tech team in Pittsburgh or Cleveland seeks an experienced ETL Developer to design and maintain complex data integration workflows using Informatica and Oracle SQL/PLSQL. The role involves developing Unix shell scripts for automation, managing batch jobs with CA7 or similar tools, and collaborating with cross-functional teams to ensure data accuracy and performance. Day-to-day tasks include optimizing SQL queries, troubleshooting issues, supporting production deployments, and participating in documentation efforts. Ideal candidates have 4+ years of ETL development experience, strong Informatica skills, proficiency in Oracle SQL/PLSQL, and familiarity with job scheduling tools. Knowledge of mainframe environments, Teradata, and data warehousing concepts is preferred, while exposure to modern technologies like Spring Boot and OpenShift is beneficial for future projects aimed at transitioning away from legacy systems.
Design, develop, and maintain ETL workflows using Informatica.
Develop and optimize complex SQL queries, stored procedures, and packages in Oracle PL/SQL.
Create and manage Unix shell scripts for automation and batch processing tasks.
Monitor and troubleshoot batch jobs using CA7 or similar scheduling tools.
Ensure data accuracy and integrity across enterprise systems during production deployments.
What we're looking for
4+ years of ETL development or data engineering experience
Expertise in Informatica ETL tools and Oracle SQL/PLSQL
Proficiency in Unix/Linux shell scripting for automation
Knowledge of job scheduling tools like CA7, Autosys, or Control-M
Strong troubleshooting skills and analytical abilities
Market check
Salary context
This listing doesn't show a salary. Similar roles on FindRole typically pay
$117,000–$198,000.
Peer median band
$117,000–$198,000
Median floor and ceiling across peers.
Typical midpoint (25–75%)
$126,800–$184,900
Middle half of comparable postings.
Based on 240 comparable postings.*
* 240 is the maximum number of comparable postings sampled.
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
180 open roles
on FindRole.
Listed pay typically runs
$74,750–$171,925
across 62 roles with salary data.
Remote (Usa-San Jose, US)108 days ago
$165,000–$277,600
SONiC-NOS
Wireshark
Python
C++
Linux
GDB
IXIA
Spirent
High Speed Serdes
MAC ports
PRBS
ANLT analyzers
L2 switching
networking protocols
Cisco Silicon One