Umiejętności
Datastage
MS Integration Services
ODI
Sparx Enterprise Architect
SQL
IBM InfoSphere DataStage
Oracle Database
Hurtownie danych
Oracle Data Integrator
IBM Netezza
Integration Services (SSIS)
Języki
angielski
dobry
Doświadczenie zawodowe
ETL Developer
1. PAR – Analytical and Reporting Platform for Ministry of Labour and Social (area of social protection)
- ETL processes - designing, implementation and management (Oracle Data Integrator)
- Oracle database administration, programming in PL/SQL, tuning the database and queries (also Exadata)
- creating reports (OBIEE)
- diagnosing and resolving errors
2. CeSAR – Central System for Analysis and Report for Department of Labour Market
- support the data warehouse design
- ETL processes - designing, implementation and management (Oracle Data Integrator)
- programming in PL/SQL
- creating scripts in bash
- diagnosing and resolving errors
3. ENKI - Data warehouse for financial reporting
- maintaining and modifying an existing ETL process, modifying the T-SQL procedures (MS SQL Server, Integration Services)
5. SHD - Data warehouse for Social Insurance Instititution (ZUS)
- ETL transformation, improve the quality of data, creating scripts (DataStage and Quality Stage, Netezza, DB2)
- support the data warehouse design
- ETL processes - designing, implementation and management (Oracle Data Integrator)
- Oracle database administration, programming in PL/SQL, tuning the database and queries (also Exadata)
- creating reports (OBIEE)
- diagnosing and resolving errors
2. CeSAR – Central System for Analysis and Report for Department of Labour Market
- support the data warehouse design
- ETL processes - designing, implementation and management (Oracle Data Integrator)
- programming in PL/SQL
- creating scripts in bash
- diagnosing and resolving errors
3. ENKI - Data warehouse for financial reporting
- maintaining and modifying an existing ETL process, modifying the T-SQL procedures (MS SQL Server, Integration Services)
5. SHD - Data warehouse for Social Insurance Instititution (ZUS)
- ETL transformation, improve the quality of data, creating scripts (DataStage and Quality Stage, Netezza, DB2)
- support the data warehouse design
Szkolenia i kursy
• Oracle SQL and PL/SQL - Advanced database server programming and query optimisation 11g XE
• Oracle Database 12c - New features
• Oracle Exadata Technical Boot Camp
• Oracle Essbase 11.1.2 Implementation Boot Camp
• Oracle Database 11g Administration Workshop Part I
• Oracle Database 11g Administration Workshop Part II
• Oracle Database 12c - New features
• Oracle Exadata Technical Boot Camp
• Oracle Essbase 11.1.2 Implementation Boot Camp
• Oracle Database 11g Administration Workshop Part I
• Oracle Database 11g Administration Workshop Part II
Edukacja
Specjalizacje
IT - Administracja
Administrowanie bazami danych i storage
IT - Rozwój oprogramowania
Programista JAVA