Principal Software Engineer/Developer - Durham, United States - Fidelity TalentSource LLC

Description

Job Description:

• Develops applications using Oracle SQL, PL/SQL, Oracle APEX
• Sets up and monitors batch jobs using Autosys scheduler
• Creates data pipelines, SOD data quality checks, and delivers reports/feeds to downstream applications
• Creates TABLEAU extracts, data source, and dashboards for reporting and analytics
• Deploys and maintains Spring Boot Application Program Interfaces (APIs) on AWS EC2 instances
• Establishes and maintains code quality using utPLSQL framework for test cases
• Establishes Continuous Integration/Continuous Delivery (CI/CD) of code using Bitbucket, Jenkins, Concourse pipelines, and uDeploy
• Uses business knowledge to translate 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 sessions
• Defines and implements application level architecture
• Develops applications on complex projects, components, and subsystems for the division
• Responsible for QA readiness of software deliverables
• Develops comprehensive documentation for multiple applications or subsystems
• Responsible for meeting project goals on-time and on-budget
• Advises on risk assessment and risk management strategies for projects
• Plans and coordinates project schedules and assignments for multiple 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 original and creative technical solutions to on-going development efforts

Education and Experience:

Bachelor's degree (or foreign education equivalent) in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and five (5) years of experience in the job offered or five (5) years of experience designing and developing databases using Oracle, Unix, and Autosys in a financial services environment

Alternatively, Master's 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 databases using Oracle, Unix, and Autosys in a financial services environment

Skills and Knowledge:

• Demonstrated Expertise performing Oracle PL/SQL and SQL tuning; developing Oracle databases using Snowflake, Oracle APEX, Informatica (for ETL), Linux shell scripts, and Autosys; and setting up and monitoring batch jobs using Autosys scheduler
• 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; tuning SQL queries to enhance cycle performance; and developing and enhancing UI screens for end users to manipulate data using SQL, and Oracle APEX
• Performing data profiling, extraction, cleansing, and analysis for large data warehouses using Oracle; designing conceptual and physical data models; generating visual insights for business and end users using Tableau reports; and establishing code quality processes using utPLSQL framework and SonarQube
• Developing data APIs to support varied application requirements using native AWS services (EMR, EC2, S3, and Cloud-formation); and deploying ETL scripts, Oracle DDL/DML statements, and PLSQL objects on CI/CD pipelines using Jenkins, BitBucket, Concourse, and uDeploy

Company Overview:

Fidelity Investments is committed to enhancing the financial well-being of its clients, offering investment and planning solutions. The company supports employee benefits delivery for organizations and provides investment and technology solutions for advisors. At Fidelity, you will discover a range of opportunities to build a fulfilling career, supported by flexible benefits allowing you to thrive both professionally and personally. Recognized with a Glassdoor Employees Choice Award, Fidelity is celebrated as one of the top 10 Best Places to Work in 2024. Join a culture that values honesty, integrity, and safety in a regulated industry. Fidelity promotes diversity and inclusion, accommodating applicants with disabilities during the application process. Explore career opportunities at fidelitycareers.com.