C
ETL Migration Engineer-- PARDC5769890
Job Description
ETL Migration Engineer (3 identical openings)
This job is not a Data Engineer in the traditional sense. We are migrating away from Informatica and onto a new platform so we need to migrate the date flows and scripts to the new tool.
Must haves sin order of importance:
- ETL migration experience moving legacy ETL processes from one ETL vendor tool to another ETL vendor tool.
- (ideal candidate is migrating Informatica to another vendor. ie, Snaplogic, Airflow, DBT, opensource)
- Proven informatica knowledge (administrator or developer)
- AWS cloud
- Python scripting and automation experience
- Devops knowledge (Jenkins, Terraform)
- Dev assist tools (Co-pilot, etc)
Work to do:
- As an ETL Migration engineer, you will work within the Data Integration Engineering squad on ETL processes migrating ETL processes to a new modern ETL tool.
- This person will be migrating the ETL processes and workflows itself, not creating ETL workflows on data in a traditional data engineering sense.
The Expertise requred:
- Experience in ETL migration programs (e.g., Informatica to open source or modern ETL tools).
- Proven hands-on experience with ETL Migration Initiatives, especially moving Informatica workflows to open-source or cloud-native integration frameworks; strong understanding of ETL architecture, data integration patterns and relational data concepts.
- Demonstrated hands-on experience using DevAssist or similar AI developer-assistant tools for use cases such as identifying patterns in ETL processes and translating them into target-platform constructs.
- Ability to analyze and document ETL logic, categorizing workflows by complexity, domain, criticality and create migration artifacts such as inventories, source-to-target mappings and transformation summaries
- Innovation-first mindset with strong automation skills, using Python, Groovy, Java, Jenkins, APIs and/or shell scripting to streamline migration and administrative tasks and identify reusable patterns
- Partner with architecture, data engineering, and business teams to define migration sequencing and priorities.
- Proven work experience with Informatica.
- Experience in configuring and deploying applications in public cloud like Azure / AWS using IAC tools like OpenTofu or Terraform. Very solid understanding and practical experience with implementing Infrastructure as Code.
- Strong communication and stakeholder management skills.
- Experience with on-call support, resolving incidents and release management practices.
Certification plus point:
Certification in Informatica or any other ETL tool
Certification in public cloud (Azure or AWS)