Sr. Informatica IDMC MDM Software Engineer

WHAT IS THE OPPORTUNITY?

We are seeking a skilled SaaS Informatica IDMC Master Data Management (MDM) professional to design, implement, and support cloud-based MDM solutions. The role focuses on delivering high-quality master data solutions using Informatica Intelligent Data Management Cloud (IDMC), with hands-on responsibility across Master Data Management (Saas), Cloud Data Integration (CDI), and Cloud Application Integration (CAI) ensuring data consistency, governance, and scalability across enterprise systems. Role will be involved with other existing and emerging technology platforms. Applies experience and seasoned knowledge, skills, and practices to perform a variety of assignments.

WHAT WILL YOU DO?

• Work with business analysts, data analysts, and product owner to understand requirement and develop solutions to solve business and technical problems.

• Design, develop, and implement Informatica MDM SaaS (IDMC) solutions

• Build and manage data models, configurations of Business 360 Console for MDM

• Configure match and merge rules, survivorship, hierarchies, and business entities

• Develop batch integrations using IDMC Cloud Data Integration (CDI) services

• Implement data quality, validation, and governance rules

• Integrate MDM with downstream and upstream systems using APIs, ETL, and cloud connectors

• Lead or support platform enablement and training, ensuring development teams, data stewards, and business users are equipped to effectively use and adopt the platform.

• Develop and support integrations using Cloud Data Integration (CDI) for batch and near-real-time data movement.

• Implement API-led and event-driven integrations using Cloud Application Integration (CAI).

• Collaborate with business stakeholders to gather and translate requirements into technical solutions

• Support data migration, onboarding, and reconciliation activities

• Monitor, troubleshoot, and optimize performance and data accuracy

• Participate in UAT, production deployments, and post-go-live support

• Ensure compliance with data governance, security, and privacy standard

WHAT DO YOU NEED TO SUCCEED?

Must have:

• Bachelor's degree in any discipline

• Strong hands-on experience with Informatica MDM SaaS / IDMC

• Ability to build batch integrations using CDI with variety of source and target systems, including databases, flat files, Kafka topics, snowflake etc

• Hands on experience building Cloud Application Integration (CAI) processes, APIs, and enrichment processes for MDM SaaS

• Experience in CICD automation with IDMC services

• Solid understanding of Master Data concepts (Customer, Product, Supplier, etc.)

• Experience with match & merge, survivorship, and hierarchy management

• Proficiency in SQL, data analysis, xQuery and shell scripting

• Experience with REST APIs, cloud integrations, and ETL tools

• Programming experience with XQuery and XPath, desirable for implementing transformations and orchestration logic within Informatica Cloud Application Integration (CAI).

• Knowledge of data quality and governance frameworks

• Familiarity with cloud platforms (AWS, Azure, or GCP)

• Strong analytical, problem-solving, and communication skills

• Experience with debugging, monitoring, performance tuning of IDMC services

Nice-to-have:

• Informatica MDM or IDMC certification

• Experience in multi-domain MDM implementations

• Exposure to Agile/Scrum delivery models

• Experience with Jira

What's in it for you?

We thrive on the challenge to be our best, progressive thinking to keep growing, and working together to deliver trusted advice to help our clients thrive and communities prosper. We care about each other, reaching our potential, making a difference to our communities, and achieving success that is mutual.

• A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation, commissions, and stock where applicable.

• Leaders who support your development through coaching and managing opportunities.

• Ability to make a difference and lasting impact.

• Work in a dynamic, collaborative, progressive, and high-performing team.

• A world-class training program in financial services.

• Flexible work/life balance options.

• Opportunities to do challenging work.

The expected salary range for this particular position is $80,000-$140,000, depending on your experience, skills, and registration status, market conditions and business needs.

You have the potential to earn more through RBC's discretionary variable compensation program which gives you an opportunity to increase your total compensation, provided the business meets its performance targets and you meet your individual goals.

RBC's compensation philosophy and principles recognize the importance of a highly qualified global workforce and plays a critical role in attracting, engaging and retaining talent that:

• Drives RBC's high-performance culture.

• Enables collective achievement of our strategic goals.

• Generates sustainable shareholder returns and above market shareholder value.

#TechPJ

#LI-Post

Job Skills

Additional Job Details

Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above

Inclusion and Equal Opportunity Employment

At RBC, we believe an inclusive workplace that has diverse perspectives is core to our continued growth as one of the largest and most successful banks in the world. Maintaining a workplace where our employees feel supported to perform at their best, effectively collaborate, drive innovation, and grow professionally helps to bring our Purpose to life and create value for our clients and communities. RBC strives to deliver this through policies and programs intended to foster a workplace based on respect, belonging and opportunity for all.

RBC is presently inviting candidates to apply for this existing vacancy. Applying to this posting allows you to express your interest in this current career opportunity at RBC. Qualified applicants may be contacted to review their resume in more detail.