Talent.com
Fidelity Investments
Senior Data EngineerFidelity Investments • Merrimack, NH, US
Senior Data Engineer

Senior Data Engineer

Fidelity Investments • Merrimack, NH, US
30+ days ago
Job type
  • Full-time
Job description

Job Description

:

Position Description :

Designs and develops data warehouse enterprise applications for reporting and analytics, using SQL, Java .Net, and Python. Creates and migrates Extract, Transform, Load (ETL) code and workflow mappings in Informatica to Amazon Web Services (AWS) Data Lake and Wherescape Red ETL. Develops OBIEE reports and configures Business Intelligence (BI) scheduler. Deploys code and services to AWS by establishing Continuous Integration and Continuous Delivery (CI/CD) pipelines using Cloud-based data platforms — Oracle, NoSQL, Snowflake, and Graph databases (for analytics data hosting). Supports and maintains software applications in DEV and SIT environments.

Primary Responsibilities:

  • Builds, enhances, and supports data and analytics software solutions.
  • Writes complex SQL queries on Oracle (PL/SQL).
  • Performs optimization and SQL tuning.
  • Designs and develops complex applications using large data sets and ETL strategies.
  • Distributes applications using Java, .Net, and Python.
  • Implements Software as a Service (SaaS) solutions.
  • Develops and manages Collibra for enterprise governance activities.
  • Develops software system testing and validation procedures, programming, and documentation.
  • Supports and maintains software applications in DEV and SIT environments.
  • Proposes modifications and improvements based on user need.
  • Provides L3 support in an Agile environment.
  • Analyzes information to determine, recommend, and plan computer software specifications on major projects.

Education and Experience :

Bachelor’s degree (or foreign education equivalent) in Computer Science, Computer Information Systems, Computer Information Systems and Information Technology, Engineering, Information Technology, Mathematics, Physics or a closely related field and three (3) years of experience as a Senior Data Engineer (or closely related occupation) performing Informatica ETL and Oracle database development to support HR data engineering capabilities in a financial services environment.

Or, alternatively, Master’s degree (or foreign education equivalent) in Computer Science, Computer Information Systems, Computer Information Systems and Information Technology, Engineering, Information Technology, Mathematics, Physics or a closely related field and one (1) year of experience as a Senior Data Engineer (or closely related occupation) performing Informatica ETL and Oracle database development to support HR data engineering capabilities in a financial services environment.

Skills and Knowledge :

Candidate must also possess:

  • Demonstrated Expertise (“DE”) working as a member of a data engineering team responsible for developing high quality data solutions in a multi-developer Agile environment according to design and coding best practices; developing ELT pipelines to migrate data to and from Snowflake data store, using WhereScape Red, Python, and Snowflake; and loading data from flat files and JSON into Snowflake using SnowSQL.
  • DE performing code migrations, using GitHub, Jenkins, and Control-M scheduler; and performing SQL performance optimization for 1+ TB size data volumes.
  • DE performing ETL operations, using Informatica Power Center and Metadata Manager; developing data masking solutions using Unix shell script; and creating functional and technical design mapping templates and solutions for data migrations using Workday I Loads.
  • DE performing data profiling and analysis using Informatica Data Quality; preparing, analyzing, and portraying business metrics using BI reporting tools — OBIEE and Power BI; performing data profiling and analysis using Informatica Data Quality (IDQ); and pre-processing data to identify macro trends or information — out-of-range values — in Snowflake using SnowPipe loaded xml files.

#PE1M2

Certifications:

Create a job alert for this search

Senior Data Engineer • Merrimack, NH, US

Similar jobs

Senior Quality Systems Engineer

DEKA Research & DevelopmentManchester, NH, US
Full-time
Quick Apply

DEKA is hiring a Senior Quality Systems Engineer to own the system-level work that keeps our QMS audit-ready.As a Senior Quality Systems Engineer, you'll be working closely with the QA & Compli... Show more

Remote Side Hustle Evaluator - Flexible Online Gig Work

Finance BuzzStrafford, New Hampshire, US
Remote
Part-time

Are you looking to earn extra income from the comfort of your home? We're seeking motivated individuals to explore and test a variety of remote side hustle opportunities featured on FinanceBuzz.Thi... Show more

 • Promoted • New!

Sales Engineer, SLED

FortinetManchester, New Hampshire, United States
Full-time

We are looking for a Systems Engineer, SLED to work closely with a Named Account Manager, SLED in a defined territory.The Systems Engineer's main mission will be to support the sales organization i... Show more

 • Promoted

Machine Learning Engineer

DEKA Research and DevelopmentManchester, New Hampshire, United States
Full-time

We're looking for a Machine Learning Engineer who can operate at the intersection of backend engineering and applied machine learning.If you want to design distributed systems, deploy production ML... Show more

 • Promoted

