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.

Robust 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
#J-18808-Ljbffr

📌 Informatica Cloud Developer (IISC, IDMC) (Ontario)
🏢 Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!
📍 Ontario