Job Description:
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.
Primary 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.
Education and Experience:
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.
Skills and Knowledge:
Candidate must also possess:
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.
#PE1M2
#LI-DNI
Certifications:
Category:
Information TechnologyMost roles at Fidelity are Hybrid, requiring associates to work onsite every other week (all business days, M-F) in a Fidelity office. This does not apply to Remote or fully Onsite roles.
Please be advised that Fidelity’s business is governed by the provisions of the Securities Exchange Act of 1934, the Investment Advisers Act of 1940, the Investment Company Act of 1940, ERISA, numerous state laws governing securities, investment and retirement-related financial activities and the rules and regulations of numerous self-regulatory organizations, including FINRA, among others. Those laws and regulations may restrict Fidelity from hiring and/or associating with individuals with certain Criminal Histories.