Designs and develops Oracle database components to support the
data needs of applications, using Informatica Power Center and
Oracle. Develops and supports AutoSys JIL scripts to add and update
batch jobs. Designs low level program structures and code program
logic. Develops ETL scripts using Informatica to integrate data in
an Oracle-based enterprise environment. Designs and develops
database components, using Java and Scala based middle-tier
services. Develops and supports Oracle Business Intelligence (OBI)
reports and dashboards using Oracle Business Intelligence
Develops original and creative technical solutions to on-going
Designs system requirements and technical designs for release
Provides business solutions by developing complex or multiple
Designs applications or subsystems on major projects and for/in
Develops applications for multiple projects supporting several
Supports and performs all phases of testing leading to
Assists in the planning and conducting of user acceptance
Develops comprehensive documentation for multiple applications
supporting several corporate initiatives.
Responsible for post-installation testing of any problems.
Establishes project plans for projects of moderate scope.
Works with product owners and business analysts to understand
business and technical requirements.
Supports multiple financial services applications, frameworks,
and infrastructure environments.
Works on complex assignments and often multiple phases of a
Performs independent and complex technical and functional
analysis for multiple projects supporting several initiatives.
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 three (3)
years of experience in the job offered or three (3) years of
experience designing and developing components to support data
analytics for trading, research, reporting, and portfolio
Or, alternatively, Masters 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 designing and developing components to
support data analytics for trading, research, reporting, and
portfolio management applications.
Skills and Knowledge:
Candidate must also possess:
Demonstrated Expertise (DE) developing reports -- Muni Money
market, Muni Bonds, and Net assets -- using OBIEE and Tableau
tools; developing data processing solutions, using Oracle 11g, 12c,
and PL/SQL with Toad and SQL Developer; performing ETL processes,
using Informatica Power Center, Perl, Python scripting, and UNIX
shell scripts; creating, managing, and scheduling batch jobs using
Autosys; and developing context and data flow diagrams using
DE integrating DevOps tools (Jenkins, Stash, Nexus, and uDeploy)
for automated deployments to build and promote Continuous
Integration and Continuous Delivery (CI/CD) practices.
DE extracting data from OLTP data stores and flat files and
loading the extracted data into warehouse environments -- asset
management and master data management warehouses -- using, ETL
processing, Informatica, and SQL*Loader; and performing database
design and development, using PL/SQL functions, stored procedures,
and packages in an OLTP and OLAP environment.
DE designing and developing portfolio management applications --
scripting, XML parsing, and writing PL/SQL queries -- using Java
and Event Driven Architecture.
For full job details and to apply, please visit
https://jobs.fidelity.com/ and search for job number: 2017018.