below marketmost similar roles pay hereabove market
This listing doesn't post a salary. Most similar roles pay
$169,550–$214,500.
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
172 open roles
on FindRole.
Listed pay typically runs
$91,000–$172,500
across 20 roles with salary data.
JOB TITLE: Software Engineer Principal-Informatica/Oracle/SQL
As a Software Engineer Principal within the Technology organization, you will serve as a Senior ETL Developer focused on data engineering and integration. You will translate complex business and technical requirements into reliable ETL solutions, managing the full lifecycle from requirements through implementation and production support. Your daily work involves troubleshooting data issues, performing source-to-target mapping, and ensuring data quality across large datasets. You will utilize Informatica, ANSI SQL, Oracle, and Microsoft SQL Server to build and maintain production systems. The role requires expertise in data modeling, database design, and relational concepts. You will also leverage skills in batch processing and data transformation, with the potential to use Tableau or Power BI for reporting and visualization within a structured SDLC environment.
What does a Software Engineer earn?
Median $196000 from 2524 postings across 143 companies.
Translate business and technical requirements into reliable data integration solutions.
Manage source-to-target data transformations for large and complex datasets.
Troubleshoot data-related issues across multiple systems and platforms.
Design and implement data models and database designs for Oracle and SQL Server.
Provide technical guidance and support to colleagues during solution development.
Oversee technical and procedural documentation for all software solutions.
What we're looking for
Must have a university or college degree or a comparable combination of education, certifications, and experience.
Must have 5+ years of hands-on Informatica experience, including development and support of production ETL solutions.
Must have 5+ years of hands-on ANSI SQL experience, including complex queries, joins, subqueries, aggregations, stored procedures, and performance optimization.
Must have strong experience working with Oracle and Microsoft SQL Server databases.
Must have a strong understanding of ETL concepts, data integration, data transformation, data quality, and data engineering principles.
Must have experience working with large datasets, complex source-to-target transformations, and troubleshooting data issues across multiple systems.
Must have experience working within structured SDLC and production implementation processes.
Experience with Tableau or Power BI for reporting and visualization is preferred (preferred).
Oracle SQL
Informatica PowerCenter
ETL
Linux
Unix
Oracle Database
SQL
Data Warehouse
Data Integration
Data Mining
Machine Learning
Big Data Management
Business Intelligence
Data Architecture
Data Validation
Data Lineage
Informatica power center
Oracle SQL
PL/SQL
ETL
UNIX Shell Scripting
CA7
Teradata
Alteryx
Microsoft Power BI
Tableau
Oracle BI
DevOps
Agile
Cloud Computing
Data Modeling
Software Design Patterns
System Development Life Cycle
HTTP Transformations
C#
Java
Python
Node.js
DevOps
Agile Methodology
Distributed Systems
Object-Oriented Programming (OOP)
Software Development Life Cycle (SDLC)
System Design
AI-assisted development
Inner Source
Microsoft Technologies
Data Structures
Application Design
Software Process Improvement (SPI)