Lead ETL Developer

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

Job summary

A leading IT consulting firm is seeking a Lead ETL Developer to engage with Project Managers and Analysts in Montreal. The role requires at least 8 years of experience in ETL development using Informatica, preferably in a Unix/Linux setup. Candidates should have Python or Perl skills, and strong knowledge of RDBMS such as DB2, Teradata, or Oracle. The position involves supporting all phases of the SDLC and performing proof of concepts on new platforms. This is a full-time position offering off-hours support.

Qualifications

• At least 8 years as an ETL Developer in an IT department.
• Experience with Informatica, supporting developers and users.
• Available for off-hours support.

Responsibilities

• Engage with Project Managers, Business Analysts, and Application DBA.
• Support all phases of SDLC including requirements gathering and testing.
• Perform Proof of Concepts on new platforms.

Skills

Informatica experience

Python or Perl development skills

ETL experience in Unix/Linux setup

RDBMS knowledge (DB2, Teradata, Oracle)

Unix shell scripting

Job description

Overview

Role: Lead ETL Developer

Location: Montreal, QC

Duration: Fulltime

BGV will be done for the selected candidates.

Responsibilities

• Engage with Project Managers, Business Analysts and Application DBA to implement ETL Solutions
• Multi-task between various tasks and projects
• 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
• Perform 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
• 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
• Unix shell scripting background

Desired Skills

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

Application Details

• Full Name
• Work Authorization
• Contact Number
• Email ID
• Skype ID
• Current location
• Willing to relocate
• Salary

Additional Information

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