Job DescriptionRole: Informatica IICS Developer
Work Location: Toronto, ON - Hybrid (2-4 Days WFO)
Duration: 12 Months
Required Qualifications:
• Proven hands-on experience as an ETL Developer with a strong focus on Informatica Intelligent Cloud Services (IICS).
Technical Skills: • Deep understanding of ETL concepts, data warehousing principles, and dimensional modeling.
Database Knowledge: • Strong proficiency in SQL and experience working with relational databases.
Problem-Solving: • Excellent analytical and troubleshooting skills to resolve complex data integration issues.
Preferred Qualifications (Good to Have):
Oracle: • Experience working with Oracle databases, including:
• PL/SQL Scripting
• Performance Tuning
Snowflake: • Familiarity with Snowflake Cloud Data Warehouse, including:
• SnowSQL
• 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
• Data Quality
Collaboration: • Work with business users to gather data requirements and translate them into technical ETL specifications.
Maintenance & Support: • Provide operational support, perform debugging, and resolve data-related issues or job failures in a timely manner.
Documentation: • Maintain clear documentation of data integration architecture, processes, and deployment strategies.
RequirementsSailpoint