ETL Migration Engineer

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