ETL Developer (IBM Datastage)

Job Description

Job Description : We are currently looking for developers profile (AD2/AD3), to be allocated on a transversal squad/dev team and dedicated to maintain and support our transversal framework on Data factory.

Data Factory is a key program that will deliver a Data Aggregation and Curation platform, based on a relational database and an ETL for modern and efficient data loading, transformation and control. This aim is to create a unique centralised repository with a copy of operational and referential data, where all data are consolidated and harmonised, and where data quality is qualified as fit for purpose.

These positions will work in an environment where the scopes of the technologies used in the projects will tend to grow.

These positions will be for ETL developers on technologies, such as IBM Datastage PX and SQL, will provide user support and be trained on the technologies eligible. In this role the candidate must be able to set up the environment before development, perform, document and record the necessary tests to provide acceptance evidences to the client.

Main Responsibilities:

• Participate in an ETL development cycle (Analysis, development, testing and deployment), mainly in IBM Datastage PX and SQL
• Ensure unit-testing, integration testing, automatic testing (mainly with Octane, quality center or other similar tools q)
• Ensure the application of the good technological and methodological practices recommended
• Identify innovative ideas and proof of concepts according to project requirements
• Ensure maintenance and level 3 support of the application portfolio
• Acquire functional and/or technical expertise on the key elements of the application and/or technological portfolio
• Challenge business and/or technical requirements
• Contribute on technical solution definition
• Develop and customize enablers components Datastage components
• Monitor performance and rectifying related issues.
• Deliver projects with quality

Nice to have:

• Experience with REST APIs and Service/events oriented architecture
• Working with DevOps tools : Jenkins; git ; ansible
• Experience in Agile context (like Kanban, Lean or SCRUM)

Qualifications

Technical skills:

• IBM Datastage PX and/or other similar ETL tools
• SQL development skills (Oracle is the DB used)
• PL/SQL development skills
• Experience with GIT and Jenkins
• Experience with Shell scripting, Unix/Linux
• Experience in documenting bug reports, tickets, and code changes
• Technical analysis and documentation
• English (read, spoken, written - C level minimum)