ETL Informatica Engineer: Build Enterprise Data Pipelines

PNC Financial Services Group, Inc.

United States

On-site

USD 45,000 - 122,000

Full time

8 days ago

Application generator

Stand out for this role — generate a tailored resume and cover letter in about a minute.

Get past ATS filters

Benefits offered by this job

Health insurance

401(k) with match

Paid time off

Job summary

PNC Financial Services Group, Inc. is seeking a Software Engineer - ETL/Informatica Developer for its Retail Technology organization.

The role includes designing and maintaining ETL workflows, building data pipelines with Informatica, and extracting data from mainframe sources across multiple in-office locations. You will optimize SQL, ensure data quality, and collaborate with Business Analysts, QA, and application teams.

Qualifications

2+ years of relevant professional experience.
Bachelor's degree in a related field.
Experience with Informatica ETL development and data integration in enterprise environments.

Responsibilities

Design, develop, and maintain ETL workflows and mappings for enterprise data integration.
Build and support data pipelines using Informatica PowerCenter and PowerExchange.
Extract and process data from mainframe sources (VSAM, flat files, COBOL copybooks, DB2).
Implement complex data transformations and business rules.
Write and optimize SQL queries for data validation, reconciliation, and performance tuning.
Work with relational databases such as Oracle, SQL Server, Teradata; NoSQL like MongoDB.
Monitor ETL jobs, troubleshoot issues, and provide production support.
Ensure data quality, accuracy, and completeness; maintain mappings and workflows.