Back to jobs

(Senior) Analyst Programmer (Oracle/ SQL)- Banking Industry

Job description


  • Environment preparation, including database synchronization, code synchronization, data preparation, parameter configuration (i.e.,DataStage, Cognos)
  • PLSQL job testing after Oracle upgrade
  • Different types of job data verification tests
  • Work with related application teams on CDC (Change Data Capture) decommission. i.e., AVQ, Murex etc 8 applications. Monitoring the status and provide necessary help on Dev, SIT, UAT, PRD stages.
  • Work with related application teams on Oracle database migration and upgrade from 12c into 19c. i.e., AVQ, Murex etc 8 applications. Monitoring the status and provide necessary help on UAT regression testing.
  • Work on history data migration task with vendor, from ODS (Operational Data Store) platform migrate into data lake.
  • Server VM application, network resource activation, CRQ, CIR, online process, etc.
  • Develop a monitoring shell script which ensure that each application data retention fulfill the agreed standardize, i.e., 7 days daily & 13 months monthly snapshots.


  • Concrete knowledge of Banking industry in various area.
  • Excellent command of written and spoken English and Chinese (including Putonghua)
  • UNIX/Linux knowledge, shell scripting is a must
  • Good at SQL knowledge on Oracle 12 c or above
  • Technical skill and experience on DataStage, Cognos and Cloudera Hive is preferable
  • Excellent analytical and problem solving skills
  • Be a team player for mobilizing the team and vendor resources.
  • Proactive attitude and able to work independently.
  • Willing to work under pressure and overtime.
  • Stakeholder management skills, assist project manager to prepare related project documents
  • Degree holder in Electronics/Computers/Software/Information Management or Information Technology or Business Administration or other relevant qualification.
  • Knowledge of Business Intelligence Tools for reporting and visualization is preferable
  • Minimum 2 years' experience in application software development, preferable in banking industry or finance institutes.

Contact Ms. Alexandra Leung at (852) 3103 4312 or APPLY NOW by clicking the button below.

Data provided is for recruitment purposes only.

If this job isn't quite right for you, but you know someone who would be great at this role, why not take advantage of our referral scheme? We offer HKD1000 in Apple gift cards for every referred candidate who we place in a role. Terms & Conditions Apply.