Informatica IICS Developer
Job Location:
Monthly Salary:
Experience Required:
Posted on:
10 days ago
Posted on:
Vacancies:
1 Vacancy
Vacancies:
Job Summary
Role: 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.
Required Skills:
Sailpoint
