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

Get similar jobs like these by email

By submitting your details you agree to our T&C's