Job Description:
Position Description:
Performs data integration using Extract Transform Load (ETL) patterns and develops data movement design patterns using Informatica. Designs software applications for Stock Plan Services (SPS). Performs real-time recordkeeping and generates reports using Business Intelligence (BI) features to build a modernized cloud-ready stack. Performs database development using PL/SQL for Oracle. Implements Cloud Computing and DevOps concepts automate application pipelines according to Continuous Integration/Continuous Delivery (CI/CD) methodologies (Git and Jenkins). 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.
Want more jobs like this?
Get Software Engineering jobs in Durham, NC delivered to your inbox every week.
Primary Responsibilities:
- Participates in architecture design teams.
- Defines and implements application-level architecture.
- 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.
- Establishes full project life cycle plans for complex projects across multiple platforms.
- 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.
- Acts as a primary liaison for business units to resolve various project/technology issues.
- Provides technology solutions to daily issues and technical evaluation estimates on technology initiatives.
- Advises senior management on technical strategy.
- 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:
No degree and seven (7) years of experience as a Principal Software Engineer/Developer (or closely related occupation) performing data integration and designing applications for Stock Plan Services using Informatica, Oracle PL/SQL, Business Intelligence (BI), and Power BI.
Or, alternatively, Bachelor's degree (or foreign education equivalent) in Accounting, Computer Science, Computer Information Systems, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and five (5) years of experience as a Principal Software Engineer/Developer (or closely related occupation) performing data integration and designing applications for Stock Plan Services using Informatica, Oracle PL/SQL, Business Intelligence (BI), and Power BI.
Or, alternatively, Master's degree (or foreign education equivalent) in Accounting, Computer Science, Computer Information Systems, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and three (3) years of experience as a Principal Software Engineer/Developer (or closely related occupation) performing data integration and designing applications for Stock Plan Services using Informatica, Oracle PL/SQL, Business Intelligence (BI), and Power BI.
Skills and Knowledge:
Candidate must also possess:
- Demonstrated Expertise ("DE") defining and designing Extract Transform Load (ETL) processes for data movement using Python, Informatica, PL/SQL, Oracle, TOAD, and SQL Developer; and sourcing, extracting, and normalizing enterprise level data to provide business and operational insights for Business Intelligence (BI) dashboards using Oracle Business Intelligence (OBIEE), Microsoft SQL Server Services, and Power BI.
- DE maintaining and communicating the state of automation executions and configuration setup of Jenkins, Git Stash, BitBucket and IBM UrbanCode by monitoring application changes - integration, testing, delivery, and deployment - according to Continuous Integration/Continuous Development (CI/CD) methodologies; performing batch job scheduling and dependency management for distributed systems; and monitoring and resolving job cycle issues using Control-M and Informatica Scheduler.
- DE coordinating with internal and external teams using Jira (for story writing and backlog prioritization) and ServiceNow (to plan change tickets); performing a production cut over and data migration plan and checklist to follow up task by task as a project manager; and migrating data frameworks and utilities from mainframe (including VSAM and DB2) to Oracle and Snowflake using Oracle PL/SQL and Informatica.
- DE designing disaster recovery and fail-over plans for micro-services distributed platforms and release deployments using DAAS; and planning and releasing validation plans for applications and databases connected to messaging, database, and replication components using GoldenGate, Azure, Oracle Exadata, and Unix or Linux shell (for scripting).
#PE1M2
Certifications:
Company Overview
Fidelity Investments is a privately held company with a mission to strengthen the financial well-being of our clients. We help people invest and plan for their future. We assist companies and non-profit organizations in delivering benefits to their employees. And we provide institutions and independent advisors with investment and technology solutions to help invest their own clients' money.
Join Us
At Fidelity, you'll find endless opportunities to build a meaningful career that positively impacts peoples' lives, including yours. You can take advantage of flexible benefits that support you through every stage of your career, empowering you to thrive at work and at home. Honored with a Glassdoor Employees' Choice Award, we have been recognized by our employees as a top 10 Best Place to Work in 2024. And you don't need a finance background to succeed at Fidelity-we offer a range of opportunities for learning so you can build the career you've always imagined.
Fidelity's working model blends the best of working offsite with maximizing time together in person to meet associate and business needs. Currently, most hybrid roles require associates to work onsite all business days of one assigned week per four-week period (beginning in September 2024, the requirement will be two full assigned weeks).
At Fidelity, we value honesty, integrity, and the safety of our associates and customers within a heavily regulated industry. Certain roles may require candidates to go through a preliminary credit check during the screening process. Candidates who are presented with a Fidelity offer will need to go through a background investigation, detailed in this document, and may be asked to provide additional documentation as requested. This investigation includes but is not limited to a criminal, civil litigations and regulatory review, employment, education, and credit review (role dependent). These investigations will account for 7 years or more of history, depending on the role. Where permitted by federal or state law, Fidelity will also conduct a pre-employment drug screen, which will review for the following substances: Amphetamines, THC (marijuana), cocaine, opiates, phencyclidine.
We invite you to Find Your Fidelity at fidelitycareers.com.
Fidelity Investments is an equal opportunity employer. We believe that the most effective way to attract, develop and retain a diverse workforce is to build an enduring culture of inclusion and belonging.
Fidelity will reasonably accommodate applicants with disabilities who need adjustments to participate in the application or interview process. To initiate a request for an accommodation, contact the HR Accommodation Team by sending an email to accommodations@fmr.com.