Sr. Informatica IDMC MDM Software Engineer
Role details
Job location
Tech stack
Job description
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
Requirements
- 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, Active Learning, Agile Methodology, Application Integrations, CI/CD, Computer Programming, Detail-Oriented, Enterprise Application Delivery, ETL Development, ETL Tools, Group Problem Solving, Informatica MDM, Master Data Management (MDM), Microsoft SQL Server, Programming Languages, Software Development Life Cycle (SDLC), Structured Query Language (SQL) Development, Technical Designs
Benefits & conditions
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
