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