ETL Migration Engineer

Eliassen Group
Westlake, United States of America
1 month ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Compensation
$ 162K

Job location

Westlake, United States of America

Tech stack

Java
API
Amazon Web Services (AWS)
Azure
Information Engineering
ETL
Relational Databases
DevOps
Groovy
Python
Open Source Technology
Release Management
Shell Script
Terraform
Jenkins

Job description

The ETL Migration Engineer will lead migrations of legacy Informatica workflows to modern, cloud-native or open-source ETL platforms. The role will analyze, categorize, and convert ETL logic, build migration artifacts, and automate tasks with Python and DevOps tooling. You will collaborate with architecture and data engineering teams to sequence migrations and support deployment on AWS using infrastructure as code., * Migrate legacy ETL processes and Informatica workflows to modern ETL tools or open-source/cloud-native frameworks.

  • Analyze and document ETL logic, categorize workflows by complexity, domain, and criticality, and produce migration inventories and transformation summaries.
  • Create source-to-target mappings and migration artifacts that align with target platform constructs.
  • Leverage developer-assistant tools to identify patterns in ETL processes and accelerate translation to target platforms.
  • Automate migration and administrative tasks using Python, Groovy, Java, Jenkins, APIs, and shell scripting.
  • Partner with architecture, data engineering, and business stakeholders to define migration sequencing and priorities.
  • Configure and deploy solutions in AWS or Azure using Terraform or OpenTofu with Infrastructure as Code practices.
  • Provide on-call support, incident resolution, and release management for migrated workloads.

Requirements

Due to client requirements, applicants must be willing and able to work on a w2 basis. For our w2 consultants, we offer a great benefits package that includes Medical, Dental, and Vision benefits, 401k with company matching, and life insurance., * Hands-on ETL migration experience moving legacy ETL processes between vendor tools, preferably from Informatica to modern or open-source/cloud-native platforms.

  • Proven Informatica expertise as an administrator or developer.
  • Strong understanding of ETL architectures, data integration patterns, and relational data concepts.
  • Experience documenting ETL logic and building inventories, mappings, and transformation summaries.
  • Proficiency with Python for scripting and automation.
  • DevOps experience with Jenkins and Terraform or OpenTofu.
  • Experience using developer-assistant tools such as Copilot or similar.
  • Public cloud experience with AWS and/or Azure, including Infrastructure as Code implementation.
  • Strong communication and stakeholder management skills.
  • Experience with on-call support, incident resolution, and release management.
  • Certification in Informatica or other ETL tools (preferred).
  • Public cloud certification in AWS or Azure (preferred).

Education Requirements:

  • Informatica or other ETL tool certification (preferred).
  • AWS or Azure cloud certification (preferred).

Benefits & conditions

Skills, experience, and other compensable factors will be considered when determining pay rate. The pay range provided in this posting reflects a W2 hourly rate; other employment options may be available that may result in pay outside of the provided range.

W2 employees of Eliassen Group who are regularly scheduled to work 30 or more hours per week are eligible for the following benefits: medical (choice of 3 plans), dental, vision, pre-tax accounts, other voluntary benefits including life and disability insurance, 401(k) with match, and sick time if required by law in the worked-in state/locality. Please be advised- If anyone reaches out to you about an open position connected with Eliassen Group, please confirm that they have an Eliassen.com email address and never provide personal or financial information to anyone who is not clearly associated with Eliassen Group. If you have any indication of fraudulent activity, please contact .

About Eliassen Group

About the company

Eliassen Group is a leading strategic consulting company for human-powered solutions. For over 30 years, Eliassen has helped thousands of companies reach further and achieve more with their technology solutions, financial, risk & compliance, and advisory solutions, and clinical solutions. With offices from coast to coast and throughout Europe, Eliassen provides a local community presence, balanced with international reach. Eliassen Group strives to positively impact the lives of their employees, clients, consultants, and the communities in which they operate. Eliassen Group is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status. Don't miss out on our referral program! If we hire a candidate that you refer us to then you can be eligible for a $1,000 referral check!

Apply for this position