Connecting...

MS SQL Developer (Renewable Contract)

Job Title: MS SQL Developer (Renewable Contract)
Contract Type: Contract
Location: Hong Kong Island, Hong Kong
Industry:
Salary: Neg.
Start Date: ASAP
Reference: 195465_1559529923
Contact Name: Alice Tong
Contact Email: alice.tong@peoplebank.asia
Job Published: June 03, 2019 10:45

Job Description


Responsibilities:

  • 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)
  • 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



Candidate Specifications:

  • University degree in Computer Science, Information Technology or related subjects
  • 5+ years working experience, of which more than 3 years in-depth SQL programming & SSIS exposure
  • Advanced problem determination and resolution skills
  • Effective written and oral communication in English



Technical Skills:

  • MS-SQL administration including SSIS and SSRS
  • Advanced SQL skill & design script on SSIS platform
  • Exposure of cloud technology
  • Good understanding of PGP 6 encryption program
  • Knowledge in Sun GL 4.x/6.x is added advantage
  • Knowledge in Workday is added advantage
  • Experience in supporting SFTP data transfer is an advantage
  • Experience in Azure Data Factory and Azure SSIS would be an added advantage

Intersted parties please send your resume by Apply Now