Performs end-to-end software development processes including,
software analysis, design, coding, system and user testing, problem
resolution, and planning, using Python and Unix shell scripting.
Develops core data structures -- building Online Transaction
Processing (OLTP) and warehousing applications in Oracle, using
PL/SQL and Oracle database. Provides business solutions by
developing complex or multiple software applications.
Develops original and creative technical solutions to on-going
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 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 Operational Data Store (ODS)
and warehousing applications within a Prime Brokerage environment
using Oracle PL/SQL.
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 Operational
Data Store (ODS) and warehousing applications within a Prime
Brokerage environment using Oracle PL/SQL.
Skills and Knowledge:
Candidate must also possess:
Demonstrated Expertise (DE) analyzing, architecting, modelling,
designing, and developing Oracle database applications, data
warehouses, and operational data stores within a UNIX environment,
using SQL Loader, SQL, and PL/SQL; creating design flows and ER
diagrams, using Visio, Python/Dash, and SQL Developer Data Modeler;
writing Oracle stored procedures, triggers, pipeline functions, and
bulk processing, using bulk collect and composite datatypes;
replicating, filtering, and transforming data from one database to
another using Golden Gate Replication; developing workflows to
integrate data across Oracle, SQL server, and Sybase; creating
batch jobs to process real-time high frequency, low latency locates
for hedge fund clients, using Advanced UNIX Shell and Python
DE performing SQL performance Tuning and Optimization (PTO)
using Oracle Enterprise Manager Grid control (OEM); collaborating
with enterprise infrastructure teams to diagnose end-to-end
database technology stack performance issues, using Oracle
Automatic Work Repository (AWR), Oracle Active Session History
(ASH), Automatic Database Diagnostic Monitor (ADDM), and SQL
monitor reports; performing database architecture -- designing
relational databases, performing indexing, partitioning, archiving,
and implementing enhanced database monitoring and alerting
solutions, using Linux Shell scripting, PL/SQL programs, and
DE performing application build and deployment using Continuous
Integration/Deployment (CI/CD) tools -- Jenkins, GIT and uDeploy;
performing Agile programming, and Scrum and Test Driven Development
(TDD), using JIRA and Artifactory; developing Machine Learning (ML)
models, using Pythons NumPy and Matplotlib; designing and
developing prime brokerage rules-based compliance reports, using
SQL Server RDL and Geneva RSL; developing secure file transfer,
using AXWAY and Amazon Web Services (AWS) Transfer Family with
lambda functions for event driven processing; and building
real-time data exchange pipelines using messaging frameworks --
Oracle Advance Queue, Tibco Rendezvous, IBM MQ, and Kafka.
For full job details and to apply, please visit
https://jobs.fidelity.com/ and search for job number 2039672.