Description

You will design, implement, and test database services for loan processing and fund management.

Responsibilities

• Design and maintain a loan processing database in MS Access to track repayments, amortization schedules, and outstanding balances.
• Develop user interfaces with input validations to prevent data exceptions and ensure easy navigation.
• Build data import workflows from Excel, txt, and csv files using ODBC connections.
• Implement audit tracking on all database tables to identify users who enter, change, or approve data.
• Create export modules to generate files for central payroll management systems and prepare data for pension administration system conversions.

Required Skills

• 5+ years of experience with SQL and PL/SQL.
• 5+ years of advanced experience as an MS Access/VB Programmer.
• Experience working with Oracle databases.
• Proficiency with TOAD and/or PL/SQL Developer.
• 5+ years of experience working within a Windows environment.
• Familiarity with the Office 365 Suite.
• Ability to design multi-user databases with secure login functionality.
• Experience managing data imports and exports via Excel, txt, and csv.

Preferred Skills

• Experience with data conversion to pension administration systems.

Key Skills

Education

Any Graduate