Software Engineer Principal-Oracle/SQL

PNC•Pittsburgh, PA

6d•Onsite

About The Position

As a Software Engineer Principal in PNC’s Technology organization, this role is based in Pittsburgh, Pennsylvania, and requires weekly time in the office. The position may not be available in other geographic areas. The role focuses on aligning business strategy with software solutions and developing reliable ETL and data integration solutions. The successful candidate will translate business and technical requirements into implementations, troubleshoot complex data issues, and work independently from requirements through production support. The position proposes, designs, and codes software solutions for complex business needs; oversees technical and procedural documentation; leads complex problem solving; and provides technical guidance to colleagues and solution development. It also applies modern principles, methodologies, and tools to advance business initiatives and capabilities. PNC emphasizes customer focus and effective management of risks in support of its Enterprise Risk Management Framework.

Requirements

At least 5 years of hands-on Informatica experience, including development and support of production ETL solutions.
At least 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 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.
Work experience at this level typically requires a university or college degree and 5+ years of industry-relevant experience; a comparable combination of education, job-specific certifications, and experience may be considered in lieu of a degree.
Bachelor’s degree listed under Education.

Nice To Haves

At least 1 year of experience with Tableau or Power BI for reporting, visualization, or data analysis.
Exposure to mainframe environments or mainframe data sources.
Experience integrating data between legacy or mainframe platforms and distributed database systems.
Experience with scheduling, batch processing, source-to-target mapping, data reconciliation, and production support.
Preferred skills include Agile Methodology, Computer Programming, Data Structures, DevOps, Distributed Systems, Object-Oriented Programming, Software Development, Software Development Life Cycle, Software Engineering, and System Designs.
Competencies include Application Design, Architecture, Packaged Application Integration, Product and Vendor Evaluation, Software Process Improvement, System Development Life Cycle, and Technical Troubleshooting.

Responsibilities

Align business strategy with software solutions.
Propose, design, and code software solutions to address complex business needs.
Oversee required technical and procedural documentation.
Lead complex problem solving.
Provide technical guidance and support to colleagues and solution development.
Apply modern principles, methodologies, and tools to advance business initiatives and capabilities.
Develop and support production ETL solutions and troubleshoot data-related issues across multiple systems.
Work from requirements through implementation and production support.

Benefits

Medical and prescription drug coverage, with a Health Savings Account feature.
Dental and vision options.
Employee and spouse/child life insurance.
Short- and long-term disability protection.
401(k) with PNC match.
Pension and stock purchase plans.
Dependent care reimbursement account.
Back-up child and elder care.
Adoption, surrogacy, and doula reimbursement.
Educational assistance, including select fully paid programs.
Wellness program with financial incentives.
Maternity and/or parental leave.
Up to 11 paid holidays each year.
9 occasional absence days each year, unless otherwise required by law.
Between 15 and 25 vacation days each year, depending on career level and years of service.