Oracle PLSQL + Sanctions Developer

1. Sanctions Knowledge Demonstrated experience with sanctions compliance, specifically transactional and static screening. In-depth understanding of sanction lists/rules, screening workflows, and disposition processes. Ability to explain how transactions are monitored, how screening rules are applied, and which stakeholders are involved in the process. Expect detailed, technical insights rather than general or superficial answers. 2. SQL Proficiency Competent in writing moderately complex SQL queries. Skills should include: Performing joins across tables. Finding maximum or second-highest transaction values. Grouping transactions by key fields such as customer ID or account number . Not required to write extremely advanced or long queries, but must show comfort with intermediate-level query complexity. 3. Data Analysis Experience Hands-on experience in data-centric roles, including: Data mapping between systems or datasets. Performing gap analysis to identify inconsistencies or missing data. Managing a variety of data-related activities, ensuring data quality and completeness. 4. Payments Knowledge Solid understanding of at least one payment product, for example: Real-time payments such as Zelle. Wire transfers . Ability to explain the end-to-end payment lifecycle , including: Transaction flow. Settlement processes. Types of checks performed (e.g., compliance, fraud). Messaging standards used (e.g., SWIFT , ISO 20022 ).