Oracle FCCM / OFSAA Developer
- Toronto, ON, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Apply by
- Posting language
- English
- Posted
Original job description
Client: Banking
Duration: 6-month contract with potential extensions
Location: Toronto, ON - 4 days onsite per week
Position Summary
Kyndryl is seeking an experienced, hands-on Oracle FCCM / OFSAA Developer to support a major banking client's Customer Risk Rating application within a broader AML remediation programme. The production platform requires configuration, enhancement, defect resolution, data analysis, audit support, performance improvement, testing, and release delivery. The successful candidate will work with Financial Crime, AML Operations, Compliance, Risk, Audit, business, data, testing, and technology teams.
Priority Technical Requirements
- Hands-on Oracle FCCM Customer Risk Rating configuration, including risk factors, rules, weights, thresholds, scoring, segmentation, classifications, calibration, and result validation.
- Practical OFSAA platform and data-model experience across customer, party, account, transaction, address, jurisdiction, relationship, product, reference, staging, processing, and result data.
- Strong Oracle SQL and PL/SQL development, data analysis, reconciliation, execution-plan review, troubleshooting, and performance tuning.
- ETL and batch experience involving source-to-target mappings, transformations, staging loads, job dependencies, Unix/Linux scripting, and enterprise scheduling.
- Ability to investigate production issues across configuration, data, database, integration, and batch-processing layers and drive permanent resolution.
- Customer Risk Rating: Configure and maintain CRR models, risk factors, weights, thresholds, rules, segmentation, and assessment methodologies. Analyse risk-score distributions, trace factor inputs through final ratings, support calibration and tuning, and investigate unexpected customer classifications.
- OFSAA Data and Integration: Support end-to-end data flows from source systems through OFSAA and FCCM. Develop and maintain mappings and transformations for customer, account, transaction, relationship, address, product, jurisdiction, and reference data. Analyse missing, duplicate, invalid, incorrectly mapped, or rejected records.
- Oracle Development and Performance: Develop and support SQL, PL/SQL procedures, functions, packages, views, scripts, and database components. Analyse execution plans, inefficient joins, full scans, index usage, row estimates, and long-running queries; implement and validate performance improvements.
- ETL, Batch and Scheduling: Develop and support file-, table-, API-, and batch-based integrations. Configure, execute, monitor, and troubleshoot OFSAA batches, reconciliation controls, reject processing, restart and recovery, dependencies, Unix/Linux scripts, and Control-M or equivalent schedules.
- Defects, Testing and Releases: Perform root-cause analysis and implement corrective solutions. Support unit testing, SIT, UAT, regression testing, data remediation, customer-risk recalculation, production deployment, rollback planning, post-release validation, and handover to L3 support.
- AML Remediation and Stakeholders: Translate AML, KYC, CDD, EDD, Compliance, Risk, and audit requirements into technical designs and development tasks. Support remediation, regulatory and internal-audit evidence, requirements workshops, design reviews, defect triage, and release planning.
- Recent work experience with Financial Crime, AML, KYC, compliance technology, or related banking-technology experience.
- Must have experience in Oracle FCCM implementation, enhancement, or production support.
- Hands-on experience with Oracle FCCM Customer Risk Rating or Oracle KYC customer-risk assessment.
- Experience with OFSAA data models and customer, account, transaction, relationship, and reference data.
- Strong Oracle Database experience using SQL and PL/SQL, including database development and tuning.
- Experience with ETL, data mapping, reconciliation, Unix/Linux, OFSAA batch processing, and enterprise scheduling tools.
- Experience in a large banking or regulated financial-services environment and across the full SDLC.
- Ability to describe previous implementations in specific technical detail, including personally delivered configuration, database, integration, batch, testing, or defect-resolution work.
- Ability to work from the downtown Toronto office four days per week.
- Oracle FCCM Customer Risk Rating
- OFSAA platform and data models
- Oracle Database, SQL and PL/SQL
- Risk factors, scoring, thresholds and segmentation
- ETL, data mapping and transformation
- Data analysis and reconciliation
- Unix/Linux scripting
- OFSAA batch processing
- Control-M or equivalent scheduling
- SQL and batch performance tuning
- Root-cause analysis and production support
- SIT, UAT, deployment and release support
AML | KYC | CDD | EDD | Customer Risk Rating | Risk-based segmentation | Sanctions and watchlist screening | Financial Crime Compliance | Regulatory reporting | Customer and beneficial-owner relationships | Geographical, jurisdictional, product, industry, source-of-funds and transactional risk
Preferred Qualifications
- Oracle FCCM 8.x and experience with Transaction Monitoring, Enterprise Case Management, KYC, Watch List Management, sanctions screening, or regulatory reporting.
- Customer entity resolution, FSDF, code-set translation, FCCM configuration and result structures, or Elasticsearch within a relevant implementation.
- FINTRAC, US AML, FATF, internal-audit, regulatory-remediation, or Tier-1 Canadian, US, or international banking experience.
- Oracle FCCM, OFSAA, Oracle Database, or related certifications.
CRR configuration and enhancements | Functional and technical specifications | Source-to-target mappings and ETL specifications | SQL and PL/SQL components | OFSAA data and batch changes | Reconciliation and risk-score validation | Defect resolution | SIT and UAT support | Production and rollback documentation | Audit and regulatory support artifacts
Working Style
Hands-on technical practitioner: able to understand an established implementation, work directly with FCCM configuration, OFSAA data, Oracle databases, ETL and batch workflows, explain technical decisions clearly, and drive issues through tested production resolution.
#IndKyn
- Please note this is for a contract position with one of our clients and not a fulltime employment role with Kyndryl Canada**
More about this job
Responsibilities
Configure and enhance Customer Risk Rating models, support OFSAA data flows and integrations, and develop and tune Oracle SQL and PL/SQL components. Investigate production issues, manage batch processing and testing, support releases, and deliver technical remediation and audit evidence in collaboration with banking stakeholders.
Requirements
Requires hands-on Oracle FCCM Customer Risk Rating or KYC risk-assessment experience, OFSAA data-model knowledge, and strong Oracle SQL/PL/SQL development and tuning skills. Candidates must also have AML or related banking technology experience, ETL and batch-processing expertise, full SDLC experience, and the ability to work onsite in downtown Toronto four days per week.
Skills
- Oracle FCCM Customer Risk Rating
- OFSAA
- Oracle SQL
- PL/SQL
- Risk Model Configuration
- ETL and Data Mapping
- Data Analysis and Reconciliation
- Unix/Linux Scripting
- OFSAA Batch Processing
- Control-M Scheduling
- SQL Performance Tuning
- Production Support
- Root-Cause Analysis
- SIT and UAT
- AML and KYC
- Regulatory and Audit Support
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Software
- Finance & Accounting
- Data & Analytics
- Consulting
Keywords
- Oracle FCCM
- OFSAA
- Customer Risk Rating
- Oracle Database
- SQL
- PL/SQL
- ETL
- Data Mapping
- Data Reconciliation
- Risk Factors
- Risk Scoring
- Risk Segmentation
- Unix/Linux
- Control-M
- Batch Processing
- Performance Tuning
- AML
- KYC
- CDD
- EDD
- Financial Crime Compliance
- Sanctions Screening
- Watchlist Management
- Transaction Monitoring
- Enterprise Case Management
- SIT
- UAT
- Production Support
- Regulatory Remediation
- Root-Cause Analysis