Datastage, teradata, oracle
Aktualisiert am 04.06.2024
Profil
Freiberufler / Selbstständiger
Remote-Arbeit
Verfügbar ab: 04.06.2024
Verfügbar zu: 100%
davon vor Ort: 30%
datastage
Teradata
Datawarehouse
oracle
db2
English

Einsatzorte

Einsatzorte

Deutschland, Schweiz, Österreich
möglich

Projekte

Projekte

4 years 5 months
2020-01 - now

Developing and Optimising DATASTAGE jobs

Senior Application developer
Senior Application developer
  • Developing and Optimising DATASTAGE jobs, DB2 SQL queries for the HR
  • Working with the Analyst to design and develop ETL process
  • Mentoring junior colleagues
  • Analysing the defects and applied fixes
  • Processing JSON files
IBM ISSC Kft Budapest
2 years 6 months
2017-07 - 2019-12

Created DATASTAGE jobs

Senior DATASTAGE developer
Senior DATASTAGE developer
  • Created DATASTAGE jobs within BigData environment.
  • Knowledge of Data warehousing and Application development
  • Designed, developed, documented, optimized, and tested ETL jobs in DATASTAGE, as well as produced business logics using Teradata BTEQ scripts.Stage to populate tables in Data WareHouse and DataMart.
  • Extracted data from Complex Flat Files and Persistent Datasets.
  • Build DATASTAGE jobs to read files from multiple vendors using Complex Flat File and Sequential File stages.
  • Scheduling jobs with OPC, editing JCL in TSO
  • Load data into Hadoop tables using BigData connector stage.
  • Analysed the defects and applied fixes in the DATASTAGE jobs and Sequencers.
Unicredit Services
1 year 1 month
2016-06 - 2017-06

development project for Banking

Senior consultant DATASTAGE developer
Senior consultant DATASTAGE developer
  • Worked on Agile development project for Banking environment to loading consumer loan related data into data warehouse.
  • As a lead developer, I was responsible for gathering and analysing requirements, data modeling, and designing ETL processes.
  • Involved in design of Data Vault model for the new Data Warehouse on Oracle server.
  • Collaborated in 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
  • Improving the efficiency of DATASTAGE jobs and ORACLE SQL scripts.
  • Extracted data from Complex Flat Files and CSV Excel file
  • Analysed the defects and applied fixes in the DATASTAGE jobs and Sequencers.
Commerz Finanz
Munich
8 years 6 months
2007-12 - 2016-05

Waterfall projects

PL1, Cobol, and DATASTAGE developer, Technical analyst
PL1, Cobol, and DATASTAGE developer, Technical analyst
  • Approx. 7 years of career reflecting experience Design, Development, Implementation, ETL Application development in Waterfall projects.
  • Scheduling jobs using OPC, editing JCLs in TSO
  • Strong skills in IBM DATASTAGE 8.5, 9.1 and TERADATA 13.x.
  • Experience in Data warehousing, Application development
  • Involved in Designing, Developing, Documenting and Testing of ETL Jobs in DATASTAGE, and Teradata BTEQ scripting
  • Performed SDLC cycle of Data Integration, Unit testing, System Integration testing, Implementation, Maintenance and Performance tuning
  • Leading experience in GCD project phase I. Work in Global Credit Data, Asset and liability management (ALM) and RISK management project
  • Extracted data from Complex Flat Files (CFF), Persistent Datasets, IBM blocked variable length records file from Z/OS. and other vendors.
  • Created transformation and DataMart jobs using TERADATA SQL and BTEQ scripts.
  • Optimised DATASTAGE jobs, TERADATA SQL scripts, Analysed the defects and applied fixes in the DATASTAGE jobs and Sequencers.
  • Document and track the defects in HP Quality Center.
  • 2nd level support


Technical analyst

  • Assembled Source Target Matrix (STM) based on Business Data Elements (BDE), mappings and DDLs. Implemented it using TERADATA scripts.

Unicredit Bank
4 years 5 months
2003-07 - 2007-11

Preparation of invoicing and stock-register programme

Visual Basic
  • Preparation of invoicing and stock-register programme in Visual Basic language
Visual Basic
Vicom
8 years 7 months
1995-01 - 2003-07

Designed and produced invoicing and stock-register programme

  • Management of this programme, operation and maintenance the NOVELL network and other computer facilities of the company

Sláger Rt.
Budapest
8 years 4 months
1986-09 - 1994-12

Initially, system-programmer of R20 and R40 computers,

  • Initially, system-programmer of R20 and R40 computers, preparation of programmes in PL/1 and JCL languages. Later turned to programming of IBM PC computers.


