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

#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

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.

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.