Educational requirements: Bachelor
English requirements: Competent English
Requirements for skilled employment experience for years: 5-8 years
Required residence status: Temporary visa, Permanent resident, Citizen
Accept remote work: unacceptable
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.
