4 days ago
Toronto, CanadaMid Level / Senior
Responsibilities
- Design and implement data ingestion and transformation pipelines.
- Develop ETL workflows using Informatica IICS and build transformation models with dbt.
- Develop optimized SQL transformations for large datasets.
- Implement data quality checks and validation logic within ETL pipelines.
- Monitor data pipelines and troubleshoot production issues.
- Collaborate with data analysts, architects, and enterprise subject matter experts on scalable data models.
- Document data lineage, transformations, and technical architecture.
- Participate in Agile development processes and code reviews.
Requirements
- Bachelor’s degree in a related field such as Computer Science, Business, or Engineering, or equivalent experience.
- 3–6 years of experience in data engineering or ETL development.
- Hands-on experience with Informatica ETL tools and experience with dbt and ELT-based transformation frameworks.
- Strong SQL skills and understanding of data modeling concepts.
- Experience with enterprise data warehouses or cloud platforms.
- Experience with Git, testing frameworks, and CI/CD pipelines.
- Experience working in Agile engineering environments.
- Nice-to-have experience with Snowflake, Databricks, Python, Airflow, Control-M, or banking and financial-services data environments.
Benefits
- Comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation, commissions, and stock where applicable.
- Leaders who support professional development through coaching and management opportunities.
- Opportunity to make a difference and lasting impact.
- Work in a dynamic, collaborative, progressive, and high-performing team.
- World-class training program in financial services.
- Full-time regular salaried role based in Toronto, Canada, with 37.5 work hours per week.
About RBC
Royal Bank of Canada (RBC) provides personal and commercial banking, payments, mortgages, investing, wealth management, insurance, and capital markets services to consumers, businesses, and institutions. The public company, headquartered in Toronto and founded in 1864, serves more than 17 million clients across Canada, the U.S., and other global markets. Revenue comes from interest income, fees, advisory, and trading across its diversified financial services businesses, and it is Canada’s largest bank by market capitalization.