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.
Product Engineer overseeing the technical lifecycle of screening and biomass handling products for Valmet. Collaborating with global teams and providing engineering expertise across the product lifecycle.
Senior Software Engineer developing high - quality software solutions for Savanta. Collaborating with cross - functional teams in a hybrid work environment to deliver impactful products.
Technical Lead developing and evolving iTakeControl, a clinical trial patient engagement platform at Red Nucleus. Leading in - house product development with a focus on compliance and mentoring engineers.
Software Engineer developing Python applications on Linux for Northrop Grumman's Space Sector. Collaborating with cross - functional teams to deliver secure, scalable software in a SCIF environment.
Principal Software Engineer developing and enhancing secure software systems for Northrop Grumman's CHORD portfolio. Focused on collaboration, team empowerment, and personal responsibility in a complex technical environment.
Software Engineer developing innovative software solutions for brain - computer interface applications at an exciting startup. Collaborating with R&D teams to create impactful technologies for patients with disabilities.
Senior Software Engineer responsible for building geospatial platforms for enterprise customers across various industries. Focusing on engineering solutions in web and mobile systems.
Senior Software Engineer developing scalable software solutions for T - Mobile. Collaborating on system design and mentoring teams while enhancing customer experience.
Software Engineer Manager oversees application development within a large or complex department at Regions. Evaluating and improving technology solutions for business efficiency and compliance.
Software Engineer I developing full - stack software solutions for Summit Credit Union. Collaborating with teams to build secure and compliant systems while ensuring quality and performance.