Principal Software Engineer/Developer

Fidelity Investments•Durham, NC

9h•Hybrid

About The Position

Position Description: Designs, develops, and tests software and new functionalities for database batch job loaders. Researches, modifies, and tests applications supporting a complex reference data acquisition process for multiple fund accounting, decision support, and information management applications. Works with the production support team to analyze and identify the root cause of issues. Translates the vision for divisional initiatives into business solutions by developing complex or multiple software applications and conducting studies of alternatives. Analyzes and recommends changes in project development policies, procedures, standards, and strategies to development experts and management.

Requirements

Bachelor’s degree in Computer Science, Engineering, Information Technology, Information Systems, or a closely related field (or foreign education equivalent) and five (5) years of experience as a Principal Software Engineer/Developer (or closely related occupation) designing, developing, and testing software for complex database batch job loaders using SQL, PLSQL, and ETL Informatica.
Or, alternatively, Master’s degree in Computer Science, Engineering, Information Technology, Information Systems, or a closely related field (or foreign education equivalent) and three (3) years of experience as a Principal Software Engineer/Developer (or closely related occupation) designing, developing, and testing software for complex database batch job loaders using SQL, PLSQL, and ETL Informatica.
Demonstrated Expertise (“DE”) designing, developing, and optimizing high volume, low latency, distributed database applications, using PLSQL, and SQL within Oracle databases.
DE designing and developing data loaders to retrieve data from feed files, transform, and load in operational datastore and data warehouses using Oracle, Informatica, and Unix shell scripts.
DE establishing code quality processes using utPLSQL framework and SonarQube, and deploying Oracle database code, APIs, and ETL scripts using CI/CD pipelines, Jenkins, Stash, Bitbucket, Artifactory, Concourse, and U-Deploy.
DE tuning complex SQL queries to enhance system performance; and developing and enhancing UI screens for end users to manipulate data using SQL, and Oracle APEX.

Responsibilities

Participates in architecture design meetings.
Develops applications on complex projects, components, and subsystems for the division.
Recommends development testing tools and methodologies and reviews and validates test plans.
Responsible for QA readiness of software deliverables.
Develops comprehensive documentation for multiple applications or subsystems.
Responsible for meeting project goals on-time.
Advises on risk assessment and risk management strategies for projects.
Provides technology solutions to daily issues and technical evaluation estimates on technology initiatives.
Mentors junior team members.
Performs independent and complex technical and functional analysis for multiple projects supporting several divisional initiatives.
Develops creative technical solutions to on-going development efforts.