ETL Migration Engineer-- PARDC5769890

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)