Senior ETL Developer

ETL Developer (1 year contract - Hybrid "Toronto")

• Design, build, automate and optimize complex data ETL/ELT processes using Informatica and equivalent
  
• Relational databases (Oracle, MS-SQL), data modelling (relational & dimensional), advanced SQL, query optimization, data replication, administration
  
• Scripting languages (Python, Unix shell)
  

• Support the Business Intelligence and Business Analytics Unit in developing and implementing the technical solutions needed for data loading as well as providing operational support ensuring that any technical glitch can be quickly addressed
  
• Design technical solutions for automating data collection and storage into our centralized data repository
  
• Develop detailed application programming specifications,
  
• ETL scripts, design data-driven logic and conduct unit testing
  
• Conduct database modeling and design, improve BIBA data performance
  
• Translate technical specifications for integration/sustainabilityinto working, tested application code;
  
• Develop, test and implement the required technical solutions as well as ensure that the requirements in terms of data accuracy, quality are met
  
• Produce design artifacts and documentation which will allow future support of the implemented solutions
  
• Support and enhance the current automatic ETL processes which load COVID-19 related dataset to SAS Analytics database in BIDA
  
• Provide programming support for incident management, application functionality sustainability, performance tuning and technical documentation;
  
• Improve the daily data transformation and reporting processes
  
• Investigate and Resolve incidents and identify whether the problem is caused by the data loading code or is due to bad data received from the provider
  
• Execute service requests related to routine and ad-hoc data loads
  
• Improve the quality and accuracy of the data collected from the data providers
  
• Provide the data quality check and report on the data quality issue
  
• Ensure that data collected is in a format which is easily consumable by the business users from Capacity Planning and Analytics
  

Requirements

• Data warehousing design and development with focus on extracting, transforming data coming from various data sources and loading into star/snowflake schemas
  
• Design, build, automate and optimize complex data ETL/ELT processes using Informatica and equivalent
  
• Informatica transformations, mappings and workflows (experience with other ETL tools such as DataStage, ODI or Microsoft SSIS could also be considered)
  
• Relational databases (Oracle, MS-SQL), data modelling (relational & dimensional), advanced SQL, query optimization, data replication, administration
  
• Scripting languages (Python, Unix shell)
  
• Cloud technologies (Azure, Google, AWS)
  
• Big data (Hadoop, Spark, Hive)
  
• Data analytics/machine learning (integrate AI algorithms in data processing pipelines for detecting anomalies, fraud or any other kind of outliers)
  
• BI/Reporting (Cognos, SSRS) and Data Visualization tools (Power BI, Tableau)
  
• DataOps, Cloud Microservice, Data Lake