PNC

Software Engineer Principal, Oracle, ETL, Data Warehousing

PNC

full-time

Posted on:

Location Type: Office

Location: Pittsburgh • Alabama • Pennsylvania • United States

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

Lead

Tech Stack

ETLHadoopInformaticaJavaOracleSpringSpring BootSpringBootSQL

About the role

  • Align business strategy with software solutions.
  • Propose and design complex software solutions and processes addressing complex Investments business needs.
  • Solutioning new data integrations and code deployments.
  • Design, build, and maintain scalable data pipelines using ETL and Big Data technologies.
  • Design, develop and maintain mainframe CA7 job schedules to support new and existing processes.
  • Create complex SQL and PL/SQL queries to perform Data Mining/Data Analysis.
  • Oversee technical and procedural documentation.
  • Lead complex problem solving.
  • Collaborate with Business Analysts, Data Analysts, and other stakeholders to understand requirements and deliver data solutions.
  • Develop and optimize Data Warehousing solutions to ensure high availability and performance.
  • Lead complex Data Warehouse applications.
  • Provide technical guidance and support to colleagues and solution development.
  • Perform code reviews and suggest potential improvements.
  • Ensure quality of project deliverables while maintaining compliance with relevant standards and processes.
  • Implement data modeling techniques to support analytics and reporting needs.

Requirements

  • 5+ years of industry-relevant experience
  • Bachelor's degree
  • Informatica ETL development and design
  • Leading complex Data Warehouse applications
  • CA7 Orchestration experience
  • Data Warehouse experience, and working with large amounts of data
  • Teradata, Oracle, Hadoop proficiency
  • Experience solutioning new data integrations
  • Experience with code deployment tools such as Udeploy, Artifactory, and GitHub
  • Java/Spring Boot knowledge
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
  • 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
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
ETLBig DataSQLPL/SQLData WarehousingData ModelingJavaSpring BootCA7Teradata
Soft Skills
problem solvingcollaborationtechnical guidancedocumentation oversightquality assurance
Certifications
Bachelor's degree