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, Wilson , Principal Software Engineer/Developer - 2008180, Finance , Durham, NC, North Carolina