freiberufler ETL Entwickler (Informatica) auf freelance.de

ETL Entwickler (Informatica)

offline
  • 35‐50€/Stunde
  • 76307 Karlsbad
  • auf Anfrage
  • sl  |  en  |  de
  • 09.08.2022

Kurzvorstellung

Ich bin ein fleißiger und zuverlässiger Mitarbeiter. Ich gehe schnell in das Problem ein und versuche die optimale Lösung zu finden. Flexibel und bereit zu lernen. Ich habe 10 Jahre Erfahrung als Senior ETL-Entwickler.

Auszug Referenzen (1)

"Good employee and highly qualified specialist"
Etl Entwickler
Alex
Tätigkeitszeitraum

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.

Eingesetzte Qualifikationen

Informatica, PL/SQL

Qualifikationen

  • ETL3 J.
  • Git
  • Informatica8 J.
  • Jira1 J.
  • Microsoft Business Intelligence5 J.
  • Oracle Business Intelligence (BI)
  • Oracle Database
  • PL/SQL8 J.
  • Postgresql
  • Transact-Sql3 J.

Projekt‐ & Berufserfahrung

Etl Entwickler
OTP Bank, Moskau
3/2020 – 6/2022 (2 Jahre, 4 Monate)
Banken
Tätigkeitszeitraum

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.

Eingesetzte Qualifikationen

Informatica, PL/SQL

Senior ETL Developer
Frilance, Karlsbad
2/2017 – 1/2020 (3 Jahre)
Banken
Tätigkeitszeitraum

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.

Eingesetzte Qualifikationen

ETL, Transact-Sql

ETL Architect (Festanstellung)
Pochta Bank, Moskau
5/2016 – 1/2017 (9 Monate)
IT
Tätigkeitszeitraum

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.

Eingesetzte Qualifikationen

Business Intelligence (BI), Informatica, PL/SQL, SQL, Transact-Sql

Senior ETL / BI Developer and Administrator (Festanstellung)
Cetelem Bank (BNP PARIBA), Moskau
4/2014 – 5/2016 (2 Jahre, 2 Monate)
Banken
Tätigkeitszeitraum

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.

Eingesetzte Qualifikationen

Informatica, Microsoft Business Intelligence, PL/SQL, SQL

ETL Informatica Developer (Festanstellung)
GlowByte Consulting, Moskau
9/2012 – 4/2014 (1 Jahr, 8 Monate)
Banken
Tätigkeitszeitraum

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.

Eingesetzte Qualifikationen

Informatica, Microsoft Business Intelligence, PL/SQL, SQL

Business Object PL/SQL Developer (Festanstellung)
Beeline, Moskau
9/2010 – 8/2012 (2 Jahre)
Telekommunikation
Tätigkeitszeitraum

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.

Eingesetzte Qualifikationen

Informatica, Microsoft Business Intelligence, SQL

Lotus Notes Developer and Tester (Festanstellung)
Domodedovo Airport, Moskau
9/2009 – 11/2010 (1 Jahr, 3 Monate)
Logistikdienstleister
Tätigkeitszeitraum

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.

Eingesetzte Qualifikationen

Jira, Lotus Notes Domino, PL/SQL

Ausbildung

Deutsche Kurse von A1 bis B1
Ausbildung
2017
Karlsruhe Sprachakademie
Software and administration of information systems
Expert in the specialty
2010
Moskau

Über mich

Verantwortlich, flexible, engagiert, fleißig, arbeitsam

Weitere Kenntnisse

I am a hardworking and reliable employee. I quickly delve into the problem and
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

Sprache
  • Slowenisch (Muttersprache)
  • Englisch (Gut)
  • Deutsch (Gut)
Reisebereitschaft
auf Anfrage
Arbeitserlaubnis
  • Europäische Union
Home-Office
bevorzugt
Profilaufrufe
1638
Alter
36
Berufserfahrung
15 Jahre und 2 Monate (seit 09/2009)
Projektleitung
5 Jahre

Kontaktdaten

Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.

Jetzt Mitglied werden