Previous Job
Senior DB Manager
Ref No.: 17-00890
Company/Department:Fidelity Investments (New Hampshire)
Location: Merrimack, New Hampshire
Position Type:Contract to Hire
Start Date: 11/17/2017
 We are seeking a senior software engineer with background in developing and deploying enterprise class code in Oracle.
Experience developing stored procedures, triggers using  PL/SQL, designing tables and knowledge of Informatica is a must.  The successful candidate must have strong organizational, communication and presentation skills. The candidate should be able to define, package, and use of consistent designs and standards.  Experience tuning performance in queries will be a significant plus. Being a highly motivated and responsive team player who can multi-task and work under minimal supervision is a must.
CLRRS (Compliance, Legal, Risk. RIM and Security), a division within CTG (Corporate Technology Group), is responsible for the IT products supporting key enterprise functions within Fidelity.   This position will be part of the Employee Compliance product team servicing the Corporate Compliance business unit and be responsible for developing software applications to ensure Fidelity Investments' compliance with SEC and Client regulations pertaining to employee code of ethics.  We are undertaking multiyear initiatives to transform our business partner's process with significant functionality and tools for compliance oversight. The projects include working with our data providers, business partners, User Interface and middle-tier developers.
Primary Responsibilities
  • Develop, enhance and deploy software using Oracle PL/SQL and Informatica
  • Developing release plans, release content and delivery schedules
  • Provide implementation and operational support for component customers
  • Create technical, test case, transition and operational documents
  • Collaborate with stake holders, both onshore & offshore, across the IT organization and business as needed
Education and Experience
  • A Bachelor's degree in computer science
  • 5 plus years of development experience in Oracle PL/SQL, ETL, and reporting technologies
Skills and Knowledge
  • Design experience building back end code against relational and star schemas
  • Strong knowledge of database patterns.
  • Proven experience in many of the following:
    • Oracle PL/SQL, Stored procedures, triggers
    • Performance tuning queries using SQL plans, XPLANs etc.
    • Experience using EZPaaS DI is a plus
    • Experience developing Informatica ETL mappings
    • Experience performing data analysis and design for small to medium size requirements
  • Experience with a structured application development methodology. Agile and product development experience a plus
  • Ability to handle multiple deliverables across
  • A "Can Do” attitude and ability to work in a highly matrixed environment
  • Excellent written and oral communication skills
  • Excellent problem-solving skills
  • Experience building solutions for mobile platform with responsive design patterns is a plus
  • Experience using STASH or GITHUB for source code
  • Knowledge of enterprise clouds/virtual environments and platform as a service is a plus