Senior Software Engineer/Developer - 2041915

Company: Fidelity Investments
Location: Jersey City, NJ
Posted on: December 17, 2021

Job Description:

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.

Primary Responsibilities:

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.

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.

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 scripting.

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 Control-M scheduler.

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: 2041915.

Keywords: Fidelity Investments, Jersey City , Senior Software Engineer/Developer - 2041915, Finance , Jersey City, NJ, New Jersey