Resume Score

Check how well your resume matches this job before you apply.

Sign in to check score

About the role

  • 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

Benefits

  • flexible work environment
  • fluid career paths
  • celebrate internal mobility
  • well-being and work-life balance
  • create a welcoming and inclusive environment
  • volunteering for causes that matter most

Job title

Job type

Full Time

Experience level

Mid levelSenior

Salary

Not specified

Degree requirement

Bachelor's Degree

Tech skills

ETLInformaticaMS SQL ServerOraclePythonSQL

Location requirements

HybridBangaloreCanada

Report this job

Found something wrong with the page? Please let us know by submitting a report below.