Informatica Cloud Developer (IISC, IDMC)

Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!; Toronto; Hybrid; CAD 85,000 - 120,000; Full time

Job summary

Astra-North Infoteck Inc. is seeking an Informatica Cloud Developer (IICS, IDMC) in Toronto, offering a 12-month contract with hybrid work arrangement. You will design and implement data integration solutions, build ETL mappings, and collaborate with RBC stakeholders to deliver reliable data flows.

The role emphasizes strong SQL skills, data warehousing concepts, and performance tuning of IICS mappings to ensure data quality and timely delivery.

Qualifications

• Proven hands-on experience as an ETL Developer with a strong focus on Informatica Intelligent Cloud Services (IICS).
• Deep understanding of ETL concepts, data warehousing principles, and dimensional modeling.
• Strong proficiency in SQL and experience working with relational databases.
• Excellent analytical and troubleshooting skills to resolve complex data integration issues.

Responsibilities

• Architect, build, and deploy end-to-end data integration solutions and ETL pipelines using IICS (Data Integration, Application Integration).
• Create complex mappings, tasks, and workflows to extract, transform, and load data from various heterogeneous sources into target data warehouses and data lakes.
• Monitor, troubleshoot, and optimize IICS mappings and database queries to ensure high performance, reliability, and data quality.
• Work with business users to gather data requirements and translate them into technical ETL specifications.
• Maintain clear documentation of data integration architecture, processes, and deployment strategies. Provide operational support, perform debugging, and resolve data-related issues or job failures in a timely manner.
• Documentation

Skills

IICS

SQL

Data warehousing

Analytical skills

Tools

Oracle

Snowflake

Job description

Informatica Cloud Developer (IISC, IDMC)

Location: Toronto, ON – Hybrid (2-4 Days WFO)

Duration: 12 months

Role: RBC

Required Qualifications

• Proven hands-on experience as an ETL Developer with a strong focus on Informatica Intelligent Cloud Services (IICS).
• Deep understanding of ETL concepts, data warehousing principles, and dimensional modeling.
• Strong proficiency in SQL and experience working with relational databases.
• Excellent analytical and troubleshooting skills to resolve complex data integration issues.

Preferred Qualifications (Good to Have)

• Oracle experience, including PL/SQL scripting and performance tuning.
• Snowflake familiarity, including SnowSQL and best practices for loading data into Snowflake.

Key Responsibilities

Design & Development

• Architect, build, and deploy end-to-end data integration solutions and ETL pipelines using IICS (Data Integration, Application Integration).

Data Transformation

• Create complex mappings, tasks, and workflows to extract, transform, and load data from various heterogeneous sources into target data warehouses and data lakes.

Performance Tuning

• Monitor, troubleshoot, and optimize IICS mappings and database queries to ensure high performance, reliability, and data quality.

Collaboration

• Work with business users to gather data requirements and translate them into technical ETL specifications.

Maintenance & Support

• Maintain clear documentation of data integration architecture, processes, and deployment strategies. Provide operational support, perform debugging, and resolve data-related issues or job failures in a timely manner.

Documentation