We are seeking an experienced Data Engineer with strong hands-on expertise in Informatica Intelligent Cloud Services (IICS) and enterprise data integration .

The ideal candidate will have solid ETL, SQL, data warehousing, and troubleshooting skills.

Key Responsibilities Design, develop, and deploy ETL pipelines using IICS Data Integration and Application Integration.

Build complex mappings, tasks, and workflows for data integration across heterogeneous sources.

Extract, transform, and load data into data warehouses and data lakes.

Monitor and optimize IICS mappings and database queries for performance and reliability.

Gather data requirements and translate them into technical ETL specifications.

Troubleshoot data integration issues, job failures, and production problems.

Ensure data quality and consistency across integration processes.





Maintain technical documentation for data integration architecture and processes.

Required Skills Hands-on experience as an ETL/Data Integration Developer.

Strong expertise in Informatica IICS .

Strong understanding of ETL concepts, data warehousing, and dimensional modeling.

Advanced SQL and relational database experience.

Strong analytical, troubleshooting, and problem-solving skills.

Experience with data integration across multiple source systems.

Nice to Have Experience with Oracle and PL/SQL.

Oracle performance tuning experience.

Familiarity with Snowflake and SnowSQL.

Experience with cloud data warehouse loading practices.

Work Setup Location: Toronto, ON Work Type: Hybrid (2 4 days/week onsite) Duration: 12 Months

📌 Data Engineer ( IICS ) (Toronto)
🏢 J M Group
📍 Toronto