Lead ETL Developer responsible for designing and maintaining ETL solutions for Canada Life. Collaborating with teams to improve processes and ensure data integration best practices.
Responsibilities
design, develop and maintain ETL workflows using Informatica PowerCenter and or IICS
Extract, transform and load data from diverse sources (Mainframes, RDMS, APIs) into desired target data sources
Performs production support on ETL jobs as required
Focuses on continually improving and automating integration points and processes
Collaborates with data architects, business analysts and BI developers to translate requirements into technical solutions
Contributes to the standards and guidelines used to support the ETL application environment
Performance tuning of end-to-end integration processes across the integration platform
Identifies opportunity for reuse of objects across Data Warehouse/Mart & ETL BI Solutions
Operational Support rotation
Requirements
University or College education in Computer Science, Computer Engineering or a related field, or equivalent combination of education and experience
Solid programming experience with Python and SQL
Minimum 3+ years’ experience in an Enterprise IT environment with practical experience in application development in data integration (ETL) using Informatica/IDMC
Advanced experience with Ab Initio and Syncsort DMX ETL is an asset
Experience working with the following database technologies MS SQL Server, Oracle, DB2 Midrange/Mainframe
Experience in technical specification design - Proven experience in designing and building operational integrations and standard data warehousing objects (e.g. type-2 dimensions, aggregations, star schema, etc.)
Solid working knowledge of other software developer toolsets
Superior analytical and problem-solving skills
Proven ability to develop and maintain collaborative business relationships
Effective planning and organizational skills with the ability to adapt to change and perform effectively under pressure
Lead Engineer managing upgrade projects focusing on Valmet sensors and profilers. Collaborating with teams in North America and Finland to ensure project success.
Software Consulting Engineer leading advanced software architecture and design for T&D systems at GE Vernova. Driving digital transformation in energy sector with innovative engineering workflows.
Embedded Software Consulting Engineer leading strategy, architecture, and design of real - time embedded systems for GE Vernova’s T&D solutions. Focusing on modernization and security initiatives for protection relays and more.
Proposal Engineer developing technical content for complex engineering proposals at Lauren. Collaborating with project teams to ensure alignment and execution of engineering deliverables.
Senior Pipeline Engineer responsible for leading and delivering mainline pipeline projects across Canada. Collaborates with multidisciplinary teams and provides technical oversight and mentorship.
Specialist Engineer optimizing critical rotating equipment for Orica's Global Specialist Asset Integrity team. Leading engineering and reliability efforts across global manufacturing facilities.
Engineer in mechanical claims for Intact, supporting internal growth and improving insured experience during claims. Investigating causes of damages in building mechanical systems and ensuring resolution.
Process Engineer at Graphic Packaging designing and implementing production processes. Responsible for optimizing layouts and ensuring compliance with regulations.
Senior Process Engineer managing and executing process plant designs for the Minerals & Metals sector. Based in Vancouver or Burlington offices with flexible work arrangements.