Job Description Informatica Cloud Developer (IISC, IDMC) Location: Toronto, ON Hybrid (2-4 Days WFO) 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 (Valuable 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

📌 Informatica Cloud Developer (IISC, IDMC) (Toronto)
🏢 Astra North Infoteck
📍 Toronto