Oracle PLSQL Sanctions Developer

• Sanctions Knowledge:
  
  

Candidates must demonstrate experience with sanctions, explaining the processes for transactional and static screening, the lists or rules involved, and the screening and disposition workflows.

A deeper understanding is required, including how transactions are monitored, rules applied, and stakeholder involvement.

Superficial answers (e.g., broad statements about sanctions) are insufficient; candidates should provide detailed insights into the workings of sanctions.

• SQL Proficiency:
  
  

Candidates should have the ability to write moderately complex SQL queries, including tasks such as:

1 .Handling joins.

• Finding maximum or second-highest transaction values.
• Grouping transactions by customer ID or account number.
  
  

While not expected to handle extremely lengthy or advanced queries, they should demonstrate competence in handling queries with some complexity.

• Data Analysis Experience:
  
  

Candidates Must Have Experience In Data-related Roles, Including

• Performing data mapping.
• Conducting gap analysis.
• Managing various data activities.
• Payments:
  
  

Candidates should have a solid understanding of payment products. While they don t need to master all products, familiarity with at least one, such as real-time payments (e.g., Zelle) or wires, is essential. They should be able to explain the end-to-end process, including how transactions work, how settlements occur, the types of checks involved, and the message types used, such as SWIFT or ISO standards.

---