3 months ago
Pittsburgh, PA, USAStaff+
Responsibilities
- Lead the technical design and development of software solutions for regulatory risk and compliance reporting.
- Design, program, debug, and performance-tune Informatica ETL mappings, sessions, workflows, targets, and sources.
- Develop SCD mappings across different source formats and design HTTP transformations.
- Handle ETL code deployments using DevOps tools and manage UNIX shell scripts and CA7 job scheduling.
- Facilitate complex problem resolution and provide technical guidance and support to colleagues.
- Review coding, testing, and technical documentation and prepare required procedural documentation.
- Align software solutions with business strategy, regulatory requirements, and complex business needs.
Requirements
- 5+ years of development experience.
- Advanced design and programming skills in Informatica PowerCenter 9.6 or above and Oracle SQL/PLSQL.
- Proficiency developing and debugging PL/SQL code.
- Intermediate skills in data analysis and data modeling.
- Experience with software design patterns, architecture, and software development methodologies.
- A bachelor’s degree; a comparable combination of education, job-specific certifications, and experience may be considered in lieu of a degree.
- Preferred experience with Alteryx, Microsoft Power BI, Tableau, Oracle BI, Teradata, banking, and regulatory reporting.
- Strong written and verbal communication, independent learning, technical problem-solving, and collaboration skills.
Benefits
- Full-time employees may be eligible for medical, prescription drug, dental, vision, HSA, life insurance, disability, 401(k) matching, pension, and stock purchase plans.
- Benefits may include dependent care reimbursement, backup child/elder care, adoption, surrogacy, doula reimbursement, educational assistance, and wellness programs with financial incentives.
- Paid time off may include parental leave, up to 11 paid holidays, 9 occasional absence days, and 15 to 25 vacation days depending on career level and eligibility.
- This is an in-office position in Pittsburgh, Pennsylvania.
- PNC does not provide employment visa sponsorship or participate in STEM OPT for this position.
Tech Stack
Oracle Database
Categories
Data Engineering
About PNC
We’ll help keep your money boring so your life doesn’t have to be. pnc.co/guidelines