Optimum Solutions (Registration Number: 199700895N) is Singapore's leading Information Technology , Consulting and Professional Services company with Competence in Digital Transformation, Automation, Robotics, Cloud, Big Data, Analytics and Emerging technologies projects. Optimum has been successfully delivering IT projects since 1997 and has been a key IT service provider to clients delivering Software Design, Development, Engineering and IT Transformation Projects.
Role : Systems Programmer - Complex SQL Queries Writing
Key Requirements:
- Write and maintain programmable code outlined in technical instructions and specifications for software applications and operating systems.
- Overall must have 5+ years IT experience.
- Must have recent working experience in writing complex SQL queries for at least 3+ years.
- 4+ years recent working experience in a Financial Institution for Regulatory Reporting like MAS610, HKMA, BOT, Top20/100 etc. using reporting platforms like Axiom CV/Moodys/WKFS/Lombard Risk/Vermag/Markit/Bloomburg etc.
- Experience with Schedulers – preferably Control M.
- End to end data mapping specification experience is mandatory
- Recent 3+ years working experience Financial Institution or banking is a must.
- Strong working experience on MS SQL developer and advanced knowledge in writing complex sql queries
- Understanding on BOT RDT (Regulatory Data Transformation) Regulatory Reporting is preferred.
- CBAP/CCBA/ECBA/CFA or any equivalent certification is preferred
- Good understanding of core banking and treasury products and data requirement for management accounting or regulatory reporting
- Good understanding in SDLC phases
- Capability in requirement analysis and functional design skills
- Capability of self-learning and a quick learner
- Be adaptable, flexible and be able to thrive in a challenging, fast-paced of a growing organization / environment
- Experience with project management best practices/ methodologies/ project lifecycle
- Ability to develop and maintain productive working relationships with colleagues in distributed global locations
- Domain- Banking
