Senior Oracle OFSAA FCCM Developer / Designer

Job Description: Senior Oracle OFSAA FCCM Developer / Designer

Role Overview

The OFSAA Transaction Monitoring Technology Lead is accountable for the technical design, build, and stability of the OFSAA Transaction Monitoring (TM) platform supporting enterprise AML programs. This role provides deep, hands-on leadership across OFSAA, FCCM, ETL/IETL, Oracle, scheduling, and data pipelines to ensure the platform remains resilient, scalable, and compliant.

As the primary technical authority for Transaction Monitoring, the Tech Lead drives architecture decisions, resolves complex production issues, and guides engineering teams through platform changes, upgrades, and regulatory initiatives.

Position Details & Performance Metrics

Data Access: Yes, the contractor will have access to customer data.

Meeting Cadence: Expect an average of 2-3 hours per day spent in meetings.

Performance Measurement: Success in this role is strictly measured by consistently hitting timelines and deliverables.

Core Responsibilities

Technical Ownership & Architecture

Own the end-to-end technical architecture of the OFSAA Transaction Monitoring platform (including OFSAA, FCCM, Oracle DB, ETL, scheduling, and integrations).

Define and enforce technical standards, patterns, and best practices for TM processing, job orchestration, and data handling.

Evaluate and drive platform enhancements, performance optimizations, and modernization initiatives (e.g., cloud enablement, refactoring, and re-engineering).

OFSAA TM Engineering & Platform Build

Lead hands-on engineering for OFSAA Transaction Monitoring jobs, including entity resolution (ER), TM, reconciliation, validation, and supporting batch processes.

Design and maintain AutoSys job flows, dependencies, restartability, and recovery strategies.

Provide deep technical guidance on Oracle SQL, partitioning, statistics collection, and performance tuning.

Review and approve TM technical designs, runbooks, and implementation artifacts.

Production Support & Complex Issue Resolution

Act as the highest-level technical escalation point for OFSAA TM production incidents.

Perform root-cause analysis across OFSAA, ETL/IETL, Oracle DB, file ingestion, and scheduling layers.

Design permanent fixes for recurring issues, data breaks, and performance bottlenecks while proactively identifying and remediating technical risks before they impact AML operations.

Data Quality, Controls & Reconciliation

Design and oversee technical data quality controls, validations, and reconciliations feeding TM scenarios.

Ensure technical integrity between source systems, staging layers, and OFSAA TM tables.

Partner with data and controls teams to embed preventive and detective controls directly into TM pipelines.

Change Delivery & Regulatory Initiatives

Lead technical delivery for scenario changes, tuning, threshold updates, lookbacks, and regulatory commitments.

Drive TM changes through the SDLC with a strong focus on testability, traceability, and audit readiness.

Support audits, exams, and model risk reviews by providing clear technical explanations, evidence, and system traceability.

Technical Leadership & Mentorship

Provide hands-on technical leadership and mentorship to engineers, developers, and vendor teams on OFSAA TM internals, AML platform design, and production engineering best practices.

Conduct rigorous reviews of code, SQL, job definitions, and technical solutions.

Act as the crucial technical bridge between AML stakeholders and engineering teams.

Candidate Profile Requirements

Experience & Education

Overall Experience: 10+ years of overall technology experience.

Education: Completed post-secondary education required (Diploma or Degree).

Must-Have Hard Skills

Strong hands-on experience with Oracle OFSAA Transaction Monitoring / FCCM TM.

Proven experience modernizing or migrating OFSAA / TM workloads to cloud platforms.

Direct exposure to high-volume payments or real-time monitoring platforms.

Prior experience working closely with regulators, auditors, or model risk teams from a technology perspective.

Deep understanding of TM batch processing, entity resolution, alert generation, and lookbacks in a regulated enterprise AML environment.

Advanced Oracle SQL expertise, including performance tuning, partitioning, and database troubleshooting.

Solid understanding of Linux scripting, batch operations, and production support tooling.

Nice-to-Have Skills & Certifications

Professional certifications in Java, Python, or SQL (highly regarded asset).

Practical experience with AutoSys (or equivalent enterprise schedulers).

Experience with ETL / IETL / Informatica frameworks and file ingestion.

