Senior ETL Migration Engineer - Cloud

Fidelity InvestmentsMerrimack, NH
Hybrid

About The Position

As an ETL Migration engineer, you will work within the Data Integration Engineering squad on ETL processes migration to modern ETL tool. The Data Integration Engineering squad is a diverse, multi-functional team comprised of highly upbeat and motivated technologists who believe in the power of innovation and constant collaboration. The team blends technology & business expertise with a passion for exploring new technologies while working in an open and visible way. They believe that small, empowered, self-motivated teams can achieve extraordinary things. This is an opportunity to join the Data Movement, Data Integration Engineering squad, a diverse, open, and clear community where you will contribute to powering the next generation of Fidelity’s digital services through innovative solutions using the latest cloud native technologies and innovative engineering practices.

Requirements

  • Experience in ETL migration programs (e.g., Informatica to open source or modern ETL tools)
  • Proven hands-on experience with ETL Migration Initiatives, especially moving Informatica workflows to open-source or cloud-native integration frameworks; strong understanding of ETL architecture, data integration patterns and relational data concepts
  • Demonstrated hands-on experience using DevAssist or similar AI developer-assistant tools for use cases such as identifying patterns in ETL processes and translating them into target-platform constructs
  • Ability to analyze and document ETL logic, categorizing workflows by complexity, domain, criticality and create migration artifacts such as inventories, source-to-target mappings and transformation summaries
  • Innovation-first mindset with strong automation skills, using Python, Groovy, Java, Jenkins, APIs and/or shell scripting to streamline migration and administrative tasks and identify reusable patterns
  • Experience evaluating and adopting emerging tools, frameworks, or practices that improve engineering outcomes
  • Partner with architecture, data engineering, and business teams to define migration sequencing and priorities
  • Experience defining engineering standards, reference implementations, or shared frameworks adopted by multiple teams
  • Proven work experience with Informatica
  • Experience in configuring and deploying applications in public cloud like Azure / AWS using IAC tools like OpenTofu or Terraform
  • Very solid understanding and practical experience with implementing Infrastructure as Code
  • Excellent analytical skills to triage and resolve production issues and outages
  • Experience with on-call support, resolving incidents and release management practices
  • Strong communication and stakeholder management skills
  • Demonstrated ability to lead end-to-end delivery of complex initiatives across multiple teams or stakeholders
  • Experience partnering closely with product, operations, and platform users to shape technical priorities
  • Ability to mentor engineers, provide high-quality code and design reviews, and raise the technical bar for the broader team

Nice To Haves

  • Certification in Informatica or any other ETL tool
  • Certification in public cloud (Azure or AWS)
  • SnapLogic or any other open source ETL tool administration experience is a plus

Responsibilities

  • Work within the Data Integration Engineering squad on ETL processes migration to modern ETL tool
  • Analyze and document ETL logic, categorizing workflows by complexity, domain, criticality and create migration artifacts such as inventories, source-to-target mappings and transformation summaries
  • Streamline migration and administrative tasks and identify reusable patterns using Python, Groovy, Java, Jenkins, APIs and/or shell scripting
  • Evaluate and adopt emerging tools, frameworks, or practices that improve engineering outcomes
  • Partner with architecture, data engineering, and business teams to define migration sequencing and priorities
  • Define engineering standards, reference implementations, or shared frameworks adopted by multiple teams
  • Triage and resolve production issues and outages
  • Provide on-call support, resolving incidents and release management practices
  • Lead end-to-end delivery of complex initiatives across multiple teams or stakeholders
  • Partner closely with product, operations, and platform users to shape technical priorities
  • Mentor engineers, provide high-quality code and design reviews, and raise the technical bar for the broader team
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service