Senior Software Engineer/Developer -1706727

Company: Fidelity Investments
Location: Durham, NC
Posted on: July 28, 2017

Job Description:

Duties: Provides business solutions by designing, developing, and

implementing data integration projects. Provides data and processes for

reporting platform. Performs ETL development within relational and

dimensional databases. Provides infrastructure support for Informatica and

large Oracle data warehouses. Develops high performing batch programs,

using UNIX scripting, Oracle, PL/SQL, SQL Tuning, Informatica, and data

modeling.

Primary Responsibilities:

• Provides infrastructure support for Informatica and large Oracle

ORD/ODS.

• Develops original and creative technical solutions to on-going

development efforts.

• Designs applications or subsystems on major projects and for/in

multiple platforms.

• Develops applications for multiple projects supporting several

divisional initiatives.

• Supports and performs all phases of testing leading to

implementation.

• Assists in the planning and conducting of user acceptance testing.

• Develops comprehensive documentation for multiple applications

supporting several corporate initiatives.

• Assists in the identification, isolation, resolution and

communication of problems within the production environment.

• Responsible for post-installation testing of any problems.

• Establishes project plans for projects of moderate scope.

• Works on complex assignments and often multiple phases of a project.

• Performs independent and complex technical and functional analysis

for multiple projects supporting several initiatives.

Requirements: Bachelor’s 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 in analysis,

design, and development of ETL batch jobs within a personal investment

application development environment; Or, alternatively, a Master’s degree

(or foreign education equivalent) in Computer Science, Engineering,

Information Technology, Information Systems, Mathematics, Physics, or a

closely related field and one (1) year of experience in the job offered or

one (1) year of experience in analysis, design, and development of ETL

batch jobs within a personal investment application development

environment. Candidate must also possess: Demonstrated Expertise (“DE”)

designing, implementing, and tuning complex database applications using

PL/SQL with TOAD and SQL Developer, including source code management and

version control using GIT Stash and Jira; DE in data extraction and

validation, including writing complex SQL queries within an Oracle Database

environment, tuning Informatica workflows and mappings, writing UNIX and

Korn shell scripts, scheduling jobs using Control-M, and tuning and writing

stored procedures for ETL jobs; DE implementing complex metadata design

using Dimensional Modelling and Relational Database Management Systems; DE

designing and developing OLTP systems using 3rd Normal Form (3NF) design

patterns, OLAP data warehouses, Business Intelligence solutions, data

modeling, and data marts according to Kimball and Inmon methodologies --

Star Schema and Operational Data Store (ODS).

To apply, visit http://jobs.fidelity.com and search for Job Number 1706727.

Keywords: Fidelity Investments, Durham , Senior Software Engineer/Developer -1706727 , Finance , Durham, NC, North Carolina