Career

Business Intelligence & Data Engineering

Systems Analyst (ETL)

Responsibilities:

  • Architecture design
  • Advise on the design of the Integration layer to allow for scalability and flexibility
  • Incorporate error handling and audit trail activities into the design
  • Design codes which are reusable and subjected to minimal modification when reuse
  • Advise on the database design and creation of reference table
  • Automate the data feed between source system and destination (and vice versa)
  • SSIS &SQL Development
  • Design and writing script on the SSIS platform
  • Perform SQL programming based on the business rules defined
  • Writing stored procedure to automate the script
  • Prepare technical specification and design document
  • Design batch program and execute job on the Window Scheduler
  • Embedded encryption into the data file

Requirements:

  • Bachelor Degree  in Computer Science, Computer Engineering or related disciplines
  •  Exposure of cloud technology
  • MS-SQL administration including SSIS and SSRS
  • Experience in supporting SFTP data transfer Azure Data Factory and Azure SSIS is a plus
  • Knowledge in Sun GL 4.x/6.x & Workday are an advantage
  • Hands on experience in supporting SFTP data transfer Azure Data Factory and Azure SSIS is a plus
  • Can work independently and schedule the tasks to the subordinates

 

Interested parties, please state your availability, current and expected salaries in your resume, email to irecruit@ico.com.hk. All information gathered will be treated in strict confidence and solely used for recruitment purposes.

The resume will be retained for a period of two years for recruitment purpose only in accordance with ICO Limited Privacy Policy.

Data Warehouse / BI Programmer

What we offer:

  • Golden opportunity for placement to medium-to-large scaled IT projects in various banking departments and commercial sectors.

  • On-job coaching by experienced IT professionals

  • Promotion opportunity based on performance, NOT years of experience

  • Excellent opportunity to further develop your technical skills in data warehousing

  • Job rotation opportunity to other IT projects

 

Requirement:

  • Degree holder in Information Technology, Computer Science or related discipline.

  • With SQL knowledge

  • Experience in BI / Data Warehouse is an advantage

  • Experience in DB2 / Datastage / Cognos is an advantage

  • Knowledge in ETL / Reporting tools is an advantage

  • Self-motivation and a good team player

  • Good analytical and communication skills, and be able to work under pressure.

  • Good Cantonese and English communication skill is plus

  • Candidate with strong IT knowledge will also be considered

 

Interested parties, please state your availability, current and expected salaries in your resume, email to irecruit@ico.com.hk. All information gathered will be treated in strict confidence and solely used for recruitment purposes.

The resume will be retained for a period of two years for recruitment purpose only in accordance with ICO Limited Privacy Policy.

TOP