Software Engineer Principal-Informatica/Oracle/SQL

PNC Bank•Pittsburgh, PA

5d•Onsite

About The Position

As a Software Engineer Principal in PNC’s Technology organization, you will align business strategy with software solutions and design, develop, and code solutions for complex business needs. The role is based in Pittsburgh, Pennsylvania, and requires weekly time in the office. The position may not be available in other geographic areas. PNC is seeking an experienced ETL developer with data engineering and data integration expertise. The role requires hands-on Informatica development, advanced ANSI SQL, and experience with Oracle and Microsoft SQL Server. You will interpret complex data and business and technical requirements, build reliable ETL solutions, troubleshoot data issues, and work independently from requirements through implementation and production support. Tableau or Power BI experience is desired; mainframe exposure is preferred but not required. The position also involves overseeing technical and procedural documentation, leading complex problem solving, and providing technical guidance to colleagues and solution development. You will apply modern principles, methodologies, and tools to advance business initiatives while focusing on customer needs and managing risks in accordance with PNC’s Enterprise Risk Management Framework. PNC is an in-office company that encourages candidates to discuss workplace expectations with their recruiter and hiring manager. PNC will not provide employment visa sponsorship or participate in STEM OPT for this position.

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 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.
Typically requires a university or college degree and 5 or more years of industry-relevant experience; comparable combinations of education, job-specific certifications, and experience may be considered in lieu of a degree.
Must demonstrate appropriate knowledge, skills, and abilities for the role.
No employment visa sponsorship or STEM OPT participation is available for this position.

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.
Skills in Agile methodology, computer programming, data structures, DevOps, distributed systems, object-oriented programming, software development, SDLC, software engineering, and system design.
Competencies in application design, architecture, packaged application integration, product and vendor evaluation, software process improvement, SDLC, and technical troubleshooting.

Responsibilities

Align business strategy with software solutions.
Propose, design, and code software solutions for complex business needs.
Develop and support production ETL solutions using Informatica.
Translate business and technical requirements into reliable ETL solutions and work from requirements through implementation and production support.
Analyze and troubleshoot data-related issues across multiple systems.
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.
Assess and manage risks associated with business objectives and activities in support of PNC’s Enterprise Risk Management Framework.
Focus on customer needs and satisfaction when making business decisions and creating customer solutions.

Benefits

Medical and prescription drug coverage, including 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.
15 to 25 vacation days each year, depending on career level and years of service.