LogoFresh Jobs Ahead
PNC
PNC
B2BBankingFinance
PNC is a diversified financial services firm and major U.S. bank serving consumers and businesses through banking and finance services. Its career content highlights opportunities across a large organization, an inclusive workplace, student programs, and a structured hiring process. PNC’s company information also includes employment policies and equal employment opportunity disclosures relevant to prospective applicants.
LinkedIn
Company Jobs

Lead ETL Software Engineer, Regulatory Risk and Compliance at PNC

Lead ETL engineering for PNC’s regulatory risk and compliance reporting systems. Design data-intensive applications, reporting workflows, and enterprise software.

USUnited StatesPAPennsylvaniaVAVirginia
$86,250 – $172,500 / year
HybridFull-timeSeniorEnglish RequiredAnalytics Engineer
ETLInformaticaOracleShell ScriptingSQLTableauUnix

Description

  • Lead the technical design and development of software solutions.
  • Design software solutions for complex business needs.
  • Prepare technical and procedural documentation.
  • Resolve complex technical problems.
  • Guide and support colleagues on technical matters.
  • Review software code, tests, and documentation.
  • Use modern principles, methods, and tools to advance business initiatives and capabilities.
  • Lead and collaborate on data changes, from consumption through reporting, including their design and programming.
  • Build data-intensive applications that meet business and regulatory needs.
  • Create SCD mappings with varied source formats and transformations.
  • Optimize targets, sources, mappings, sessions, and workflows for performance.
  • Deploy ETL code using DevOps tools.

Requirements

  • At least five years of development experience.
  • Strong written and verbal communication skills.
  • Formal project experience using a methodology such as waterfall or agile.
  • Advanced design and programming skills with Informatica PowerCenter 9.6 or later and Oracle SQL/PLSQL.
  • Proficiency developing and debugging PL/SQL code.
  • Ability to create SCD mappings from different source formats using appropriate transformations.
  • Experience tuning targets, sources, mappings, sessions, and workflows for performance.
  • Ability to design HTTP transformations.
  • Experience deploying ETL code with DevOps tools.
  • Hands-on knowledge of UNIX shell scripting and the CA7 job scheduler.
  • Intermediate skills in data analysis and data modeling.
  • Bachelor’s degree.
  • A comparable combination of education, job-specific certifications, and experience, including military service, may be considered in place of a degree.
  • Banking and regulatory reporting experience is a plus.
  • Alteryx experience is preferred.
  • Experience with Microsoft Power BI, Tableau, or Oracle BI is preferred.
  • Hands-on knowledge of Teradata is preferred.
  • Working knowledge of software design patterns and architecture is preferred.
  • No certifications or licenses are required.
  • PNC does not provide employment visa sponsorship or participate in STEM OPT.
  • benefits are intentionally listed separately below

Benefits

  • Medical and prescription drug coverage with a Health Savings Account feature.
  • Dental and vision plan options.
  • Life insurance for employees and their spouses or children.
  • Short- and long-term disability coverage.
  • 401(k) plan with a PNC match.
  • Pension plan.
  • Stock purchase plan.
  • Dependent care reimbursement account.
  • Backup child and elder care.
  • Adoption, surrogacy, and doula reimbursement.
  • Educational assistance, including select programs that are fully paid.
  • Wellness program with financial incentives.
  • Maternity and/or parental leave.
  • Up to 11 paid holidays per year.
  • Nine occasional absence days per year.
  • 15 to 25 vacation days per year, depending on career level.

Related Jobs

FHI 360

Associate Director of Procurement, Administration and Logistics

FHI 360
1,001 – 5,000 Employees
H1B Visa SponsorConsultingFood & BeverageHealthcare
CDCongo - Kinshasa
$120,000 – $143,000 / year
On-siteFull-timeSeniorEnglish RequiredFrench RequiredProcurement

Leads procurement, administration, logistics, and operations for FHI 360’s country office in the Democratic Republic of the Congo. Supervises functional leads and maintains compliance with donor, government, and supply chain requirements.

Open