Oracle PLSQL + Sanctions Developer

6 - 11 years

3 - 7 Lacs

Posted:3 hours ago| Platform: Naukri logo

Apply

Work Mode

Work from Office

Job Type

Full Time

Job Description

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.
  • Qualification

    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.
  • Mock Interview

    Practice Video Interview with JobPe AI

    Start Job-Specific Interview
    cta

    Start Your Job Search Today

    Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

    Job Application AI Bot

    Job Application AI Bot

    Apply to 20+ Portals in one click

    Download Now

    Download the Mobile App

    Instantly access job listings, apply easily, and track applications.

    coding practice

    Enhance Your Skills

    Practice coding challenges to boost your skills

    Start Practicing Now
    Virtusa logo
    Virtusa

    Information Technology and Services

    Southborough

    RecommendedJobs for You