Principal ETL & Data Engineer - Oracle/SQL

PNC

Pittsburgh (Allegheny County)

On-site

USD 120,000 - 150,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

Health benefits
401(k) plan
Paid time off

Job summary

PNC in Pittsburgh, PA is seeking a Software Engineer Principal to lead data integration initiatives as a Senior ETL Developer. The role requires 5+ years of Informatica development, strong ANSI SQL skills, and Oracle/SQL Server experience.

You will translate complex data requirements into reliable ETL solutions and troubleshoot production data issues with a focus on SDLC discipline. Experience with Tableau or Power BI is a plus.

Qualifications

  • 5+ years of Informatica development and support of production ETL solutions.
  • 5+ years of ANSI SQL experience including complex queries and optimization.
  • Strong Oracle experience and Microsoft SQL Server experience.
  • Solid understanding of ETL, data integration, data quality and data engineering.

Responsibilities

  • Aligns business strategy with software solutions and leads design.
  • Proposes, designs and codes software to meet complex needs; documents accordingly.
  • Leads complex problem solving and guides teammates.
  • Provides technical guidance and support to colleagues and solution development.
  • Applies modern principles, methodologies and tools to advance initiatives.

Skills

Informatica
ANSI SQL
Oracle
SQL Server
ETL concepts
Data integration
Data transformation
Data quality
Data engineering
Troubleshooting data issues
SDLC
Relational databases

Education

Bachelor's degree

Tools

Tableau/Power BI

Job description

PNC in Pittsburgh, PA is seeking a Software Engineer Principal to lead data integration initiatives as a Senior ETL Developer. The role requires 5+ years of Informatica development, strong ANSI SQL skills, and Oracle/SQL Server experience.

You will translate complex data requirements into reliable ETL solutions and troubleshoot production data issues with a focus on SDLC discipline. Experience with Tableau or Power BI is a plus.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

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

PNC • Pittsburgh

On-site
USD 110,000 - 145,000
Medical coverage (Health/Dental/Vision
401(k) with PNC match
Paid holidays / vacation
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
Pittsburgh Data Engineer: ETL & Data Warehouse Specialist
Pittsburgh Data Engineer: ETL & Data Warehouse Specialist

Key People • Pittsburgh

On-site
USD 110,000 - 140,000
Senior Infrastructure Engineer - ETL & Linux
Senior Infrastructure Engineer - ETL & Linux

PNC • Pittsburgh

On-site
USD 91,000 - 203,000
Data Engineer - ETL/Warehouse Architect (On-Site Pittsburgh)
Data Engineer - ETL/Warehouse Architect (On-Site Pittsburgh)

Essenti Talent • Pittsburgh

On-site
USD 120,000 - 160,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
Data Engineer: ETL/SQL + Oracle | On-Site in Pittsburgh
Data Engineer: ETL/SQL + Oracle | On-Site in Pittsburgh

Rare Bird Recruiting, LLC • Pittsburgh

Hybrid
USD 110,000 - 160,000
Industrial Data Engineer - ETL & Data Warehouse
Industrial Data Engineer - ETL & Data Warehouse

Henderson Group Recruiting • Pittsburgh

On-site
USD 110,000 - 160,000
Data Engineer - On-Site Pittsburgh | ETL/ELT & DW
Data Engineer - On-Site Pittsburgh | ETL/ELT & DW

Top Echelon Software, LLC • Pittsburgh

On-site
USD 120,000 - 160,000