1994

  • Took part in preparation of insurance policy-register programme for Hungaria Biztosító


1990

  • Participated in preparation of programmes for the Parliamentary Election


1989

  • Participated in preparation of programmes for the Parliamentary Election

1987 - 1988

  • Designed and developed of contract-register programme for CHEMOLIMPEX 


1988

  • recommended application of NOVELL network system at the company. 
  • Later on, responsible for development and operating network system
Számítástechnikai és Ügyvitelszervez? Vállalat,
Budapest

Aus- und Weiterbildung

Aus- und Weiterbildung

1984 - 1987

Eötvös Lorand University, Budapest, Faculty of Natural Science


Focus:

  • Special subject: Programmer-mathematician
  • Main subject: Programming, Analysis, System-programming, Operational research

Kompetenzen

Kompetenzen

Top-Skills

datastage Teradata Datawarehouse oracle db2

Produkte / Standards / Erfahrungen / Methoden

Profile

I am a computer programmer with more than 35 years? experience. Senior DataStage Developer with over 15+ years of ETL and Data Integration technical competence in Finance domain in Design, Development, Testing and Support of projects using DataStage in Banking, Retail, and HR environment. Worked extensively with Dimensional modelling, Data migration, Data cleansing, ETL process for data warehouses. Strong understanding of the principles fact tables, dimension tables star/snowflake schema modelling. Familiar in using highly scalable parallel processing infrastructure using parallel jobs and multiple node configuration files. I have experience in GRID environment too. I have strong analytical and technical aptitudes and am now seeking new project challenges.


Skills

  • IBM DATASTAGE 8.5, 9.2, 11.5, 11.7
  • DB2
  • ORACLE
  • TERADATA
  • MS SQL
  • Bigdata
  • BTEQ
  • LINUX
  • Windows
  • Z/OS
  • OPC
  • Tivoli
  • TSO
  • Excel
  • JIRA
  • JSON SVN
  • GIT
  • HP Quality Center
  • Excel
  • SharePoint
  • JCL
  • C#
  • Visual Basic
  • Cobol
  • PL1
  • ETL
  • DWH
  • Data Warehouse
  • System Integration Test
  • Agile
  • Waterfall
  • SnowFlake
  • Kimball
  • Data Vault
  • Performance tuning
  • Self-learning: Python, Scala, C++

Einsatzorte

Einsatzorte

Deutschland, Schweiz, Österreich
möglich

Projekte

Projekte

4 years 5 months
2020-01 - now

Developing and Optimising DATASTAGE jobs

Senior Application developer
Senior Application developer
  • Developing and Optimising DATASTAGE jobs, DB2 SQL queries for the HR
  • Working with the Analyst to design and develop ETL process
  • Mentoring junior colleagues
  • Analysing the defects and applied fixes
  • Processing JSON files
IBM ISSC Kft Budapest
2 years 6 months
2017-07 - 2019-12

Created DATASTAGE jobs

Senior DATASTAGE developer
Senior DATASTAGE developer
  • Created DATASTAGE jobs within BigData environment.
  • Knowledge of Data warehousing and Application development
  • Designed, developed, documented, optimized, and tested ETL jobs in DATASTAGE, as well as produced business logics using Teradata BTEQ scripts.Stage to populate tables in Data WareHouse and DataMart.
  • Extracted data from Complex Flat Files and Persistent Datasets.
  • Build DATASTAGE jobs to read files from multiple vendors using Complex Flat File and Sequential File stages.
  • Scheduling jobs with OPC, editing JCL in TSO
  • Load data into Hadoop tables using BigData connector stage.
  • Analysed the defects and applied fixes in the DATASTAGE jobs and Sequencers.
Unicredit Services
1 year 1 month
2016-06 - 2017-06

development project for Banking

Senior consultant DATASTAGE developer
Senior consultant DATASTAGE developer
  • Worked on Agile development project for Banking environment to loading consumer loan related data into data warehouse.
  • As a lead developer, I was responsible for gathering and analysing requirements, data modeling, and designing ETL processes.
  • Involved in design of Data Vault model for the new Data Warehouse on Oracle server.
  • Collaborated in 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
  • Improving the efficiency of DATASTAGE jobs and ORACLE SQL scripts.
  • Extracted data from Complex Flat Files and CSV Excel file
  • Analysed the defects and applied fixes in the DATASTAGE jobs and Sequencers.
Commerz Finanz
Munich
8 years 6 months
2007-12 - 2016-05

Waterfall projects

