Experience:6-9 Years
Role: Developer
Key Skills:
· SQL, PL/SQL, MS SQL server & Business Intelligence
· Jenkins/Sonar, Control-M, UNIX/Linux Commands.
· Proficient with Batch & Power Shell scripting
Key Responsibilities:
· Analyse, develop, enhance, debug, support, maintain, test applications
· To develop projects/Change Requests related changes and to ensure deliverables are in good quality
· To participate in user requirements gathering and able to provide impact analysis and efforts estimation
· To develop functionalities to cater for business requirements using MS SQL server, Power BI and OneSumX product
· To design and build the Control-M jobs for batch processing
· To carry out unit testing and SIT on the developed functions
· To support UAT cycle, troubleshoot the issues and provide bug fixes
· To raise remedy ticket for required changes in controlled environments
· To migrate deliverables objects using Aldon migration tools to UAT/Production environment
· To provide proper documentation for all the deliverables
· To be able to work with team member, guiding junior staff and take responsibility for delivery of the code.
Key Requirements:
Education:
· Bachelors’ Degree in Computer Science or related field.
· At least 6 years’ relevant experience preferably in a Finance Institution.
Essential:
· You must be the experienced developer, with good experience in system integration/interfacing.
· You will typically be assigned to work on specific projects and is expected to support the Application Delivery.
· Manager (ADM) in all relevant technical matters, end-to-end, within the project.
· Depending on the project, your duties may include coding, scripting, building new systems (where necessary) and interfaces. For new system build-up, you may need to environment support during SIT/UAT.
· You are expected to ensure your work are adequately documented and transferred to the production team post-cutover.
· You will be expected to work with the senior developers and system architect in formulating technical solutions that is fit for purpose for your assigned projects. The solution will need to satisfy all security, regulatory and architectural standards.
· Working experience in MS SQL server & Business Intelligence development (and experience with WKFS RiskPro product is a plus).
· Working with RDBMS (Oracle, PL/SQL), WebSphere Application Server (WebSphere, Tomcat) and Jenkins/Sonar, Control-M, UNIX/Linux Commands.
· Proficient with Batch & Power Shell scripting
· Good understanding in Data Warehouse and Data Mart concept
· Experience in Performance tuning of queries