Software Engineer - ETL/Informatica Developer

PNC•Pittsburgh, PA

1d•Onsite

About The Position

At PNC, people are the greatest differentiator and competitive advantage. The company is united in delivering the best experience for customers and fosters an inclusive workplace culture where employees feel respected, valued, and have an opportunity to contribute to the company’s success. This Software Engineer - ETL/Informatica Developer position is within PNC's Retail Technology organization and can be based in Pittsburgh, PA; Strongsville, OH; Cleveland, OH; Birmingham, AL; Phoenix, AZ; or Lakewood, CO. PNC is an in-office company that fosters a supportive culture where employees can thrive and achieve balance. Candidates are encouraged to connect with their recruiter and hiring manager to understand workplace expectations. PNC will not provide sponsorship for employment visas or participate in STEM OPT for this position.

Requirements

University / college degree, with 2+ years of relevant professional experience (or comparable combination of education, job specific certification(s), and experience)
Bachelors degree
Customer Focused - Knowledgeable of the values and practices that align customer needs and satisfaction as primary considerations in all business decisions and able to leverage that information in creating customized customer solutions
Managing Risk - Assessing and effectively managing all of the risks associated with their business objectives and activities to ensure they adhere to and support PNC's Enterprise Risk Management Framework
Application Design
Architecture
Application Development Tools
Application Maintenance
Application Testing
Packaged Application Integration
System Development Life Cycle
Technical Troubleshooting
Technical Writing/Documentation
Hands-on experience in ETL development using Informatica PowerCenter and PowerExchange
Strong experience designing, building, and supporting enterprise-scale data pipelines
Proven ability to work with relational databases such as Oracle, SQL Server, Teradata, and NoSQL platforms like MongoDB
Solid understanding of data integration from mainframe sources, including VSAM, flat files, COBOL copybooks, and DB2
Advanced SQL skills for data validation, reconciliation, and performance tuning
Experience implementing complex data transformations, business rules, and data quality checks
Knowledge of ETL job monitoring, troubleshooting, and production support processes
Strong background in technical documentation, including ETL mappings, workflows, and design specifications
Ability to collaborate effectively with Business Analysts, QA, and application teams to translate business requirements into technical solutions
Experience ensuring data quality, accuracy, and completeness across enterprise data systems

Nice To Haves

API Development
Application Development
Business Management
Customer Solutions
Design
ETL Development
Group Problem Solving
Informatica MDM
Process Improvements
Relational Database
Release Management
Software Solutions
User Experience (UX) Design

Responsibilities

Design, develop, and maintain ETL workflows and mappings for enterprise data integration
Build and support data pipelines using Informatica PowerCenter and PowerExchange
Extract and process data from mainframe sources (VSAM, flat files, COBOL copybooks, DB2)
Implement complex data transformations and business rules
Write and optimize SQL queries for data validation, reconciliation, and performance tuning
Work with relational databases such as Oracle, Mongo DB, SQL Server, or Teradata
Monitor ETL jobs, troubleshoot issues, and provide support
Ensure data quality, accuracy, and completeness
Create and maintain technical documentation (mappings, workflows)
Collaborate with Business Analysts, QA, and application teams to clarify data requirements

Benefits

Medical/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/elder care
Adoption, surrogacy, and doula reimbursement
Educational assistance, including select programs fully paid
A robust 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 to 25 vacation days each year, depending on career level; and years of service