DurhamRecruiter Since 2001
the smart solution for Durham jobs

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


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!

Durham RSS job feeds