Business System Analyst (DWH) – PL/SQL, ETL (Toronto)

Overview

Job Description Role: Business System Analyst (DWH) PL/SQL, ETL Key Skills: Data Modeling, Banking Domain MUST HAVE Skills: Robust knowledge of PL SQL / T-SQL; Experience in Data Modelling (any designer tool); Gap analysis, and MS Visio; Good understanding of Data Warehousing concepts and ETL processes; Experience in driving requirement sessions/meetings with stakeholders; Strong knowledge of SQL for data analysis and data profiling across legacy systems. NICE TO HAVE Skills: Knowledge of Banking domain (accounts, customer data, transaction data); Experience with Sybase PowerDesigner for data modeling; Knowledge of Cloud technologies (AWS preferred) Key Responsibilities

Analyze Legacy System Analyze mapping documents of target tables to determine operational objectives by studying business functions, gathering information, and evaluating output requirements Track target field mapping back to origin data elements in source systems Perform data analysis and pro...