Senior Software Engineer - ETL, Informatica, Hadoop

PNC

Actively hiring Verified listing
Two Pnc Plaza (Pa374) · Strongsville Technology Center · Birmingham - Brock · Dallas Innovation Center - Luna Rd Posted 10 days ago
View original post Log in to save

At a glance

AI generated

TL;DR

As a Senior Software Engineer in PNC's Retail Tech organization, you will design and develop ETL workflows using Informatica PowerCenter and PowerExchange to integrate enterprise data from various sources including Oracle, Hadoop, SQL Server, and flat files. Your daily tasks include implementing complex data transformations, writing optimized SQL queries for validation and performance tuning, and collaborating with Business Analysts and QA teams to ensure data quality and completeness. You will also monitor ETL jobs, troubleshoot issues, and maintain technical documentation. This role requires hands-on experience in enterprise-scale data pipelines, relational databases like Oracle and SQL Server, and NoSQL platforms such as MongoDB, along with strong collaboration skills and the ability to work off hours for releases and offshore support.

Skills

Informatica PowerCenter Informatica PowerExchange Oracle SQL Server MongoDB Teradata SQL ETL Job Monitoring Technical Documentation ServiceNow OBI Tableau

What you'll do

  • Design and develop ETL workflows using Informatica PowerCenter and PowerExchange.
  • Extract and process data from diverse sources including Oracle, Hadoop, SQL Server, and flat files.
  • Implement complex data transformations and enforce business rules in enterprise systems.
  • Write and optimize SQL queries for validating, reconciling, and tuning data performance.
  • Monitor ETL jobs, troubleshoot issues, and ensure high-quality data accuracy and completeness.

What we're looking for

  • Extensive experience in ETL development using Informatica PowerCenter and PowerExchange.
  • Strong background in designing and supporting enterprise-scale data pipelines.
  • Proficient in working with relational databases (Oracle, SQL Server, Teradata) and NoSQL platforms like MongoDB.
  • Advanced skills in writing and optimizing complex SQL queries for performance tuning.
  • Expertise in implementing complex data transformations and business rules.
  • Experience in monitoring ETL jobs, troubleshooting issues, and ensuring data quality.
  • Ability to collaborate with Business Analysts, QA teams, and application developers effectively.

Market check

Salary context

This listing doesn't show a salary. Similar roles on FindRole typically pay $120,000–$215,000.

Peer median band

$120,000–$215,000

Median floor and ceiling across peers.

Typical midpoint (25–75%)

$142,400–$211,200

Middle half of comparable postings.

Based on 240 comparable postings.

* 240 is the maximum number of comparable postings sampled.

Employer

About PNC

PNC is one of the largest diversified financial services institutions in the U.S., based in Pittsburgh, PA, it provides retail banking, corporate banking, and asset management.

PNC currently has 180 open roles on FindRole.

Listed pay typically runs $74,750–$171,925 across 62 roles with salary data.

Most-posted roles

View all roles at PNC

More like this

Similar roles

Software Engineer - ETL/Informatica Developer

PNC

The Tower At Pnc Plaza (Paa86), US 37 days ago
Informatica ETL SQL Oracle MongoDB SQL Server Teradata VSAM COBOL DB2 Data Integration ETL Job Monitoring Technical Documentation API Development Application Development Process Improvements Relational Database Release Management User Experience (UX) Design

Software Engineer - ETL, Informatica

PNC

Two Pnc Plaza (Pa374), US 10 days ago
Informatica Oracle SQL PLSQL Unix CA7 Teradata Spring Boot OpenShift Angular CI/CD JCL ETL Release Management Scheduling Tools

Senior Software Engineer, Big Data

Zillow

Remote (Remote-Wa, US) 72 days ago $160,900–$257,100
Kafka Flink Python Java Scala AWS Kubernetes Terraform CI/CD SLOs Prometheus Grafana Databricks Confluent MSK Redpanda
Remote

Senior Software Engineer (Data Engineering)

Kohl's

Remote (Kohl'S Corporate Offices (0900), US) 16 days ago
Python Apache Airflow Spark SQL NoSQL Google BigQuery Amazon Redshift Snowflake GCP AWS Azure PCI DSS GDPR CCPA OpenAI GenAI XP CI/CD
Remote