ETL Migration Engineer

As an ETL Migration Engineer, you will support our client’s Data Integration Engineering squad to migrate existing Informatica and SnapLogic workflows to a modern, cloud-native or open-source ETL platform. You will analyze and document ETL logic, categorize workflows, and create migration artifacts. You will automate repeatable tasks using Python, Groovy, Java, Jenkins, APIs, and shell scripting, and collaborate with architecture, data engineering, and business stakeholders to define sequencing and priorities. You will contribute to infrastructure as code deployments on AWS and Azure and provide on-call support during releases and incidents., * Execute ETL migration initiatives from Informatica and SnapLogic to modern ETL or open-source frameworks.

• Analyze, document, and categorize ETL workflows by complexity, domain, and criticality.
• Create migration inventories, source-to-target mappings, and transformation summaries.
• Develop automation to streamline migration and administration using Python, Groovy, Java, Jenkins, APIs, and shell scripts.
• Leverage developer-assistant tools to identify ETL patterns and translate them to target constructs.
• Partner with architecture, data engineering, and business teams to define sequencing and priorities.
• Configure and deploy solutions on AWS and Azure using Infrastructure as Code with Terraform or OpenTofu.
• Support release management, on-call rotation, and incident resolution.
• Apply Kubernetes and serverless patterns where appropriate.

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., * Proven ETL migration experience, including moving Informatica workflows to open-source or cloud-native frameworks.

• Strong knowledge of ETL architecture, data integration patterns, and relational data concepts.
• Hands-on Informatica experience as a developer or administrator.
• Proficiency with automation and scripting using Python and related tooling.
• Experience with DevOps pipelines and tooling such as Jenkins and Terraform or OpenTofu.
• Experience deploying in AWS and Azure, including Infrastructure as Code.
• Familiarity with Kubernetes and serverless architectures.
• Experience using AI developer-assistant tools to assess and translate ETL patterns.
• Strong communication and stakeholder management skills.
• Experience with on-call support, incident resolution, and release management.
• Bonus: Certifications in Informatica or other ETL tools, and certifications in Azure or AWS.

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. If anyone reaches out to you about an open position connected with Eliassen Group, please ensure that you are working directly with us by confirming the following:

When you work with Eliassen Group, all email communication will come from an Eliassen.com address, never Gmail, Yahoo, etc.

Eliassen Group is a strategic consulting firm that helps organizations reach further and achieve more through our technology, business advisory, and life sciences solutions. For nearly 40 years, we have combined exceptional people, deep domain expertise, and intelligent capabilities to expand our clients’ capacity and accelerate meaningful outcomes. We are driven by a purpose to positively impact the lives of our employees, clients, consultants, and the communities we serve.