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

Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!

toronto, on, Canada
Full-time
Posted June 06, 2026

Job Description

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

Key Skills: Data Modeling, Banking Domain

MUST HAVE Skills:

  • Strong 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 requireme...