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
Senior I&C Engineer designing CANDU instrumentation and control systems for AtkinsRéalis, a Canadian nuclear engineering services company. Producing specifications, assessments, design documents, and engineering drawings.
Seeking a DDI Engineer with deep DNS expertise to support a large enterprise network in the GTA, ON. Contract role requiring hands - on experience with DNS/DHCP and IPAM platforms.
Fire engineer designing and evaluating fire protection systems for GHD’s Canadian architecture, engineering, and environmental projects. Conducting risk assessments, code reviews, inspections, project management, and mentoring junior engineers.
Engineer II performing design, analysis, testing, and field engineering for Framatome Canada’s nuclear technologies. Supporting safe, efficient CANDU reactor operations and product - life - cycle improvements.
Underground Geotechnical Engineer supporting ground control and mine planning at Coeur Silvertip, a Canadian precious - metals mining operation. Designing support systems, analyzing monitoring data, and managing geotechnical risk for underground excavations.
The City of Regina is hiring a Project Engineer/Coordinator for Water - Sewer Programming. Ideal for those with experience in municipal infrastructure, water/wastewater, engineering, or project management.
Validation Engineer testing SSD firmware, NVMe features, and NAND memory products for DATAmundi’s localization and data - services software business. Detecting defects, optimizing validation, and coordinating with firmware engineers and clients.
Project Engineer improving yield, efficiency, and raw - material utilization in Agropur’s dairy manufacturing operations. Leading process optimization and capital projects at the Granby facility.