DWH Datastage Consultant

Vertragsart:
Vor Ort
Start:
08.2020
Dauer:
6 Monate (Verlängerung möglich)
Von:
Ubique Systems GmbH
Ort:
Frankfurt
Eingestellt:
05.08.2020
Land:
flag_no Deutschland
Ansprechpartner:
Dipti Barik
Projekt-ID:
1953612

Warning
Dieses Projekt ist archiviert und leider nicht (mehr) aktiv.
Sie finden vakante Projekte hier in unserer Projektbörse.
Hi All,

Please see the job description below -


1. Analyze and understand the Bank's Global CIDM
2. Discuss the detailed requirements of each subject area with the CI-Tribe based on step 1 and add/delete the entities that are applicable locally/not applicable locally
3. Discuss and capture the requirements of CI-related end user reports that are currently built using SAS data sets with the relevant stakeholders in CI-Tribe
4. Based on the requirements captured in steps 1, 2 and 3, search for associated tables/documentation of the Data Sets (e.g., BDB and KRDB data) that can feed CIDM
5. Where the tables are not available in ODS to feed CIDM, refer to the existing SAS ETL scripts to derive the business logic
6. Using steps 4 and 5, create mapping documents that will be used by ETL developers to create IBM Datastage jobs
7. The mapping documents created in step 6 are also delivered to ING as artifacts
8. Perform unit testing of the developed ETL jobs and provide testing support in the test environments. Any bugs/errors encountered during testing have to be fixed
9. Design and create UC4 jobs/jobs plans based on the table dependencies within CIDM
10. Deploy Datastage jobs, Oracle tables, table definitions and UC4 jobs till pre-production environment and handover the deployment package to the concerned persons for production deployment
Skillset
Datastage, SAS, SQL, Jira