Lead ETL Developer
Posted Updated 17
views
Summary
Designs and implements ETL pipelines to extract, transform, and load data between systems, collaborating with PMs, BAs, and DBAs to ensure seamless data integration across Unix/Linux environments using Informatica, Python/Perl, and RDBMS tools.
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.