Hotlist-Hotlist Mutiple PL/SQL Developer needed for MA/ NH !!

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.