ETL Migration Engineer Job Town of Texas Wisconsin USA,Software Development

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 Git Hub Copilot and Dev Assist 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, Open Tofu, 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:
Snap Logic
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 Git Hub Copilot or Dev Assist
Strong Python scripting and automation skills
Experience with AWS and Azure cloud platforms
Knowledge of Dev Ops tools and practices including:
Jenkins
Terraform/Open Tofu
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