Sr. ETL Developer with Ab Initio and Control-M experience to support our insurance client's migration to Informatica

Sr. ETL Developer with Ab Initio and Control-M experience to support our insurance client's Non-Prod UAT Simulation initiative and upcoming migration to Informatica Cloud.

Location: Hybrid - (1-2 days in either Toronto, London or Winnipeg Office)

Duration: 12 Months

Hours: 37.5/Week (3 days during standard work week + Saturday & Sunday)

Responsibilities:

• Relationship builder who understands the importance of happy clients.
• Works with application teams to understand and define requirements.
• Participates in the design, development, and QA of ETL solutions.
• Performs production support on ETL jobs as required.
• Focuses on continually improving and automating integration points and processes.
• Contributes to the standards and guidelines used to support the ETL application environment.
• Coaches and mentors’ others.
• 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.
• Has a focus for continuous learning and professional development.
• Available to join the ETL off hours On-Call Support rotation.

Must-Haves:

• Minimum 10 years’ experience in an IS environment with practical experience in application development in data integration (ETL)
• Advanced experience with Ab Initio ETL.
• Experience with BMC Control-M
• 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.)

Nice to Have:

• Insurance Industry Experience
• Informatica Cloud (IDMC)
• Experience with Change Data Capture (CDC) tools are an asset.
• Experience with Collaboration tools like Atlassian’s Jira and Confluence is an asset.
• Experience with Syncsort DMX ETL is an asset.