RockyMountRecruiter Since 2001
the smart solution for Rocky Mount jobs

Principal Software Engineer/Developer - 2008180

Company: Fidelity Investments
Location: Durham, NC
Posted on: May 22, 2020

Job Description:

Develops and maintains applications that are used for plan administration and recordkeeping of Defined Contribution (DC) plans for Plan Sponsors. Ensures quality in all deliverables by having development teams follow best practices including structured, and well-documented code, complete unit, functional and integration testing, and code that meets architectural guidelines and business requirements by utilizing Informatica, UNIX Shell Scripting, Perl, and Control M. Serves as a technical leader within an Agile team delivering new capabilities for existing and emerging products.

Primary Responsibilities:

Partner with systems analysts, architects and developers to create solution design based requirements.

Develop solutions using Informatica, Oracle PL/SQL and other technologies as required.

Define and implement application level architecture.

Perform design and code reviews in conjunction with Continuous Integration & Continuous Delivery (CI/CD) practices.

Coordinate activities required for implementation of solutions into managed environments.

Provide technology solutions to daily issues and business initiatives.

Mentor junior team members.

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 five (5) years of experience in the job offered or five (5) years of experience performing ETL design and development using Informatica within an investment services environment.

Or, alternatively, Masters 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 performing ETL design and development using Informatica within an investment services environment.

Skills and Knowledge:

Candidate must also possess:

Demonstrated Expertise (DE) developing workflows for defined contribution or data warehouse environments, using Informatica PowerCenter or Web Methods; implementing workflows against Oracle, Microsoft SQL Server, DB2, and Sybase database environments; performing data loads, using VSAM, XML, Oracle, or DB2 sources; and creating and loading xml or flat files into relational databases using Informatica.

DE designing and implementing highly scalable, high performance ETL programs to move data from OLTP to OLAP, using stored procedures, functions, triggers, and cursors, within Oracle, SQL Server, and Sybase databases; writing and optimizing complex SQL queries for improved performance, using SQL Developer and TOAD; and performing data quality checks using Oracle EDQ.

DE creating scripts (using UNIX shell, BASH and PERL) and database procedures (using PL/SQL programming); and implementing load dependencies using Control-M, workflow scheduler, Windows scheduler, and Autosys; and developing Web applications using HTML5, CSS3, and JavaScript languages.

DE writing complex SQL queries to conduct financial data analysis for data extraction, using SQL Developer and Rapid SQL; performing data modeling using Erwin; and performing data mart design -- analyzing data models and designing database tables -- within a relational database environment (SQL Server, Oracle, or DB2).

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

Keywords: Fidelity Investments, Rocky Mount , Principal Software Engineer/Developer - 2008180, Finance , Durham, NC, North Carolina


Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Log In or Create An Account

Get the latest North Carolina jobs by following @recnetNC on Twitter!

Rocky Mount RSS job feeds