ETL Entwickler (Informatica)
- Verfügbarkeit einsehen
- 1 Referenz
- 35‐50€/Stunde
- 76307 Karlsbad
- auf Anfrage
- sl | en | de
- 09.08.2022
Kurzvorstellung
Auszug Referenzen (1)
"Good employee and highly qualified specialist"
3/2020 – 6/2022
Tätigkeitsbeschreibung
- Developing, administrating, optimization of ETL Process in the Bank.
- Optimization and creating PL/SQL procedure.
- Creating validation techniques for loading data from different sources to data
warehouse and performing data quality checks on golden records identification.
- Identifying performance bottlenecks and improvement of Informatica ETL
mappings and flows.
- Code review and ETL components' review to make sure that code matches the
coding standard.
Informatica, PL/SQL
Qualifikationen
Projekt‐ & Berufserfahrung
3/2020 – 6/2022
Tätigkeitsbeschreibung
- Developing, administrating, optimization of ETL Process in the Bank.
- Optimization and creating PL/SQL procedure.
- Creating validation techniques for loading data from different sources to data
warehouse and performing data quality checks on golden records identification.
- Identifying performance bottlenecks and improvement of Informatica ETL
mappings and flows.
- Code review and ETL components' review to make sure that code matches the
coding standard.
Informatica, PL/SQL
2/2017 – 1/2020
Tätigkeitsbeschreibung
- Development and optimization of existing ETL processes and creation of the new
ones (Informatica).
- Creation and modification of architectural ETL-processes for DWH daily load
(staging, detail layer, data marts).
- Business analysis and data model design for new tables related to ETL.
- Assigning tasks to ETL developers.
- Administration and creating cubes, universes and reports in Business Object.
- Creation and optimization of complex SQL, PL/SQL code and procedures.
ETL, Transact-Sql
5/2016 – 1/2017
Tätigkeitsbeschreibung
- Designed, modeled, developed ETL process in Informatica. Data was sourced
from Oracle databases/ Files/ XML/ EXCEL. Data was used by BI SAP reports.
- Created the architecture for data flow.
- Tested application and implemented it into production.
- Assigning tasks to ETL developers.
- Administration and creating cubes, universes and reports in Business Object.
- Creation and optimization of complex SQL, PL/SQL code and procedures.
- Responsible for key architecture decisions.
- Code review and ETL components' review to make sure that code matches the
coding standard.
Business Intelligence (BI), Informatica, PL/SQL, SQL, Transact-Sql
4/2014 – 5/2016
Tätigkeitsbeschreibung
- Lead ETL / BI Developer.
- Development and optimization of existing and creation of the new ETL processes
(informatica) (e.g. implemented a data mart for risk reporting, calculation of delay
on due date of monthly payment).
- Creation and modification of architecture ETL-processes DWH daily load
(staging, detail layer , data marts).
- Responsible for the preparation and in-time installation of releases on production
Analysis algorithms.
- Working as 3rd level support.
- Technical specifications development.
- Providing integration tests for complex processes: the transfer of objects in a test
environment, ETL data loading, counting, verification of the fields.
- Development of reports and universes in Business Objects.
- Administration Business Object.
Informatica, Microsoft Business Intelligence, PL/SQL, SQL
9/2012 – 4/2014
Tätigkeitsbeschreibung
- Development of the ETL processes in several huge projects and the
implementation of DWH data marts in the major commercial banks as ETL
developer.
- Implementation of the download process data using Informatica PowerCenter
(ETL / ELT approaches).
- Processing data mart of ACRM.
- Creation and optimization of SQL and PL/SQL procedures and queries.
Informatica, Microsoft Business Intelligence, PL/SQL, SQL
9/2010 – 8/2012
Tätigkeitsbeschreibung
- Created projects and reports in Business Object.
- Development of complex sql queries, unions and procedures in Oracle database. - Created groups of users in Business Object.
- Reported and tracked of key indicators.
- Creation and optimization procedures in Transact-SQL and PL/SQL.
- Managed of weekly reporting and made changes in the calculation parameters of reports. - Setup mailing reports from Business Object.
- Created reports linking several universes for different subject areas like Purchase Orders, Accounts Payable, Pharmacy and Inventory for seamless reporting.
- Created User Prompts, Conditions and Filters to improve the quality of report generation.
- Created the Web Intelligence Report and used Events for Daily/Weekly /Monthly Scheduling of the reports.
- Used complex functions in calculating fields in Business Object.
Informatica, Microsoft Business Intelligence, SQL
9/2009 – 11/2010
Tätigkeitsbeschreibung
- Creation and support of projects based on Lotus Notes.
- Testing projects on the technical task.
- Communication with clients.
- Description of the business requirements.
Jira, Lotus Notes Domino, PL/SQL
Ausbildung
Karlsruhe Sprachakademie
Moskau
Über mich
Weitere Kenntnisse
try to find the optimal solution. Flexible and ready to learn and acquire new skills.
I have 10 years of experience as a Senior ETL Developer.
Persönliche Daten
- Slowenisch (Muttersprache)
- Englisch (Gut)
- Deutsch (Gut)
- Europäische Union
Kontaktdaten
Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.
Jetzt Mitglied werden