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