Info Lifecycle Ilm Tech Lead - Enterprise Platform - C$149,500 - C$183,500 A Year
TD BankEast York, CanadaLead for Information Lifecycle Management in Toronto.Focus on automating data lifecycle controls and compliance. Show more
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 |
Informatica Cloud Developer (IISC, IDMC) • Toronto, ON, ca