GMIS Oracle Developer Information

Job Details

[The logo is protected from the company]

(0) (0)

Barclays

Barclays Investment Bank (trading as Barclays, formerly Barclays Capital) is a British multinational investment bank headquartered in London, United Kingdom and a division of Barclays PLC. It provides financing and risk management services to large companies, institutions and government clients. It is a primary dealer in U.S. Treasury securities and various European Government bonds. Barclays Investment Bank has offices in over 29 countries and since the acquisition of Lehman Brothers' main ... Read More

Address	Level 28 One Raffles Quay South Tower Singapore 048583
Website	www.barcap.com/
Holding	No Holding Details

View Company Page

Apply to job

GMIS Oracle Developer

Main Accountabilities Analysis: Assistance as required in the requirements analysis for system enhancements and changes. Writing functional specifications if required. Design: Interpret and understand functional specifications Writing technical design documents adhering to predefined standards Design of physical data model from data model. Partner with Business Intelligence developer to ensure data model supports the reporting requirements where applicable. Code: Hands on development of quality (i.e. readable, performing and supportable) PL/SQL code on an Oracle 10g or 11g databases, delivering the functionality detailed in the technical specifications Hands on development of Autosys, Unix, and Perl scripts, delivering the functionality detailed in the technical specifications Ensuring code written meets the predefined company and department standards Performance Tuning: Tuning existing code to ensure acceptable application performance Review users queries to understand data access patterns and suggest enhancements to data model and/or indexing strategy Quality Assurance: Conducting peer reviews and providing constructive feedback Mentoring junior members of the team Testing: Preparation of detailed unit test cases Execution of unit test cases and documentation of results Providing support during QA and UAT test phases Diagnosis and resolution of defects found during QA and UAT test phases Support regression testing - investigate output differences. Implementation: Packaging up codes for release into production On implementation of releases, provide training to support team members Post-Implementation: Point of contact for support team, investigating and resolving issues found in production Communication Responsibilities Communicate directly with business analysts and project managers, understanding detailed business requirements at all stages of the development lifecycle Communicate effectively with business users to gain an in-depth understanding of new requirements and minor system changes Communicate effectively with the other external IT development teams and the local development manager. Work closely with global development team members in Singapore, London and New York participating in and contributing to technical discussions. Participate and contribute in technical discussions Technical Skills/Competencies: Essential Oracle 10g or 11g , PL/SQL, Database design, SQL performance tuning Hands on experience of Oracle based tools i.e. SQL Loader, Import/Export Data Pump Experience with Unix (preferably SOLARIS) / Linux and shell / Perl scripting languages Good understanding of Data Warehouse and Data Mart concepts with proven experience in both Ability to design and implement logical and physical data models Able to work well with IT developers in multiple locations. Hands on experience with ClearCase, Perforce or other source code control tools Knowledge of software development best practices Good knowledge of the software development life cycle Excellent problem solving skills. Analytical skills ability to investigate and resolve issues in a high-pressured environment Excellent written and verbal communication skills Ability to multitask Estimation Ability to train others. Preferred Working experience of an additional Database SQL Server Knowledge of ETL tools e.g. SSIS, Informatica Familiar with scheduling management technologies e.g. Autosys, Control M Working experience in an investment banking environment Understanding of Business Intelligence tools and concepts (i.e. Business Objects, Cognos, QlikView) Experience with logical modeling tools such as Enterprise Architect Experience with data modeling tools such as ER Studio and ERWIN Experience, qualifications and other requirements A bachelor degree in Computer Science, Software Engineering or related. Preferably 5 8 years of relevant experience. IB experience advantages but not a pre-requisite. Salary: Not Disclosed by Recruiter Industry: IT-Software / Software Services Functional Area: IT Software - Application Programming, Maintenance Role Category: Programming & Design Role: Software Developer Education: (UG - Any Graduate - Any Specialization, Graduation Not Required) AND (PG - Any Postgraduate - Any Specialization, Post Graduation Not Required) AND ( Doctorate - Any Doctorate - Any Specialization, Doctorate Not Required) Please refer to the Job description above