Principal Software Engineer/Developer - 2018229
Company: Fidelity Investments
Location: Durham, NC
Posted on: February 19, 2021
Job Description:
Designs and implements Extract Transform and Load (ETL) and
Extract Load and Transform (ELT) processes by developing mappings
and workflows, using Informatica and Amazon Web Services (AWS) to
move data to and from on premise databases, Online Cloud systems,
and Snowflake. Designs and develops backend applications using
Oracle PL/SQL within a Master Data Management (MDM) based customer
profile system and Exadata based Customer Data Warehouse. Develops
Rest and Micro-services to retrieve and inject real time data to
and from online Cloud applications based on business user
requirements. Performs data profiling, mining, specification,
extraction, cleansing, and analysis for large databases, using
Oracle and Spark. 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 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: 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 Oracle database development within an Operational Data
Store (ODS) and data warehousing environment. Or alternatively, a 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 Oracle database
development within an Operational Data Store (ODS) and data
warehousing environment. Skills and Knowledge: Candidate must also possess: Demonstrated Expertise (DE) designing and developing backend
applications based on business user requirements using Oracle
PL/SQL to retrieve and inject real time data to and from online
applications using REST services; designing and developing Python,
Perl, Unix shell, and Oracle PL/SQL scripts to bulk load data from
data systems into data warehouses based on business user
requirements; tuning SQL queries for enhancing cycle performance;
and designing and developing Control-M jobs to automate and
schedule the end-to-end processes. DE designing and implementing Extract, Transform, and Load (ETL)
process by developing mappings and workflows using Informatica
tool; and developing Perl and UNIX shell scripts for processing ETL
workflows. DE designing and implementing ELT to process data to and from
Snowflake, online Cloud-based Customer Relationship Management
(CRM) applications, Salesforce, and Artificial Intelligence powered
reporting systems -- Einstein Analytics -- using Amazon Web
Services (AWS). DE performing data profiling, mining, specification, extraction,
cleansing, and analysis for large data warehouses, using Oracle,
Hadoop, and Spark; designing conceptual and physical data models,
using ER/Studio and IBM Rational Rose tools; and generating visual
insights using Oracle SQL reports for business and end users. For full job details and to apply, please visit
https://jobs.fidelity.com/ and search for job number: 2018229.
Keywords: Fidelity Investments, Durham , Principal Software Engineer/Developer - 2018229, Finance , Durham, NC, North Carolina