Oracle PLSQL + Sanctions Developer

1. 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.
2.SQL Proficiency:
Candidates should have the ability to write moderately complex SQL queries, including tasks such as:
1 .Handling joins.
2. Finding maximum or second-highest transaction values.
3. 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.
3. Data Analysis Experience:
Candidates must have experience in data-related roles, including:
1. Performing data mapping.
2. Conducting gap analysis.
3. Managing various data activities.
4. 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.