Lead ETL Developer

Info-Ways; Montreal (administrative region); On-site; CAD 90,000 - 120,000; Full time

Benefits offered by this job

Info-Ways benefits

Job summary

Info-Ways in Montreal, QC is seeking a Lead ETL Developer to drive ETL solutions using Informatica. The role requires collaboration with PMs, BAs, and DBAs, with hands-on Python or Perl as needed, and readiness for off-hours support.

Candidates should be proficient in Unix/Linux, SQL with DB2/Teradata/Oracle, and Unix shell scripting, able to support all SDLC phases from requirements to post-production.

Qualifications

• 8+ years as an ETL Developer using Informatica in an IT department.
• Python or Perl development can substitute part of Informatica experience.
• ETL experience in a Unix/Linux environment.
• Experience with RDBMS such as DB2, Teradata or Oracle using stored procedures and embedded SQL.
• Unix shell scripting background.

Responsibilities

• Engage with Project Managers, Business Analysts and Application DBAs to implement ETL solutions.
• Multi-task across various tasks and projects.
• Role geared towards an ETL developer with Python or Perl development skills.
• Available for off hours support.
• Support all phases of SDLC—requirements gathering, development, testing, production implementation and post production.
• Performing Proof of Concepts on new platforms.
• Good team player.

Skills

ETL Informatica

Python/Perl

Unix/Linux

DBMS SQL (DB2/Teradata/Oracle)

Unix shell scripting

Job description

Role: Lead ETL Developer

Location: Montreal, QC

Duration: Fulltime

BGV will be done for the selected candidates.

Responsibilities

• Will need to engage with Project Managers, Business Analysts and Application DBA to implement ETL Solutions
• Must be able to multi-task between various tasks and projects
• This ETL developer role is geared more towards an ETL developer with python or Perl development skills.
• Must be available for Off Hours support
• Must have the ability to support all phases of SDLC- requirements gathering, development, testing, production implementation and post production.
• Performing Proof of Concepts on new platforms
• Good Team Player

Qualifications

Required Skills

• At least 8 years working as an ETL Developer using Informatica within an IT department, supporting both developers & users (business or other IT teams)
• Python or Perl development skills can substitute for part of Informatica experience.
• ETL experience must be in a Unix/Linux setup.
• Must have in depth experience with RDBMS such as DB2 , Teradata or Oracle as an application developer; using stored procedures, user defined functions and embedded SQL in other Programming Languages.
• Must have Unix shell scripting background

Desired Skills

• Green Plum and Teradata experience a plus
• Application DBA
• Data Modelling skills

Additional Information

All your information will be kept confidential according to EEO guidelines.