design, build, schedule, and operate high-reliability data pipelines supporting the Lending Digital Payment Platform
Design, develop, and maintain batch and near-real-time ETL pipelines supporting payment processing, settlement, and reporting
Develop ETL workflows and mappings using Informatica (PowerCenter)
Own ETL job scheduling, including creating and modifying schedules to meet SLAs and dependency constraints
Build restartable, idempotent ETL jobs capable of safe re-runs without data duplication
Optimize execution windows, performance, and resource utilization in production
Implement mandatory data quality controls including record counts, control totals, reconciliation, and exception reporting
Ensure payment data accuracy, completeness, and consistency across all ETL stages
Proactively identify and remediate data quality issues before downstream impact
Own production support for ETL jobs, including monitoring, alerting, incident resolution, and root cause analysis
Troubleshoot failures related to data issues, schedule conflicts, dependency delays, or system outages
Automate recovery steps and reduce manual intervention through stabilization and standard patterns

Requirements

8+ years of experience designing, scheduling, and supporting production ETL pipelines
Proficiency developing ETL jobs in Informatica (PowerCenter) in a production environment
Strong SQL querying proficiency in both MySQL and Oracle (joins, windowing/analytics, performance awareness)
Experience troubleshooting data issues using SQL across MySQL and Oracle source/target systems
Demonstrated ownership of ETL schedules and SLA-driven execution
Strong understanding of data quality controls, reconciliation, and audit requirements
Experience in payments, financial services, or other regulated environments
Knowledge of CDC, incremental loading strategies, and file-based integrations
Experience with job orchestration/dependency management tooling

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

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

ETL pipelinesInformaticaSQLMySQLOracledata quality controlsreconciliationjob orchestrationincremental loadingfile-based integrations

Soft Skills

troubleshootingownershipincident resolutionroot cause analysisproactive identificationcommunicationproblem-solvingperformance optimizationattention to detailcollaboration