Business System Analyst (DWH) – PL/SQL, ETL
Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!
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 requirements Track target field mapping back to origin data elements in source systems Perform data analysis and profi...
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 requirements Track target field mapping back to origin data elements in source systems Perform data analysis and profi...