Data Warehouse ETL Developer

Apside Switzerland; Plein; Remote; EUR 68.000 - 103.000; Vollzeit

Zusammenfassung

A technology consulting firm is seeking a Data Warehouse ETL Developer to design and maintain data warehouse systems. The ideal candidate has extensive experience with IBM ETL tools and SQL Server, along with strong technical problem-solving abilities. This full-time role will involve translating business requirements into viable technical solutions, and requires on-call availability during weekends and holidays.

Qualifikationen

• Minimum of eight years of related experience.
• 3-5 years’ experience with IBM ETL tool, IBM InfoSphere DataStage.
• Proficient technical writing skills.

Aufgaben

• Design and maintain data warehouse systems.
• Translate business requirements into technical solutions.
• Investigate and resolve Data Warehouse issues.

Kenntnisse

IBM ETL tool experience

SQL Server proficiency

Technical problem solving

Relational database design

Data modeling

Tools

IBM InfoSphere DataStage

Cognos Data Manager

IBM Cognos BI Technologies

Jobbeschreibung

Overview

Data Warehouse ETL Developer at Apside Switzerland

The resource provides support to the organization’s business requirements in the application and consumption of information from the Enterprise Data Warehouse (EDW) or from other source systems. The resource works with architects and business partners to fashion out the technical vision for applications in the Data Warehouse. The resource ensures the functionality, security, availability and accuracy of the information within the Data Warehouse environment.

There is a requirement for the resource to work on weekends and holidays (on a rotation) from 9:00 AM to 11:00 AM and be available on-call during this period for incidents that may arise.

Location: Remote in Canada

Responsibilities

• Designs, maintains, and provides support for data warehouse systems and related data marts;
• Translates business requirements into viable technical solutions;
• Participates in the testing of developed technical solutions;
• Participates in the investigation and resolution of complex Data Warehouse issues;
• Proactively identifies opportunities for process, systems, and other efficiency improvements;
• Works effectively in the team and contributes to team effectiveness through personal style;
• Design data integration/ETL jobs using DataStage and its foundation tools in a SQL Server and Windows environment.

Requirements

• Minimum of eight years of related experience and knowledge;
• 3-5 years’ experience with IBM ETL tool, IBM InfoSphere DataStage;
• Relational database concepts and design;
• Technical testing techniques and tools;
• Logical and physical data modeling;
• Requirements analysis;
• Technical design skills;
• Proficient technical writing skills;
• Ability to translate business questions and requirements into technical solutions;
• Demonstrated application of technical problem solving and analytical tools and techniques;
• Experience with SQL Server;

Assets

• Bilingualism in both official languages (English and French).
• Experience with Cognos Data Manager
• Experience with IBM Cognos Business Intelligence Technologies (Report Studio, Framework Manager, Transformer and Query Studio)

Seniority level

• Mid-Senior level

Employment type

• Full-time

Job function

• Information Technology

Industries

• IT Services and IT Consulting

Referrals increase your chances of interviewing at Apside Switzerland by 2x.

Get notified about new Data Warehouse Engineer jobs in Plein, Rhineland-Palatinate, Germany.

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.