This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
Do you have 10+ years experience in data warehousing design and development with focus on extracting, transforming data coming from various data sources and loading into star/snowflake schemas? Do you have 10+ years experience in building mappings and workflows using Informatica PowerCenter and Intelligent Data Management Cloud? If so, this would be a great opportunity for you! Our client is looking for a Senior Software Developer - ETL for a 12 month contract in North York. This is an onsite role.
Job Responsibility:
Support the Business Intelligence and Business Analytics (BIBA) Unit in developing and implementing the technical solutions needed for data acquisition as well as providing operational support ensuring that any technical glitch is quickly addressed
Design technical solutions for data acquisition and storage into our centralized data repository
Develop ETL scripts, design data-driven logic and conduct unit testing
Conduct database modeling and design as to improve overall performance
Produce design artifacts and documentation which will allow future support of the implemented solutions
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 data provider
Execute service requests related to routine and ad-hoc data loads
Provide the data quality check and report on the data quality issue
Ensure that data collected is in a format which is easy consumable by the business users from Digital and Analytics Strategy Division
Re-engineer ETL processes as to make them suitable for Informatica IDMC migration
Requirements:
10+ years experience in data warehousing design and development with focus on extracting, transforming data coming from various data sources and loading into star/snowflake schemas
10+ years experience in design, build, automate and optimize complex data ETL/ELT processes
10+ years experience in building mappings and workflows using Informatica PowerCenter and Intelligent Data Management Cloud
Working experience with cloud data warehouse solutions such as Amazon Redshift