Strong DB2 Database skills (Stored procedures, triggers, indexing etc) - DB2, Data base development preferably Transact SQL MS SQL Server / Sybase - Performance Stored Procedure tuning T-SQL Refactoring - Handles complex data model - Sybase/DB2, Unix shell scripting, and Autosys. - Handson experience in Informatica Power center. - The system processes OTC derivatives data, listed derivatives, futures, options, repos, stock loan, and other instruments that carry counterparty risk. - Prior experience with financial data required.
Exposure to Agile technologies - Interest in Financial domain, mainly in Securities world (BO settlement, Swift) - 6-9 years experience in relational database technology (Sybase or DB2), including modeling, design, development, and tuning. - 3+ years Perl and/or Unix Shell scripting JOB RESPONSIBILITIES.
- Knowledge of Design patterns. Object oriented analysis and design with working knowledge of UML. Hands on work on design, development, implementation, support and optimization of application. Use object-oriented techniques and software engineering best practices including design review, code review, unit-testing, and re-factoring. - Participate in the gathering and reviewing of business requirements and translating into functional/technical specifications. - Work with global technical team, and work in tandem with a variety of stakeholders and personnel throughout organization. - Ability to work independently and Strong problem solving and analytic skills. - Self-motivated, goal oriented with high degree of accountability. - Experience with DB2.