Home
Jobs
Saved
Resumes
Software Engineer – ETL, Informatica Developer at PNC | JobVerse
JobVerse
Home
Jobs
Recruiters
Companies
Pricing
Blog
Jobs
/
Software Engineer – ETL, Informatica Developer
PNC
Website
LinkedIn
Software Engineer – ETL, Informatica Developer
Pittsburgh, Texas, United States of America
Full Time
1 hour ago
$45,000 - $121,900 USD
Visa Sponsor
Apply Now
Key skills
ETL
Informatica
MongoDB
NoSQL
Oracle
SQL
COBOL
SQL Server
About this role
Role Overview
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, Mongo DB, SQL Server, or Teradata
Monitor ETL jobs, troubleshoot issues, and provide support
Ensure data quality, accuracy, and completeness
Create and maintain technical documentation (mappings, workflows)
Collaborate with Business Analysts, QA, and application teams to clarify data requirements
Requirements
Hands-on experience in ETL development using Informatica PowerCenter and PowerExchange
Strong experience designing, building, and supporting enterprise-scale data pipelines
Proven ability to work with relational databases such as Oracle, SQL Server, Teradata, and NoSQL platforms like MongoDB
Solid understanding of data integration from mainframe sources, including VSAM, flat files, COBOL copybooks, and DB2
Advanced SQL skills for data validation, reconciliation, and performance tuning
Experience implementing complex data transformations, business rules, and data quality checks
Knowledge of ETL job monitoring, troubleshooting, and production support processes
Strong background in technical documentation, including ETL mappings, workflows, and design specifications
Ability to collaborate effectively with Business Analysts, QA, and application teams to translate business requirements into technical solutions
Experience ensuring data quality, accuracy, and completeness across enterprise data systems
Tech Stack
ETL
Informatica
MongoDB
NoSQL
Oracle
SQL
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
a 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
Apply Now
Home
Jobs
Saved
Resumes