Data Entry Product Support - No Experience

GLOCPABelmont, New Hampshire
$15.00 hourly
Part-time +1

Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.We guarantee 15-25 hours per week with an hourly pay of bet... Show more

 • Promoted

Sales Engineer

EGN Technical ResourcesManchester, NH, United States
Full-time

The purpose of this role is to drive revenue growth and expand market presence across the assigned Northeast US territory by delivering high-level technical consultation on position sensors and enc... Show more

 • Promoted

Lead Data Scientist- Lowell / Remote (within 75- miles radius)

UKG, Inc.Lowell, MA, United States
Remote
Full-time

Why UKG :At UKG, the work you do matters.The code you ship, the decisions you make, and the care you show a customer all add up to real impact.Today, tens of millions of workers start and end their... Show more

 • Promoted

Data Scientist II - Global Sales (REMOTE)

Charles River Laboratories, Inc.Wilmington, MA, United States
Remote
Full-time

For 75 years, Charles River employees have worked together to assist in the discovery, development and safe manufacture of new drug therapies.When you join our family, you will have a significant i... Show more

 • Promoted

Political Affairs Internship Part-Time in Worldwide - Remote Worldwide - Political Team

The Borgen ProjectPembroke, New Hampshire, United States
Remote
Part-time +1

Are you passionate about making a difference in the world? Look no further! The Borgen Project is an international organization that works at the political level to improve living conditions for pe... Show more

 • Promoted

Senior Quality Engineer

CoreMapBurlington, MA, United States
Full-time

CoreMap’s mission is to improve the lives of people affected by atrial fibrillation.We are developing a highresolution, real-time, 3D electroanatomical mapping system for use during cardiac procedu... Show more

 • Promoted

Senior Director, Demand Generation

Progress SoftwareBurlington, MA, United States
Full-time

We are Progress (Nasdaq: PRGS) – the trusted provider of software that enables our customers to develop, deploy and manage responsible, AI‑powered applications and experiences with agility and ease... Show more

 • Promoted

Senior Director, Demand Generation

Progress Software CorporationBurlington, MA, United States
Full-time

We are Progress (Nasdaq: PRGS) - the trusted provider of software that enables our customers to develop, deploy and manage responsible, AI‑powered applications and experiences with agility and ease... Show more

 • Promoted

Data Entry Lead 2346805 | Chelmsford, MA

divvyDOSEChelmsford, MA, United States
Full-time

Medical Billing Operations Coordinator.This position follows a hybrid schedule with (4) days per week in-office days per week.Our office is located at 300 Apollo Dr, Chelmsford, Massachusetts, 1824... Show more

 • Promoted

M365 Engineer

MSP Hire, Inc.Burlington, MA, US
$150,000.00 yearly
Full-time +1
Quick Apply

Daymark Solutions  is an experienced technology integration and solutions provider that helps organizations effectively architect, implement, and deploy customized solutions using best of... Show more

Senior Software Engineer II - Autonomy Systems

Scientific Systems Company, Inc.Burlington, MA, US
$142,000.00 yearly
Full-time
Quick Apply

The Senior Software Engineer will be responsible for developing and supporting software for advanced AI/Autonomy technologies for collaborative, autonomous mission systems operating in multiple dom... Show more

Senior Mechatronics Engineer

Boston MaterialsBillerica, Massachusetts, United States, 01821
$120,000.00 yearly
Full-time

Boston Materials produces advanced materials with enhanced energy transfer properties using its patented Z-axis Carbon Fiber technology.The Company's products solve critical performance bottlenecks... Show more

Senior Systems Engineer, UDS Data Management - East

DellNorth Billerica, MA, United States
Full-time

Senior Systems Engineer, Data ManagementOur field sales professionals rely on proactive technical support during the sales process – and our expert Systems Engineering team always steps up to the m... Show more

 • Promoted • New!

M-78-Data Architect 144227.

FHRLowell, MA, US
Temporary
Quick Apply

Data Architect (Job ID: 144227).Location: Hybrid – Augusta, ME (Onsite once per month; candidates in New England preferred).Travel: Client does not cover travel expensesOur direct client in Augusta... Show more

Global QC Labs Performance and Data Analytics Lead - Remote

MilliporeSigmaBurlington, MA, United States
Remote
Full-time

Global QC Labs Performance and Data Analytics Lead - Remote Join to apply for the Global QC Labs Performance and Data Analytics Lead - Remote role at MilliporeSigma.Work Your Magic with us! Start y... Show more

 • Promoted

Senior Foundry Engineer

Success Matcher RecruitmentBillerica, Massachusetts, United States
Full-time
Quick Apply

Our client is building the future of American industrial power by developing fully automated investment casting foundries.In an era where demand for precision metal castings is skyrocketing but dom... Show more