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
