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 (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 transparent 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