ETL Migration Engineer
Job Location:
Merrimack, NH - USA
Monthly Salary:
Posted:
Application Deadline:
Vacancies:
Job Summary
REQ. 3 (JOB#180858)
Title: ETL Migration Engineer
Client: Fidelity
Location: Westlake TX or Merrimack NH
Duration: 12 months
Rate: 65-75/hr on W2
Visa: USC GC GC-EAD & HE-EAD (EADs must have at least 12 months remaining before expiration.) (Locals only)
MOI: High chances that the final round will be onsite.
Bachelors (Date of completion) DOB (dd/mm) Last 4 SSN DL required.
What the Hiring Manager is Really Looking For- ETL Migration Engineer who has successfully migrated Informatica to another ETL platform.
- Strong Informatica expert who understands existing workflows deeply.
- Automation-focused engineer with Python Terraform Jenkins and AI-assisted tooling experience.
- Cloud-native engineer with AWS/Azure and Kubernetes exposure.
- Someone who can accelerate a large-scale ETL modernization initiative with minimal handholding.
Job Description:
As Fidelity moves from vendor ETL tools to a self built ETL engine we need to migrate thousands of existing data flows from Informatica and Snaplogic to this new tool.
Must have: ETL migration experience moving legacy ETL processes from one ETL vendor tool to another ETL vendor tool. (ideal candidate is migrating Informatica to another vendor Snaplogic Airflow DBT opensource) Proven informatica knowledge (administrator or developer) Kubernetes Dev assist tools (Co-pilot etc) AWS and Azure cloud Python scripting and automation experience Devops knowledge (Jenkins Terraform) Serverless architecture
ETL Migration Engineer
Do you enjoy working on ETL technologies and creating innovative solutions Do you want to collaborate with like-minded engineers across the globe As a ETL Migration engineer you will work within the Data Integration Engineering squad on ETL processes migration to modern ETL tool. We are 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. We believe that small empowered self-motivated teams can achieve extraordinary things.
The Expertise and Skills You Bring
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
Partner with architecture data engineering and business teams to define migration sequencing and priorities.
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.
Strong communication and stakeholder management skills.
Experience with on-call support resolving incidents and release management practices.
Bonus Skills
Certification in Informatica or any other ETL tool
Certification in public cloud (Azure or AWS)
The Team
This is an opportunity for a highly motivated ETL Migration Engineer to join Cloud and Platform Engineering Data Integration Engineering squad. We are a diverse open and clear community where you will supply to powering the next generation of Fidelitys digital services through innovative solutions using the latest cloud native technologies and innovative engineering practices.
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.
