Informatica ETL Consultant

AI Job Summary

Minimum 2 years designing, developing, and implementing enterprise data integration solutions using Informatica IDMC.

Experience administering IDMC environments (mappings, taskflows, connectors, tenant configuration, platform optimization

Experience analyzing/reverse engineering ADF pipelines and WhereScape RED to understand current-state logic

Sign up or log in to analyse my fit

Role Type

Contract • Full-time • Mid-level Senior

Description

About the Opportunity

SimplyAI is seeking an experienced Senior Informatica IDMC Migration Consultant to support a large-scale enterprise data transformation programme.

This role will play a critical part in modernising an existing enterprise integration landscape by analysing legacy ETL implementations, designing modern ELT patterns and leading migration activities into the Informatica Intelligent Data Management Cloud (IDMC) platform.

Working alongside architects, engineers and governance specialists, you’ll help deliver a structured, low-risk migration programme with a strong focus on automation, reconciliation and production readiness.

About the Role

As the Informatica IDMC Migration Consultant, you will be responsible for assessing existing integration assets, designing migration approaches and delivering scalable cloud-native data integration solutions.

You’ll work across multiple migration waves while ensuring data quality, governance and operational excellence throughout the programme.

Key Responsibilities

Design, develop and implement enterprise data integration solutions using Informatica Intelligent Data Management Cloud (IDMC).

Configure and administer IDMC environments, including mappings, taskflows, connectors, tenant configuration and platform optimisation.

Analyse and reverse engineer existing Azure Data Factory (ADF) pipelines and WhereScape RED implementations to understand current-state integration logic.

Design modern ELT patterns that migrate legacy ETL processes into scalable IDMC-native architectures.

Build reusable migration frameworks and support automation wherever possible.

Lead data reconciliation activities including row-level validation, exception management and production cutover planning.

Develop migration runbooks, rollback procedures and technical documentation to support enterprise deployments.

Collaborate closely with Data Architects, Data Engineers, Governance teams and business stakeholders throughout the migration lifecycle.

Contribute to migration wave planning, execution and continuous improvement activities.

About You

You’ll be an experienced Data Integration Consultant who enjoys solving complex enterprise migration challenges and takes pride in delivering well-governed, high-quality data solutions.

We’re looking for experience with:

Informatica Intelligent Data Management Cloud (IDMC)

Informatica mappings, taskflows and connectors

Azure Data Factory (ADF)

WhereScape RED

ETL and ELT design patterns

Python and SQL

Enterprise Data Warehousing

Cloud Data Platforms (Azure, AWS or GCP)

Data reconciliation and validation methodologies

Migration planning and execution

Documentation and technical governance

Strong stakeholder engagement skills

Desirable Experience

Experience with one or more of the following would be highly regarded:

Informatica Cloud Data Governance & Catalogue (CDGC)

Collibra

Metadata management

Data lineage

Data governance frameworks

Enterprise migration programmes

Migration automation tooling (SimplyMigrate or similar)

Security, audit and compliance frameworks

Why Join SimplyAI?

At SimplyAI, we’re helping organisations transform the way they use Data and AI.

You’ll work alongside experienced consultants delivering enterprise-scale Data, AI and Cloud programmes across Australia while continuing to grow your own capability.

We offer:

Work on complex enterprise Data & AI transformation programmes

Exposure to modern cloud technologies and leading data platforms

Collaborative, highly experienced consulting teams

Professional development and certification support

Hybrid working arrangements

The opportunity to influence how Australia’s leading organisations modernise their data ecosystems

If you enjoy solving complex data integration challenges, modernising enterprise platforms and delivering migration programmes that genuinely make a difference, we’d love to hear from you.

Company Overview

At SimplyAI, we’re helping organisations navigate one of the most exciting transformations in business today, turning data and artificial intelligence into real-world outcomes. We are a specialist Australian consultancy focused on Data, AI and intelligent automation solutions. Our teams work with clients across a range of industries to design, build and deliver modern platforms that solve complex business problems, unlock efficiencies and enable better decision-making. But what truly sets SimplyAI apart isn’t just what we do – it’s how we do it. We are a Place to Build Your Career.