Datastage developer

12/2019 – offen

• Developing DataStage jobs.
• Optimising Datastage jobs
• Cleanse and transform the data as per business logic.
• Mentoring junior colleagues.
• Analysed the defects and applied fixes in the Datastage jobs and Sequencers
• Create framework to run job parallel and job monitoring

Softwareentwicklung (allg.)

6/2016 – 6/2017

• Extracted data from Complex Flat Files (CFF) and CSV Excel file in Data Vault modelling environment
• Performed Unit Testing and System Integration Testing based on Test cases.
• Develop and design generic jobs in Datastage 11.5 to load source file into RAW IN area and from RAW IN to RAW DV (generic job means one job for any source)
• Design and develop metadata/source target matrix table for generic jobs
• Creating Oracle sql scripts.
• Optimising Datastage jobs
• Optimising Oracle sql scripts

Data Warehousing, ETL, Oracle Database

12/2007 – 6/2016

• Extracted data from Complex Flat Files (CFF) and Persistent Datasets.
• Effectively used Persistent Datasets to transfer the data between jobs.
• Performed Unit Testing and System Integration Testing based on Test cases.
• Creating test cases for Unit Test
• Build Datastage jobs to read files from multiple vendors using Complex Flat File and Sequential File stages.
• Creating Teradata sql scripts.
• Optimising Datastage jobs
• Optimising Teradata sql scripts
• Cleanse and transform the data as per business logic.

ETL, Teradata Sql