LogoFresh Jobs Ahead
PNC
PNC
B2BBanku darbībaFinanses
PNC ir daudzveidīgs finanšu pakalpojumu uzņēmums un viena no lielākajām ASV bankām, kas patērētājiem un uzņēmumiem nodrošina banku un finanšu pakalpojumus. Uzņēmuma karjeras informācijā izceltas iespējas lielā organizācijā, iekļaujoša darba vide, studentu programmas un strukturēts darbā pieņemšanas process. PNC uzņēmuma informācija ietver arī nodarbinātības politiku un paziņojumus par vienlīdzīgām nodarbinātības iespējām, kas ir būtiski potenciālajiem kandidātiem.
LinkedIn
Vakances uzņēmumā

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.

USAmerikas Savienotās ValstisPAPensilvānijaVAVirdžīnija
86 250 $ – 172 500 $ / gads
HibrīdiPilna slodzeVecākais speciālistsNepieciešamā Valoda: angļuAnalītikas inženieris
Čaulas skriptēšanaETLInformaticaOracleSQLTableauUnix

Apraksts

  • 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.

Prasības

  • 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

Priekšrocības

  • 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.

Saistītās vakances