Senior Systems Analyst - 2077247

Company: Fidelity Investments
Location: Durham, North Carolina
Posted on: May 24, 2023

Job Description:

Designs innovative solutions, improves efficiency through automation, and delivers data solutions using ETL tools and databases. Performs batch job scheduling and dependency management using BMC Control-M for distributed systems. Ensures data integration and designs data movement patterns using Informatica and ETL. Builds data models supporting complex transformation. Executes analysis for medium-sized projects. Documents requirements and creates specifications and makes design recommendations for medium-sized projects.

Primary Responsibilities:

Works with business partners and technology partners to identify, review, define, interpret, and clarify scope of work in terms of business and/or system requirements and processes.

Contributes to the analysis strategy for technology projects culminating in the creation of documentation to support project needs.

Recommends changes to existing systems design to achieve requirements and recommends designs for new systems based on requirements.

Monitors documentation standards and best practices.

Recommends traceability improvements.

Establishes project plans for projects of moderate scope.

Works directly with the user community for project definition.

Communicates project plan information, objectives, and deliverables to the team.

Assists in defining analysis strategy.

Identifies and records risks, issues, dependencies, and assumptions in accordance with project standards.

Participates in the review and validation of Quality Assurance test plans to ensure requirements have been met.

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 developing data integration and movement patterns using Informatica, Oracle, and CONTROL-M.

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 developing data integration and movement patterns using Informatica, Oracle, and CONTROL-M.

Skills and Knowledge:

Candidate must also possess:

Demonstrated Expertise (DE) developing and implementing large-scale Data Warehouse (DW) and Business Intelligence (BI) solutions in a distributed development environment; performing the entire Extract, Transform, and Load (ETL) development cycle (ideating feasible solutions to ETL challenges and implementation) using Informatica.

DE designing and configuring stored procedures, functions, constraints, indexes, and cursors using PL/SQL server coding conventions; and designing common stored procedures for data loading using Oracle SQL Developer, SQL Server, and TOAD.

DE performing batch job scheduling and dependency management for distributed systems; and monitoring and resolving job cycle issues using Control-M, Automic Engine and Informatica Scheduler.

DE monitoring application changes (integration, testing, delivery, and deployment) to maintain and communicate the state of automation executions; and configuring the setup for Continuous Integration/Continuous Development (CI/CD) pipelines using Jenkins and Git.

For full job details and to apply, please visit https://jobs.fidelity.com/ and search for job number: 2077247

Keywords: Fidelity Investments, Durham , Senior Systems Analyst - 2077247, Finance , Durham, North Carolina, North Carolina