Software Engineer Principal (Oracle/ ETL/ Data Warehousing)

PNC

Quick summary

Work type
On-site
Location
PA · AL
Posted
39 days ago

Market check

Salary context

How this pay compares to similar roles

Similar $194k
$136k most similar roles pay here $245k

This listing doesn't post a salary. Most similar roles pay $165,000–$223,750.

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 150 open roles on FindRole.

Listed pay typically runs $86,250–$185,900 across 57 roles with salary data.

Most-posted roles

View all roles at PNC

At a glance

TL;DR · Software Engineer Principal (Oracle/ ETL/ Data Warehousing)

As a Principal Software Engineer in PNC's Wealth Management team, you will design and implement complex software solutions using ETL and Big Data technologies to address intricate business needs. Your day-to-day responsibilities include building scalable data pipelines, creating sophisticated SQL queries for data analysis, and maintaining mainframe job schedules. You will collaborate closely with Business Analysts and other stakeholders to deliver robust data warehousing solutions while ensuring high availability and performance. Key skills required are Informatica ETL development, CA7 orchestration, experience with Teradata, Oracle, and Hadoop, as well as knowledge of code deployment tools like Udeploy and GitHub. This role involves leading complex problem-solving initiatives, providing technical guidance, and aligning technology deliverables with business priorities in a large-scale enterprise environment.

What you'll do

  • Design and maintain scalable data pipelines using ETL and Big Data technologies.
  • Develop complex SQL and PL/SQL queries for data mining and analysis.
  • Lead the creation of technical documentation and application architecture diagrams.
  • Optimize Data Warehousing solutions to ensure high performance and availability.
  • Build integrations between internal and external applications using REST & SOAP APIs.

What we're looking for

  • Extensive experience in Informatica ETL development and design.
  • Proficient in leading complex Data Warehouse applications and managing large datasets.
  • Expertise in Teradata, Oracle, Hadoop, and CA7 Orchestration.
  • Strong background in designing and implementing new data integrations and code deployments.
  • Knowledge of Java/Spring Boot and experience with deployment tools like Udeploy, Artifactory, GitHub.
  • Ability to create complex SQL/PLSQL queries for Data Mining/Data Analysis using TOAD, SQL developer, Teradata Studio, Hive.
  • Experience in technical documentation, API design, and application architecture diagram creation.

More like this

Similar roles

Software Engineer - ETL, Informatica

PNC

Two Pnc Plaza 20 days ago
Informatica Oracle SQL PLSQL Unix CA7 Teradata Spring Boot OpenShift Angular CI/CD JCL ETL Release Management Scheduling Tools

Software Engineer Principal

PNC

Pittsburgh, PA 70 days ago
Angular Java Spring Boot Informatica PowerCenter Oracle Git CI/CD RESTful APIs TypeScript HTML CSS SQL DevOps Jira Layered architecture API integration Data flows Batch processing