Educational requirements: Bachelor
English requirements: Competent English
Requirements for skilled employment experience for years: 3-5 years
Required residence status: Temporary visa, Permanent resident, Citizen
Accept remote work: unacceptable
As part of the Data Warehouse Team, work with data from multiple sources but primarily on SQL enterprise data warehouse to produce datasets, dashboards and reporting visualisations to meet specific requirements and business needs.
b) Development of ETL processes for Informatica PowerCenter and Snowflake to support the addition of priority datasets into the EDW.
c) Provide advice on how to best leverage the data warehouse environment, including best practice on data warehouse design and cloud migration.
d) Work to deadlines, monitor and report progress.
e) Work co-operatively and collaboratively with the (ITB) team, as well as other stakeholders.
Mandatory skills:
a) Demonstrated experience in design and development of ETL solutions using Informatica PowerCenter or other similar technologies.
b) Demonstrated experience in building ETL processes with the ability to read, analyse and transform data.
c) Excellent understanding of data warehousing concepts, including data analysis, data profiling, data cleansing and data modelling.
d) Demonstrated experience in monitor, run and troubleshoot the data load processes associated with data warehouse.
e) Demonstrated high-level communication skills, including the ability to identify, manage and effectively liaise with all stakeholders including technical and non-technical audiences.
f) Experience with analysis, design, development, and maintenance of Data Lake using ETL tools.
Desirable skills:
a) Knowledge of Microsoft Azure technologies, and SQL Server Integration Services.
b) Experience in development of ETL standards and Metadata management.
c) Experience in SQL Server and Oracle databases.
d) SQL Scripting and software development capability: e.g., T-SQL, Python, PowerShell, etc.
