ProvidenceRecruiter Since 2001
the smart solution for Providence jobs

Principal Software Engineer/Developer - 2020800

Company: Fidelity Investments
Location: Smithfield, RI
Posted on: April 2, 2021

Job Description:

Designs and programs Oracle databases, using PL/SQL, SQL, and Oracle. Optimizes query performance and database objects, using PL/SQL and SQL. Builds procedures, packages, functions, trigger views, cursors, and PL/SQL collections. Performs SQL Query tuning to improve system performance. Defines functions and transforms client's data using Informatica PowerCenter. Uses business knowledge to translate the vision for divisional initiatives into business solutions by developing complex or multiple software applications and conducting studies of alternatives. Analyzes and recommends changes in project development policies, procedures, standards, and strategies to development experts and management.

Primary Responsibilities:

Participates in architecture design teams.

Defines and implements application level architecture.

Develops applications on complex projects, components, and subsystems for the division.

Recommends development testing tools and methodologies and reviews and validates test plans.

Responsible for QA readiness of software deliverables.

Develops comprehensive documentation for multiple applications or subsystems.

Establishes full project life cycle plans for complex projects across multiple platforms.

Responsible for meeting project goals on-time and on-budget.

Advises on risk assessment and risk management strategies for projects.

Plans and coordinates project schedules and assignments for multiple projects.

Acts as a primary liaison for business units to resolve various project/technology issues.

Provides technology solutions to daily issues and technical evaluation estimates on technology initiatives.

Advises senior management on technical strategy.

Mentors junior team members.

Performs independent and complex technical and functional analysis for multiple projects supporting several divisional initiatives.

Develops original and creative technical solutions to on-going development efforts.

Education and Experience:

Bachelors degree (or foreign education equivalent) in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and five (5) years of experience in the job offered or five (5) years of experience developing Contract Management Systems and distributed platforms in the financial services.

Or, alternatively, Masters degree (or foreign education equivalent) in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and three (3) years of experience in the job offered or three (3) years of experience developing Contract Management Systems and distributed platforms in the financial services.

Skills and Knowledge:

Candidate must also possess:

Demonstrated Expertise (DE) developing dynamic Contract Management Systems to track product versions, orders, and audit history and data archival, using Informatica, Unix Shell Scripting, and Advanced Oracle PL/SQL programming.

DE designing logical and physical data models to implement scalable and efficient databases using advanced data structure concepts -- Binary Tree, Binary Search Tree, Graphs, and Entity Relationship; and performing tree operations -- tree traversal -- using advanced algorithms including, Order Tree, Post Order Tree, and Pre Order Tree Traversals.

DE implementing data storage designs using normalized forms -- Third Normal Form (3NF), Boyce-Codd Normal Form (BCNF), and Key Value Pair -- and denormalized forms; and defining system architecture and component interaction functionalities using Unified Modeling Language (UML) -- State Diagram, Flow Charts, and Sequence and Activity Diagrams.

DE in database performance tuning of complex Oracle PL/SQL queries by analyzing query plans and generating SQL Trace and TKProf; and performing maintenance activities -- gathering statistics, analyzing database objects, and conducting data profiling and data mappings.

For full job details and to apply, please visit https://jobs.fidelity.com and search for job number: 2020800.

Keywords: Fidelity Investments, Providence , Principal Software Engineer/Developer - 2020800, Finance , Smithfield, RI, Rhode Island


Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other Finance Jobs


Principal Software Engineer/Developer - 2019727
Description: Creates software service solutions using fundamental design principals for building scalable applications. Writes service layer code and guides junior engineers on design and hands on coding. Drives track (more...)
Company: Fidelity Investments
Location: Boston, MA
Posted on: 03/19/2021

Principal Software Engineer/Developer - 2020794
Description: Designs and builds end-to-end systems, using Java RESTful Web Services Java, J2EE, JUnit, and Tomcat and Open Source Frameworks Spring Boot and Spring Core . Integrates data API's using Oracle PL/SQL. (more...)
Company: Fidelity Investments
Location: Merrimack, NH
Posted on: 04/2/2021

Principal Software Engineer/Developer - 2020800
Description: Designs and programs Oracle databases, using PL/SQL, SQL, and Oracle. Optimizes query performance and database objects, using PL/SQL and SQL. Builds procedures, packages, functions, trigger views, cursors, (more...)
Company: Fidelity Investments
Location: Smithfield, RI
Posted on: 04/2/2021


Principal Software Engineer/Developer - 2020793
Description: Develops and implements business-critical desktop and mobile applications, including the integration of third-party tools and the creation of middleware applications. Programs Object-Oriented solutions (more...)
Company: Fidelity Investments
Location: Smithfield, RI
Posted on: 04/2/2021

Log In or Create An Account

Get the latest Rhode Island jobs by following @recnetRI on Twitter!

Providence RSS job feeds