Senior Developer- Informatica Data Quality (IDQ/CDQ)

ODAIA; Toronto; On-site; CAD 110,000 - 150,000; Full time

Benefits offered by this job

Total Rewards Program

Flexible benefits

World-class training

Work-life balance options

Job summary

RBC is seeking a Senior Developer - Informatica Data Quality to implement enterprise data quality frameworks and improve trust in critical data assets. You will leverage Informatica products to monitor, validate, and enhance data quality across domains, working with SMEs to meet organizational objectives.

The role requires 3–6 years in data engineering/quality, strong SQL, and hands-on IDQ/CDQ experience, within an Agile environment.

Qualifications

• Bachelor's degree or equivalent.
• 3–6 years’ experience in data engineering or data quality engineering.
• 2-4 years hands-on experience using IICS designing ETL/ELT pipelines using CDI and CAI.
• Hands-on experience with Informatica Data quality or Cloud Data Quality.
• Experience with data profiling, cleansing, and validation frameworks.
• Strong SQL skills and data analysis capabilities.
• Understanding of data governance and metadata management concepts.

Responsibilities

• Implement data quality rules and monitoring frameworks for anomaly detection on large datasets.
• Utilize Informatica IDQ/CDQ for data profiling, cleansing tasks and build validation frameworks.
• Define data quality rules and KPIs with stakeholders; ensure data governance standards are met.
• Implement automated data validation checks across pipelines and develop remediation processes.
• Integrate data quality checks into ETL/ELT pipelines using IICS.
• Produce dashboards and reports highlighting data quality metrics.
• Collaborate to enhance data matching and standardization processes.
• Participate in an Agile development environment to meet deadlines.

Skills

Data quality engineering

Data engineering

SQL

Data profiling

Data governance

Metadata management

Education

Bachelor's degree or equivalent

Tools

Informatica IDQ/CDQ

IICS

Informatica Cloud Data Quality

CDGC (Data Lineage)

Job description

Job Description

WHAT IS THE OPPORTUNITY?

We are seeking a Senior Developer- Informatica Data Quality (IDQ/CDQ) responsible for implementing enterprise data quality frameworks and improving trust in enterprise data assets. The role will leverage Informatica suite of products to monitor, validate, and enhance data quality across critical data domains. The Data Engineer works with department and lines of business subject matter experts (SMEs) across the enterprise to meet departmental and organizational objectives. The engineer will follow end-to-end process standards and guidelines to ensure accurate and efficient build out of Data Quality architecture within project timeframes.

WHAT WILL YOU DO?

• Implement enterprise Data quality rules and monitoring frameworks for anomaly detection on large datasets.
• Utilize Informatica IDQ/CDQ to perform data profiling, data cleansing tasks and build validation frameworks
• Work with business stakeholders to define data quality rules and KPIs and build customized solutions and ensure data governance standards are met
• Implement automated data validation checks across pipelines and develop remediation processes for data quality issues.
• Integrate data quality checks into ETL/ELT pipelines using IICS.
• Produce dashboards and reports highlighting data quality metrics.
• Collaborate with team members to enhance data matching and standardization processes
• Participate in Agile development environment to meet project deadlines

WHAT DO YOU NEED TO SUCCEED?

Must have:

• Bachelor's Degree or equivalent
• 3–6 years’ experience in data engineering or data quality engineering.
• 2-4 years hands‑on experience using IICS designing ETL/ELT pipelines using CDI and CAI
• Hands‑on experience with Informatica Data quality or Cloud Data Quality .
• Experience with data profiling, cleansing, and validation frameworks.
• Strong SQL skills and data analysis capabilities.
• Understanding of data governance and metadata management concepts.

Nice‑to‑have

• Experience with data Lineage tools like CDGC
• Familiarity with regulatory data quality requirements in financial services.
• Experience integrating data quality rules into ETL pipelines.

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

Job Skills: Big Data Management, Cloud Computing, Database Development, Data Mining, Data Warehousing (DW), ETL Processing, Quality Management, Requirements Analysis, Software Product Management, Waterfall Model

Additional Job Details

Address: 180 WELLINGTON ST W:TORONTO

City: Toronto

Country: Canada

Work hours/week: 37.5

Employment Type: Full time

Platform: HUMAN RESOURCES & BMCC

Job Type: Regular

Pay Type: Salaried

Posted Date: 2026-08-13

Application Deadline: 2026-09-07

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

Our Employment Opportunities

At RBC, we are guided by living shared values of Client First, Integrity, Collaboration, Respect and Excellence and winning together as One 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.