PL1, Cobol, and DATASTAGE developer, Technical analyst
PL1, Cobol, and DATASTAGE developer, Technical analyst
  • Approx. 7 years of career reflecting experience Design, Development, Implementation, ETL Application development in Waterfall projects.
  • Scheduling jobs using OPC, editing JCLs in TSO
  • Strong skills in IBM DATASTAGE 8.5, 9.1 and TERADATA 13.x.
  • Experience in Data warehousing, Application development
  • Involved in Designing, Developing, Documenting and Testing of ETL Jobs in DATASTAGE, and Teradata BTEQ scripting
  • Performed SDLC cycle of Data Integration, Unit testing, System Integration testing, Implementation, Maintenance and Performance tuning
  • Leading experience in GCD project phase I. Work in Global Credit Data, Asset and liability management (ALM) and RISK management project
  • Extracted data from Complex Flat Files (CFF), Persistent Datasets, IBM blocked variable length records file from Z/OS. and other vendors.
  • Created transformation and DataMart jobs using TERADATA SQL and BTEQ scripts.
  • Optimised DATASTAGE jobs, TERADATA SQL scripts, Analysed the defects and applied fixes in the DATASTAGE jobs and Sequencers.
  • Document and track the defects in HP Quality Center.
  • 2nd level support


Technical analyst

  • Assembled Source Target Matrix (STM) based on Business Data Elements (BDE), mappings and DDLs. Implemented it using TERADATA scripts.

Unicredit Bank
4 years 5 months
2003-07 - 2007-11

Preparation of invoicing and stock-register programme

Visual Basic
  • Preparation of invoicing and stock-register programme in Visual Basic language
Visual Basic
Vicom
8 years 7 months
1995-01 - 2003-07

Designed and produced invoicing and stock-register programme

  • Management of this programme, operation and maintenance the NOVELL network and other computer facilities of the company

Sláger Rt.
Budapest
8 years 4 months
1986-09 - 1994-12

Initially, system-programmer of R20 and R40 computers,

  • Initially, system-programmer of R20 and R40 computers, preparation of programmes in PL/1 and JCL languages. Later turned to programming of IBM PC computers.


1994

  • Took part in preparation of insurance policy-register programme for Hungaria Biztosító


1990

  • Participated in preparation of programmes for the Parliamentary Election


1989

  • Participated in preparation of programmes for the Parliamentary Election

1987 - 1988

  • Designed and developed of contract-register programme for CHEMOLIMPEX 


1988

  • recommended application of NOVELL network system at the company. 
  • Later on, responsible for development and operating network system
Számítástechnikai és Ügyvitelszervez? Vállalat,
Budapest

Aus- und Weiterbildung

Aus- und Weiterbildung

1984 - 1987

Eötvös Lorand University, Budapest, Faculty of Natural Science


Focus:

  • Special subject: Programmer-mathematician
  • Main subject: Programming, Analysis, System-programming, Operational research

Kompetenzen

Kompetenzen

Top-Skills

datastage Teradata Datawarehouse oracle db2

Produkte / Standards / Erfahrungen / Methoden

Profile

I am a computer programmer with more than 35 years? experience. Senior DataStage Developer with over 15+ years of ETL and Data Integration technical competence in Finance domain in Design, Development, Testing and Support of projects using DataStage in Banking, Retail, and HR environment. Worked extensively with Dimensional modelling, Data migration, Data cleansing, ETL process for data warehouses. Strong understanding of the principles fact tables, dimension tables star/snowflake schema modelling. Familiar in using highly scalable parallel processing infrastructure using parallel jobs and multiple node configuration files. I have experience in GRID environment too. I have strong analytical and technical aptitudes and am now seeking new project challenges.


Skills

  • IBM DATASTAGE 8.5, 9.2, 11.5, 11.7
  • DB2
  • ORACLE
  • TERADATA
  • MS SQL
  • Bigdata
  • BTEQ
  • LINUX
  • Windows
  • Z/OS
  • OPC
  • Tivoli
  • TSO
  • Excel
  • JIRA
  • JSON SVN
  • GIT
  • HP Quality Center
  • Excel
  • SharePoint
  • JCL
  • C#
  • Visual Basic
  • Cobol
  • PL1
  • ETL
  • DWH
  • Data Warehouse
  • System Integration Test
  • Agile
  • Waterfall
  • SnowFlake
  • Kimball
  • Data Vault
  • Performance tuning
  • Self-learning: Python, Scala, C++

Vertrauen Sie auf GULP

Im Bereich Freelancing
Im Bereich Arbeitnehmerüberlassung / Personalvermittlung

Fragen?

Rufen Sie uns an +49 89 500316-300 oder schreiben Sie uns:

Das GULP Freelancer-Portal

Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.