Senior Data Engineer

Job Description :

Position Description :

Designs and develops resilient data infrastructure for 401k recordkeeping platform, including Oracle DB on Azure and Azure-managed services Data Factory, Storage Account, Azure Key Vault.

Develops generic data movement and data transformation Extract, Transform Load (ETL) frameworks using Shell Scripting, Control-M, Azure Data Factory, Oracle PL / SQL.

Develop deployment frameworks across environments and teams using uDeploy, Groovy scripting, and Jenkins.

Primary Responsibilities :

• Develops original and creative technical solutions to ongoing development efforts.
• Provides technical evaluation estimates on technology initiatives and serves as a technical expert for the team.
• Performs independent and complex technical and functional analysis and provides comprehensive documentation for multiple initiatives.
• Establishes project plans for projects of moderate scope.
• Works on complex assignments supporting multiple phases of a project, including testing, Production deployments and important maintenance activities.
• Responsible for post-installation testing / bug fixes of any problems and assists in the planning and conducting of user acceptance testing.
• Collaborate with stakeholders, both onshore and offshore, across the IT organization and business as needed and mentor junior team members.
• Develops deployment frameworks with several stages of automation, including configuration management and self-service deployments.

Education and Experience :

Bachelor s 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 as a Senior Data Engineer (or closely related occupation) designing resilient data infrastructure for 401k recordkeeping platform and delivering ETL solutions using Oracle and Azure technologies in a financial services environment.

Or, alternatively, Master s 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 as a Senior Data Engineer (or closely related occupation) designing resilient data infrastructure for 401k recordkeeping platform and delivering ETL solutions using Oracle and Azure technologies in a financial services environment.

Skills and Knowledge :

Candidate must also possess :

Demonstrated Expertise ( u201CDE u201D) setting up Oracle databases on Azure, provisioning Azure Data Factory (ADF) Infrastructure, and enabling data replication across multiple type of databases using Oracle GoldenGate or IBM Change Data Capture (CDC) to support the development of a 401k recordkeeping platform;

provisioning Azure services (Storage Accounts, Key Vaults, and Virtual Machines) using Infrastructure as Code (IaC) concepts.

DE building out the automated Continuous Integration / Continuous Delivery (CI / CD) deployment process, including self-service deployments and configuration management, using Git, Shell scripting, Groovy Scripting, Jenkins, or IBM UrbanCode Deploy for Oracle or Azure Data Factory objects;

building data movement frameworks from Mainframe to Azure using shell scripting, IBM z / OS Network File System (NFS) concepts (in Linux ecosystems), AzCopy utility, or Control-M.

• DE designing and implementing highly performant Oracle database PL / SQL packages and complex SQL queries to perform Extract, Transform and Load (ETL) operations;
• developing data transformation and ETL pipelines to migrate data across varied platforms (Mainframe system files and tables, Oracle tables, or Azure Storage Account files) using Informatica and Azure Data Factory;

executing unit testing, performance, and User Acceptance Testing (UAT) using SQL Developer, Toad, or Apache JMeter.

DE supporting rehydration and version upgrades using Azure Resource Manager (ARM); performing resiliency testing and periodic disaster recovery testing on several types of data components (Virtual Machines, Databases, Storage Accounts, IBM CDC or ETL pipelines present on Azure Data Factory or Control M).

Salary : u00A0 $126,850.00 - $136,850.00 / year.

Certifications : Company Overview

Company Overview

Fidelity Investments is a privately held company with a mission to strengthen the financial well-being of our clients. We help people invest and plan for their future.

We assist companies and non-profit organizations in delivering benefits to their employees. And we provide institutions and independent advisors with investment and technology solutions to help invest their own clients money.

Join Us

At Fidelity, you ll find endless opportunities to build a meaningful career that positively impacts peoples lives, including yours.

You can take advantage of flexible benefits that support you through every stage of your career, empowering you to thrive at work and at home. Honored with a

Glassdoor Employees Choice Award

we have been recognized by our employees as a top 10 Best Place to Work in 2024. And you don t need a finance background to succeed at Fidelity u2014we offer a range of opportunities for learning so you can build the career you ve always imagined.

Fidelity s hybrid working model

blends the best of both onsite and offsite work experiences. Working onsite is important for our business strategy and our culture.

We also value the benefits that working offsite offers associates. Most hybrid roles require associates to work onsite all business days of every other week in a Fidelity office.

At Fidelity, we value honesty, integrity, and the safety of our associates and customers within a heavily regulated industry .

Certain roles may require candidates to go through a preliminary credit check during the screening process. Candidates who are presented with a Fidelity offer will need to go through a background investigation,

detailed in this document

and may be asked to provide additional documentation as requested. This investigation includes but is not limited to a criminal, civil litigations and regulatory review, employment, education, and credit review (role dependent).

These investigations will account for 7 years or more of history, depending on the role. Where permitted by federal or state law, Fidelity will also conduct a pre-employment drug screen, which will review for the following substances : Amphetamines, THC (marijuana), cocaine, opiates, phencyclidine.

We invite you to Find Your Fidelity at

fidelitycareers.com

Fidelity Investments is an equal opportunity employer. We believe that the most effective way to attract, develop and retain a diverse workforce is to build an enduring culture of inclusion and belonging.

Fidelity will reasonably accommodate applicants with disabilities who need adjustments to participate in the application or interview process.

To initiate a request for an accommodation, contact the HR Accommodation Team by sending an email to

[email protected]