ETL Migration Engineer

Compunnel, Inc.; Town of Texas (WI); On-site; USD 90,000 - 120,000; Full time

Job summary

Compunnel, Inc. is seeking an experienced ETL Migration Engineer to lead migration initiatives from legacy platforms to modern ETL solutions. You will analyze existing ETL architectures and implement automation solutions, utilizing AI-assisted tools and cloud technologies.

The ideal candidate should possess strong experience with Informatica, AWS, and Azure. Strong communication skills and a Bachelor’s Degree in a relevant field are preferred.

Qualifications

• Proven experience with ETL migration projects.
• Strong hands-on experience with Informatica.
• Experience with AWS and Azure cloud platforms.
• Strong communication and stakeholder management skills.
• Experience supporting production environments.

Responsibilities

• Lead ETL migration initiatives from legacy platforms.
• Design and implement scalable ETL solutions.
• Develop automation solutions using Python and related technologies.
• Collaborate with stakeholders to define migration strategies.
• Ensure data integrity and performance throughout the migration.

Skills

ETL migration projects

Informatica

AWS

Azure

Python

Kubernetes

AI-assisted developer tools

DevOps tools

Education

Bachelor’s Degree in Computer Science or related field

Tools

GitHub Copilot

Terraform

DevAssist

SnapLogic

Open-source ETL frameworks

Job description

We are seeking an experienced ETL Migration Engineer to support large-scale ETL modernization and migration initiatives. The ideal candidate will have hands-on experience migrating legacy ETL workflows, particularly Informatica-based solutions, to modern cloud-native or open-source ETL platforms. This role involves analyzing existing ETL architectures, automating migration processes, leveraging AI-assisted development tools, and collaborating with architecture, data engineering, and business teams to deliver scalable and efficient data integration solutions.

Key Responsibilities

• Lead ETL migration initiatives from legacy platforms (e.g., Informatica) to modern ETL frameworks and cloud-native solutions
• Analyze, document, and assess existing ETL workflows, mappings, and transformation logic
• Create migration inventories, source-to-target mappings, transformation documentation, and migration artifacts
• Categorize ETL processes by complexity, business domain, criticality, and migration priority
• Design and implement scalable ETL solutions using modern integration frameworks and cloud technologies
• Utilize AI-assisted development tools such as GitHub Copilot and DevAssist to accelerate migration activities and identify reusable patterns
• Develop automation solutions using Python, Groovy, Java, Shell Scripting, APIs, and related technologies
• Configure, deploy, and manage applications and ETL workloads in AWS and Azure environments
• Implement Infrastructure as Code (IaC) using Terraform, OpenTofu, or similar tools
• Support Kubernetes-based deployment and orchestration of ETL applications
• Design and support serverless architectures where applicable
• Collaborate with architecture, data engineering, and business stakeholders to define migration strategies and priorities
• Participate in release management, production support, and incident resolution activities
• Ensure data integrity, performance, and scalability throughout the migration lifecycle
• Drive continuous improvement through automation, standardization, and process optimization

Required Skills

• Proven experience with ETL migration projects involving migration from one ETL platform to another
• Strong hands-on experience with Informatica (Developer and/or Administrator)
• Experience migrating Informatica workflows to modern ETL platforms such as:
• SnapLogic
• dbt
• Open-source ETL frameworks
• Strong understanding of ETL architecture, data integration patterns, and relational databases
• Experience with Kubernetes
• Experience with AI-assisted developer tools such as GitHub Copilot or DevAssist
• Strong Python scripting and automation skills
• Experience with AWS and Azure cloud platforms
• Knowledge of DevOps tools and practices including:
• Jenkins
• Terraform/OpenTofu
• Experience implementing Infrastructure as Code (IaC)
• Knowledge of serverless architecture concepts
• Strong communication and stakeholder management skills
• Experience supporting production environments and handling incidents

Preferred Skills

• Experience with Groovy, Java, APIs, and Shell Scripting
• Certification in Informatica or other ETL technologies
• AWS or Azure Cloud Certifications
• Experience with cloud-native data integration frameworks
• Experience with migration automation and pattern-based ETL transformation
• Knowledge of release management and deployment best practices

Education

Bachelor’s Degree in Computer Science, Information Technology, Engineering, or related field preferred