Job DescriptionJob Title: ETL Lead Developer
QTY: 9
Location: Toronto, ON
Work Style: Hybrid (2 days per week in-person at Toronto preferred)
Skills: Data Warehouse~Digital : PySpark~Digital : IBM Cloud
Experience Required: 6–8 years
Role and Responsibilities
• Resource has strong data warehouse technical knowledge
• Resource has knowledge in banking and financial domain (minimum 8+ years of experience)
• Resource required knowledge in ETL process and ability to develop SSIS packages
• Ability to lead a team of developers and mentor as needed
• Ability to understand requirements and experience in managing complete data warehouse systems
MUST HAVE
• ETL data warehouse
• MS SSIS/SSRS
• IBM Netezza
• MS SQL Server/Sybase database
• AWS Redshift, AWS Glue
NICE TO HAVE
• AWS Cloud services (Spark, Redshift, EMR)
• Knowledge in lending systems and functional knowledge on the same
• Knowledge in MDM systems for customer demographics process
• Knowledge in retail and commercial deposit system process (Core banking with Canadian banking domain)
• Strong solution knowledge in AWS Cloud and hands-on experience with ETL processes (Kafka message processing, batch interface data injection, and other business layer processes)
RequirementsSailpoint