Hybrid Senior Data Engineer

Posted 33 minutes ago

Apply now

About the role

  • Lead ETL Developer responsible for ETL solutions involving data integration and automation. Working in a hybrid environment at Canada Life with a strong emphasis on collaboration.

Responsibilities

  • Designing, developing, and supporting ETL solutions that meet business partner’s expectations.
  • Building and supporting integration solutions as a member of a centralized team.
  • Maintaining ETL workflows using Informatica PowerCenter and/or IICS.
  • Extracting, transforming, and loading data from diverse sources into desired target data sources.
  • Performing production support on ETL jobs as required.
  • Continually improving and automating integration points and processes.
  • Collaborating with data architects, business analysts, and BI developers to translate requirements into technical solutions.
  • Contributing to the standards and guidelines used to support the ETL application environment.
  • Performance tuning of end-to-end integration processes across the integration platform.
  • Identifying opportunities for reuse of objects across Data Warehouse/Mart & ETL BI Solutions.
  • Participating in Operational Support rotations.

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 5+ 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.

Benefits

  • flexible work environment
  • fluid career paths
  • work-life balance
  • diverse and inclusive environment
  • volunteering opportunities

Job title

Senior Data Engineer

Job type

Experience level

Senior

Salary

Not specified

Degree requirement

Bachelor's Degree

Location requirements

Report this job

See something inaccurate? Let us know and we'll update the listing.

Report job