Senior Consultant - Informatica Data Integration & Cloud Migration | Sydney

Job Requisition ID: 38631 

• World class training and development. 

• Truly flexible work. 

• Hands-on mentoring on emerging technologies. 

What will your typical day look like? 

Deloitte Data and AI is changing the way that businesses leverage cloud-native technology to solve the toughest Data and AI challenges faced by our customers! Join us as we continue to expand into a cloud-centric Data and AI driven future, working on some of the largest and most complex projects within AU. 

About the team 

Our Data & AI team comprises of over 500 specialist practitioners across Australia, each of whom are constantly curious and excited about combining their business acumen and technological expertise to create data-centric solutions that help solve complex problems and transform or reinvent our client’s business. 

  Our Data & AI team work with public and private sector clients helping them to design and implement world leading solutions and capabilities. From solving air and ground transport network issues through our industry-first Optimal Reality digital twin solution, bringing automation capabilities to vaccine rollout programs, to helping our clients move to a sustainable world, we are the partner of choice for our clients and our alliance vendors.   

Our technology relationships with market leading vendors such as Amazon, Microsoft, Google, Apple, Snowflake, Salesforce, and Informatica enable our practitioners to be at the forefront of new and emerging capabilities and to deliver our suite of services at scale. We are consistently recognised as leaders in Cloud, Data, Analytics and AI, including in the latest analyst reports. 

Enough about us, let’s talk about you

We are seeking a skilled Informatica Information Management Engineer with strong experience in data integration and PowerCenter to Informatica Intelligent Data Management Cloud (IDMC) migrations using the PC2IDMC tool. The ideal candidate will be responsible for developing and maintaining ETL pipelines, managing data quality and governance processes, and leading the migration of legacy PowerCenter assets to the cloud.

Key Responsibilities:

• Lead and execute migration projects from Informatica PowerCenter to IDMC (IICS) using the PC2IDMC migration tool.
• Analyze existing PowerCenter mappings, workflows, and dependencies to assess cloud migration readiness.
• Design, develop, and optimize ETL processes in IDMC post-migration, ensuring parity and performance improvements.
• Troubleshoot and resolve issues during and after migration, ensuring minimal downtime and data loss.
• Collaborate with cross-functional teams including data architects, business analysts, and infrastructure teams to support migration strategy and implementation.
• Develop and maintain documentation on migration processes, mapping designs, and data integration flows.
• Perform data profiling, cleansing, and transformation using Informatica Data Quality (IDQ).
• Implement and support metadata management and data lineage using tools like Informatica EDC.
• Ensure all solutions meet compliance, data security, and governance requirements.
• Monitor ETL jobs and provide operational support for both legacy and modernized platforms.

Required Qualifications:

• Bachelor’s degree in computer science, Information Systems, or a related field.
• 4–8 years of hands-on experience with Informatica PowerCenter and/or IDMC (IICS).
• Proven experience in PC2IDMC tool-based migrations from PowerCenter to IDMC.
• Strong knowledge of ETL development, performance tuning, and workflow orchestration.
• Solid SQL skills and experience with relational databases (Oracle, SQL Server, PostgreSQL, etc.).
• Understanding of data warehousing concepts, dimensional modeling, and ETL best practices.
• Familiarity with cloud platforms (AWS, Azure, or GCP).
• Experience with job scheduling tools (e.g., Control-M).
• Excellent problem-solving, debugging, and analytical skills.
• Effective communication and documentation abilities.

Why Deloitte?

At Deloitte, we focus our energy on interesting and impactful work. We’re always learning, innovating and setting the standard; making a positive difference to our clients and our society. We put coaching at the heart of what we do, helping our people grow their careers in any direction – whether it be up, moving into something new, or even moving across the world.  

We embrace diversity, equity and inclusion. We have a diverse collection of people from different backgrounds, with different experiences, gender identities, abilities and thinking styles. What binds us together is a shared commitment to value everyone’s perspective and to cultivate inclusion; so that our work environment is a safe space we can all belong.  

We prioritise flexibility and choice. At Deloitte, you get trust on Day 1. We know our people get their best work done when they’re in control of where and how they work, designing their work week around their client, team and personal commitments.

We help you live and work well. To support your personal and professional life, we offer a range of perks and benefits, including retail discounts, wellbeing leave, paid volunteering days, twelve flexible working options, market-leading parental leave and return to work support package.  

Next Steps

Sound like the sort of role for you? Apply now, we’d love to hear from you!

By applying for this job, you’ll be assessed against the Deloitte Talent Standards. We’ve designed these standards so that you can grow in your career, and we can provide our clients with a consistent and exceptional Deloitte employee experience globally. The preferred candidate will be subject to background screening by Deloitte or by their external third-party provider.