Shell Scripting

PNC•Denver, FL

6d•$106,000 - $165,600•Onsite

About The Position

The Software Engineer Principal is a senior technical leader within the Fraud Transactions Engineering organization, responsible for designing, optimizing, and extending the systems that power high volume, database driven fraud transaction processing. This role focuses on SQL optimization, database centric application design, Java based platform extensions, and enterprise integrations that enable real time and batch fraud detection. The Principal Engineer partners closely with application teams, DBAs, platform engineers, and operations to ensure fraud systems are performant, resilient, and scalable.

Requirements

Bachelor’s degree in Computer Science, Engineering, or equivalent experience.
5+ years of hands on software engineering experience in enterprise environments.
Expert level SQL and PL/SQL skills, with experience supporting high volume, database driven systems.
Strong Java programming experience, including building custom extensions or plugins for enterprise platforms.
Experience with Oracle or Microsoft SQL Server in transaction intensive environments.
Hands on experience with enterprise integration technologies (ETL, APIs, web services, messaging).
Working knowledge of Unix/Linux environments and shell scripting.
Customer Focused - Knowledgeable of the values and practices that align customer needs and satisfaction as primary considerations in all business decisions and able to leverage that information in creating customized customer solutions.
Managing Risk - Assessing and effectively managing all of the risks associated with their business objectives and activities to ensure they adhere to and support PNC's Enterprise Risk Management Framework.

Nice To Haves

Application Development
Business Management
Customer Solutions
Design
Extract Transform Load (ETL)
Group Problem Solving
Java
Linux
Process Improvements
Release Management
Software Solutions
Structured Query Language (SQL)
User Experience (UX) Design

Responsibilities

Serve as a technical authority for SQL design and optimization across fraud transaction platforms.
Design, analyze, and tune complex SQL and PL/SQL used in high volume transactional and analytical workloads.
Partner with engineers to optimize database access patterns, indexing strategies, and schema designs.
Diagnose and remediate SQL driven performance issues impacting real time fraud decisioning or batch processing.
Develop and maintain Java based custom extensions, including Action Plugins, to enhance and extend Actimize platform functionality.
Collaborate with fraud engineers to integrate custom logic into detection and processing flows while maintaining performance and stability.
Ensure Java components are efficiently designed to minimize database contention and latency.
Design and support integrations between fraud platforms and upstream/downstream banking systems.
Work with ETL tools (e.g., Informatica), APIs, SOAP/REST web services, and message queues to enable reliable, performant data movement.
Optimize data ingestion and extraction patterns to support fraud detection at scale.
Leverage Unix/Linux shell scripting to automate operational tasks, support maintenance activities, and assist with diagnostics.
Partner with platform and operations teams to improve automation, monitoring, and operational efficiency.
Act as a Principal level technical mentor to engineers across Fraud Transactions Engineering.
Provide design guidance and code reviews focused on performance, scalability, and maintainability.
Collaborate with product, architecture, and operations partners to translate fraud requirements into technical solutions.
Lead during high severity incidents, quickly isolating and resolving application or query level issues.
Aligns business strategy with software solutions.
Proposes, designs & codes software solutions to address complex business needs.
Oversees technical and procedural documentation required.
Leads complex problem solving.
Provides technical guidance and support to colleagues and solution development.
Displays an innovative approach to apply modern principles, methodologies and tools to advance business initiatives and capabilities.