Informatica Cloud Developer (IISC, IDMC)
Location: Toronto, ON – Hybrid (2-4 Days WFO)
Duration: 12 months
Role: RBC
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 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
#J-18808-Ljbffr
Sign in
To continue your applicationor continue with email
By continuing you agree to our Terms & Privacy Policy.
Similar jobs
Show more
More from Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!