ETL Developer – Data Warehouse & AWS

Job Title: ETL Developer – Data Warehouse & AWS

Job Description:

Location:

Toronto; Hybrid 2 days a week onsite

Role and Responsibilities:

• Resource has strong data warehouse technical knowledge.
• Resource have knowledge in Bank and financial domain (Minimum 10+ years of experience).
• Resource also required knowledge in ETL process and develop the SSIS packages.
• Ability to lead the team of developers and mentor as needed.
• Ability to understand the requirements and experience in managing complete data warehouse systems.

MUST HAVE:

• ETL data warehouse
• MS SSIS/SSRS
• AWS Redshift, AWS Glue

NICE TO HAVE:

• AWS Cloud services (Spark, Redshift and 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 process (like Kafka message processing, batch interface data injection and other business layer process)