ETL Migration Engineer
Role details
Job location
Tech stack
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