Principal ETL Engineer: Informatica, Oracle & SQL

PNC

Pittsburgh (Allegheny County)

On-site

USD 110,000 - 145,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Medical coverage (Health/Dental/Vision
401(k) with PNC match
Paid holidays / vacation

Job summary

PNC is seeking a Software Engineer Principal to join its Technology organization in Pittsburgh, PA. Weekly time in the office is required, and the role focuses on advancing data integration and data engineering initiatives within a collaborative, inclusive environment.

The position emphasizes hands-on ETL development with Informatica, ANSI SQL, Oracle and SQL Server, along with optional experience in Tableau or Power BI for reporting and analytics.

Qualifications

  • 5+ years of hands-on Informatica experience, including development and support of production ETL solutions.
  • 5+ years of hands-on ANSI SQL experience, including complex queries, joins, subqueries, aggregations, stored procedures, and SQL performance optimization.
  • Strong experience working with Oracle databases.
  • Strong experience working with Microsoft SQL Server.
  • Strong understanding of ETL concepts, data integration, data transformation, data quality, and data engineering principles.
  • Experience working with large datasets and complex source-to-target data transformations.
  • Experience analyzing and troubleshooting data-related issues across multiple systems.
  • Understanding of relational database concepts, data modeling, and database design principles.
  • Experience working within structured SDLC and production implementation processes.

Responsibilities

  • Aligns business strategy with software solutions.
  • Proposes, designs & codes software solutions to address complex business needs. Oversees technical and procedural documentation required.
  • Leads complex problem solving.
  • Provides technical guidance and support to colleagues and solution development.
  • Displays an innovative approach to apply modern principles, methodologies and tools to advance business initiatives and capabilities.

Skills

Informatica
ANSI SQL
Oracle
SQL Server
ETL concepts

Education

Bachelors

Tools

Tableau
Power BI

Job description

PNC is seeking a Software Engineer Principal to join its Technology organization in Pittsburgh, PA. Weekly time in the office is required, and the role focuses on advancing data integration and data engineering initiatives within a collaborative, inclusive environment.

The position emphasizes hands-on ETL development with Informatica, ANSI SQL, Oracle and SQL Server, along with optional experience in Tableau or Power BI for reporting and analytics.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Principal ETL & Data Engineer - Oracle/SQL
Principal ETL & Data Engineer - Oracle/SQL

PNC • Pittsburgh

On-site
USD 120,000 - 150,000
Health benefits
401(k) plan
Paid time off
Principal Data Engineer - Informatica, Oracle & SQL ETL
Principal Data Engineer - Informatica, Oracle & SQL ETL

PNC • United States

On-site
USD 110,000 - 170,000
Medical and prescription drug coverage
Dental and vision options
Life insurance
Principal ETL Engineer: Informatica, Oracle & SQL
Principal ETL Engineer: Informatica, Oracle & SQL

Pittsburgh Tomorrow • Pittsburgh

On-site
USD 110,000 - 160,000
Medical coverage (health) benefits
401(k) with company match
Paid time off
Software Engineer Principal-Informatica/Oracle/SQL
Software Engineer Principal-Informatica/Oracle/SQL

PNC Bank NA • United States

On-site
USD 110,000 - 170,000
Medical and prescription drug coverage
Dental and vision options
Life insurance
Software Engineer Principal-Informatica/Oracle/SQL
Software Engineer Principal-Informatica/Oracle/SQL

Life in Pittsburgh • Pittsburgh

On-site
USD 110,000 - 160,000
Medical coverage (health) benefits
401(k) with company match
Paid time off
Software Engineer Principal-Informatica/Oracle/SQL
Software Engineer Principal-Informatica/Oracle/SQL

PNC • Pittsburgh

On-site
USD 110,000 - 145,000
Medical coverage (Health/Dental/Vision
401(k) with PNC match
Paid holidays / vacation
Senior Infrastructure Engineer - ETL & Linux
Senior Infrastructure Engineer - ETL & Linux

PNC • Pittsburgh

On-site
USD 91,000 - 203,000
Senior Infrastructure Engineer - ETL & Linux
Senior Infrastructure Engineer - ETL & Linux

PNC • Pennsylvania

On-site
USD 91,000 - 203,000
Medical/dental/vision coverage
401(k) with company match
Pension and stock purchase plans
Software Engineer Principal-Oracle/SQL
Software Engineer Principal-Oracle/SQL

PNC • Pittsburgh

On-site
USD 120,000 - 150,000
Health benefits
401(k) plan
Paid time off
Senior Software Engineer: Automation & Database Platform
Senior Software Engineer: Automation & Database Platform

PNC • Pittsburgh

On-site
USD 120,000 - 180,000