Submit Resume

ETL Migration Engineer

  • Texas, Westlake

  • 06/05/2026

  • Contract

  • Active

Job Description:

  • Job Summary:
    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
    • Apache Airflow
    • 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
    • CI/CD pipelines
    • 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

.

.

.