Practical understanding of Entity Resolution.

Core Soft Skills

Strong written and verbal communication skills; ability to articulate complex technical concepts to non-technical stakeholders.

Exceptional interpersonal skills with a proven track record of working effectively both independently and within a team environment.

Self-motivated, well-organized, highly adaptable, and a true self-starter.

Meticulous attention to detail and ability to solve complex, cross-platform problems under production pressure.

Candidate Disqualifiers

Please Note: Candidates with unexplained employment gaps or a history of multiple short-term contracts will be automatically disqualified from consideration for this position.

location: Mount Laurel Township, New Jersey
job type: Contract
salary: $80 - 90 per hour
work hours: 8am to 5pm
education: Bachelors

responsibilities:
Core Responsibilities 1. Technical Architecture & Solution Design

• End-to-End Ownership: Own and maintain the technical architecture of the OFSAA Transaction Monitoring platform (spanning OFSAA, FCCM, Oracle DB, ETL pipelines, and job orchestrations).
• Design & Review: Translate complex AML business requirements into rigid technical designs, actively reviewing proposed solutions with cross-functional technical and non-technical stakeholders.
• Platform Evolution: Evaluate and execute platform enhancements, code refactoring, performance optimization, and cloud migration strategies (AWS/Azure).

2. Hands-on OFSAA TM Engineering & Build

• Pipeline Development: Execute hands-on programming and configuration for complex transaction monitoring components, including alert generation, entity resolution (ER), lookbacks, data validations, and reconciliations.
• Database Programming: Author, tune, and optimize advanced Oracle PL/SQL, database partitioning strategies, and statistics collections to handle massive financial data volumes.
• Batch Scheduling: Design, implement, and maintain resilient AutoSys job flows, establishing robust error-handling, restartability, and automated recovery strategies.

3. Production Support & Complex Issue Resolution

• Tier-3 Escalation: Act as the highest technical escalation point for critical production incidents within the AML transaction monitoring environment.
• Root-Cause Analysis: Diagnose complex data breaks and performance bottlenecks across the file ingestion, ETL/IETL, Oracle database, and application scheduling layers under production pressure.
• Risk Mitigation: Proactively identify code vulnerabilities or performance risks, engineering permanent system fixes before they impact regulatory timelines.

4. Data Quality & Regulatory Controls

• Data Integrity: Embed preventive and detective technical controls between source ingestion files, staging layers, and core OFSAA tables.
• Audit & Model Risk Readiness: Drive delivery for scenario changes, tuning, threshold updates, and lookbacks while ensuring impeccable SDLC documentation for model risk reviews, external audits, and regulators.

qualifications:
Must-Have Hard Skills

Oracle OFSAA FCCM: Direct, hands-on engineering and design experience explicitly within the Transaction Monitoring (TM) module. Profiles lacking active OFSAA experience cannot be considered.

Advanced Oracle PL/SQL: Expert-level database development skills, including deep performance tuning, database troubleshooting, and complex query optimization.

Cloud Infrastructure: Proven experience modernizing or migrating heavy OFSAA/TM workloads to cloud infrastructure environments (AWS or Azure).

Scale & Regulation: Exposure to high-volume payments or real-time transaction monitoring platforms coupled with experience building audit-ready pipelines for financial regulators or model risk teams.

Flexibilities & Nice-to-Haves

Background Openness: The manager welcomes seasoned Oracle/PLSQL Developers or Java Developers who successfully transitioned into long-term OFSAA experts. Core OFSAA TM competency trumps original background.

Scripting & Modern Tech: Exposure to Java, Python, front-end layers, or ETL tools (Informatica/IETL).

Certifications: Professional credentials in Java, Python, or SQL are considered strong assets.

Essential Soft Skills

Strong interpersonal skills paired with an ability to cleanly articulate technical complexities to compliance or business stakeholders.

Self-motivated, meticulous attention to detail, and a highly structured approach to meeting strict timelines and project deliverables.

Candidate Disqualifiers

Resume Fragility: Candidates with unexplained, extensive employment gaps or a consistent history of multiple, consecutive short-term contract stints will be automatically disqualified from consideration.

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact ....

Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility).

This posting is open for thirty (30) days.