• 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

• 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.

• 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.

• 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.

• Preparation of invoicing and stock-register programme in Visual Basic language

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

• 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