Location: MA/ NH | Rate: Market | In person interview needed after phone !
Within the Database Group of Fixed Income (FI) division, we are looking for an individual contributor to develop database components using Oracle Pl/SQL, Informatica ETL and Autosys batch schedular. Primary responsibilities will include requirements analysis, data database designs using best practices and code development. This individual contributor role requires expert knowledge of Oracle PL/SQL, SQL, Informatica ETL and Shell scripting.
Experience with Fixed Income asset advisor is a plus. Data modeling experience is a plus as well.
Database Requirements Analysis
- Responsible for understanding, articulating, documenting and presenting DB requirements (both business and technical) on the assigned projects
- Interact with DB, Applications analysts and Business users for requirements gathering and validation
- Analyze/profile current data to ensure no requirements are missed
- Work with quality assurance team to build test plans to validate that new systems meet the business requirements
- Ensure that requirements are understood and handed off to offshore development teams if required
- Provide support to DB development teams on requirements related issues
Database Modeling
- Prepare DB logical and physical models based on requirements
- Review and obtain sign off on data models from architecture and other supporting organization
Database Design
- Apply best practices to come up with DB designs to meet or exceed business needs. Including but not limited to physical databases, schemas, table structures, indices, data marts, program structure, batch processing, performance, etc.
- Review and obtain approvals on designs through database design review boards
- Document designs and knowledge transfer to development team if required
- Ensure all non functional requirements are taken care of to provide a high quality operational system
Database Engineering/Development
- Design low level program structure and code program logic
- Conduct code reviews
- Develop unit test harness using UTPL/SQL and test programs
- Obtain Q/A sign off on the code and promote to integration test environment
- Performance tuning
- Develop batch jobs
- Develop data access layer for data access
Project, relationship and communication management
- Communicate with project leads and management
- Manage status reporting and problem escalation to project and database technology stakeholders where appropriate
- Identify risks, create risk management / mitigation / transfer plans and implement plans to contain risk
Qualifications
- Bachelor's degree required; MBA or MS preferred
- 10+ years experience in a large technology organization specialization on Database development, preferabaly in asset management firm
- Understanding of Fixed Income domain specifically around referece data
- Experience with Oracle Database 10g or higher
- Netezza experience is a plus but not required
Skills and Knowledge:
- Strong communication and influencing skills with demonstrated ability to interface with multiple levels as well as building productive working relationship in a matrix organization.
- Excellent written and verbal communication skills
- Ability to challenge status quo in a respectful manner
- Objectively listen, evaluate, and help others to see the way forward
- Excellent problem solving and decision making skills.
- Strong technical background and database engineerng skills and some experience with application designs
- Ability to quickly synthesize ideas, options, and thoughts into solutions to management to aid in decision making
- Highly motivated and energetic; able to juggle multiple priorities concurrently
- Strong Data and Requirements analysis skills
- Strong data modeling and DB normalization skills including OLTP, DW & DM
- Minimum 5+ ( 10 years desired) years of hand on development experience in the following areas
o Oracle PL/SQL
o Informatica
o PERL
o Unix
o Autosys
o Power Designer
Thanks & Regards,
Manoj
Abacus Software Division Inc.
121 Middlesex Turpike, #201, Burlington, MA 01803
Contact: 781-359-5211
The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer.
