ABOUT THE CLIENT
SITA is the world’s leading specialist in air transport communications and information technology. SITA works closely with every sector of the air transport community, innovating, developing and managing business solutions over the world’s most extensive network – the one that forms the “communication backbone” of the global air transport industry.
Following a Proof-of-Concept phase, SITA has decided to entrust Pentalog the migration of all ETL jobs related to the master data referential from Informatica PowerCenter to Talend. The project was carried out in our Delivery Center of Bucharest (Romania) by a team of 2 people starting from December 2012.
The migration was done in two successive phases:
The preparation phase. During this stage, we used the following approach:
- build up of the source and target environments (Oracle, Informatica PowerCenter and Talend)
- identification of sources and targets
- import of sources and targets definition
- definition of naming conventions
- design of a structure for the Talend repository
- definition of the Talend Open Studio workspaces (DEV, TEST, UAT, PROD)
- within each workspace and for each source/target environment, design of job execution
- definition of contexts
- design of a prototype to validate the unitary development cycle
- The iterative phase. It’s during this stage that occured the actual migration of the ETL jobs. Each existing Powercenter workflow and its constitutive mappings and tasks were converted into a job under Open Studio semantics.
Given a data set, a Powercenter mapping and its migrated counterpart, the validation would pass if and only if both mappings produced the same output given the same input.
KEY SUCCESS FACTORS
- The validation of the jobs migration approach by designing a prototype during the preparation phase.
- The good previous technical experience of the Pentalog’s ETL developers.
- The involvement of a Technical coordinator from Pentalog Institute: an ETL expert who was in charge of the process set-up for the developers, regularly checked their work and discussed with the client the main technical issues.