Beschreibung
Tasks:1. Informatica Workflow enhancement GDTS Release 3.0 – MyLIMS
a. Create technical mapping documentation with defined and delivered requirements
which is needed for validation documentation for GxP system BI-AS-GDTS
b. Enhance GDTS Informatica framework for new global source system MyLIMS
c. Develop mapping (interface) for analysis data (CQA) in corresponding workflows
e. Development testing for newly created interface in already existing BI testing system
and GDTS environment as needed for GxP system BI-AS-GDTS
f. Create or Update GDTS Validation IT documentation in Boehringer documentation
management system which will be reviewed and approved by internal GDTS IT
members
g. Informatica deployment of updated GDTS workflows from DEV to QA and PROD via
defined Boehringer process
2. Informatica Workflow enhancement GDTS Release 2.0 – GBS United
a. Existing GBS interface needs to be extended with additional source qualifier fields to
enhance existing CQA data structure.
b. Create technical mapping documentation with given template documentation
which is needed for validation documentation for GxP system BI-AS-GDTS
e. Development testing for adapted interface in already existing BI testing system and
GDTS environment as needed for GxP system BI-AS-GDTS
f. Create or Update GDTS Validation IT documentation in Boehringer documentation
management system which will be reviewed and approved by internal GDTS IT
members
g. Informatica deployment of updated GDTS workflows from DEV to QA and PROD via
defined Boehringer process
3. Informatica Workflow enhancement GDTS Release 3.0 – MES
a. Create technical mapping documentation with defined and delivered requirements
which is needed for validation documentation for GxP system BI-AS-GDTS
b. Enhance GDTS Informatica framework for new global source system MES
c. Develop mapping (interface) for process data (CPP) in corresponding workflows
e. Development testing for newly created interface in already existing BI testing system
and GDTS environment as needed for GxP system BI-AS-GDTS
Developer for Data Warehouse and Informatica (m/f/n)
Freelance-ID: OCR-FL-2046
OC Recruitment GmbH & Co. KG – 72108 Rottenburg/ Neckar
f. Create or Update GDTS Validation IT documentation in Boehringer documentation
management system which will be reviewed and approved by internal GDTS IT
members
g. Informatica deployment of updated GDTS workflows from DEV to QA and PROD via
defined Boehringer process
4. Review, redesign and rework of the existing Informatica framework
a. Review existing Informatica GDTS framework and show up potential improvements.
Focus should be simplification in parametrization of current existing parameter files per
workflow. Improve the framework for more robustness in operational mode.
b. After BI GDTS internal alignment the contractor gets a working package with defined
tasks . The contractor works independently, can start to redesign and rework the
existing Informatica framework.
c. Create necessary validation documentation accordingly redesigned and further on
implemented Informatica framework.
d. Update existing test approach in BI testing tool for redesigned Informatica
framework.
Requirements
Experiences in /as:
• Informatica Senior Consultant / Certified Developer, at least 3 years of
experience
• Business Intelligence
• Data Warehouse Design und Architecture
• Database modeling
• Data modeling and integration
• Data analysis
• Data modeling
Technical Expertise:
• Data Warehousing – ETL – Informatica (Version )
• Informatica - connection of relational DB technologies
• Informatica – connection to SAP systems – various connection types (IDoc,
BAPI/RFC, etc.)
Business english - fluent