At PNC, our people are our greatest differentiator and competitive advantage in the markets we serve. We are all united in delivering the best experience for our customers. As a Software Engineer Sr within PNC's Technology organization, you will be based in Pittsburgh, PA. Provides detailed technical design and development of software solutions using existing and emerging technology platforms.
Requirements
- Core Informatica Skills
- Informatica PowerCenter (Development & Debugging): Mappings, Mapplets, Sessions, and Workflow & Reusable transformations and parameterized workflows
- Strong understanding of ETL concepts (Extract, Transform, Load)
- Experience with source to target mappings
- Knowledge of Informatica Repository and metadata management
- Basic performance tuning (partitioning awareness, caching, pushdown concepts) Databases & SQL.
- Strong working knowledge of SQL: Joins, subqueries, aggregations Data validation and reconciliation queries.
- Experience with relational databases such as: Oracle Teradata
Benefits
- medical/prescription drug coverage
- 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
- robust wellness program with financial incentives