Informatica PowerCenter Zertifizierter Entwickler

Profil Foto
Verfügbarkeit einsehen
National
de  |  en
auf Anfrage
60489 Frankfurt am Main
12.01.2019

Kurzvorstellung

Informatica PowerCenter Certified Developer with 10+ years of experience in Informatica PowerCenter, Informatica PowerExchange, ETL Architecture, ETL Design, Data warehousing, Dimensional modelling, SQL, PLSQL, ORACLE, UNIX Shell Scripting

Ich biete

IT, Entwicklung
  • Informatica
  • ETL
  • Business Intelligence (BI)
  • Datawarehouse / DWH
  • Oracle Database
  • SQL
  • Big Data
  • Apache Hadoop
  • Datenanalyse

Fokus
  • talend

Projekt‐ & Berufserfahrung

Informatica Powercenter Consultant
Commerzbank AG, Frankfurt
10/2017 – offen (1 Jahr, 4 Monate)
Banken
Tätigkeitszeitraum

10/2017 – offen

Tätigkeitsbeschreibung

Informatica Powercenter 10.1 Design, Architecture, Development & Support for Data Integration Project.

Eingesetzte Qualifikationen

ETL


Informatica Lead
Capgemini, Muelhiem an Der Ruhr
6/2015 – 5/2017 (2 Jahre)
Großhandel
Tätigkeitszeitraum

6/2015 – 5/2017

Tätigkeitsbeschreibung

Retail data warehousing project using Informatica Powercenter 9.6.1, Agile ETL development using SCRUM, SQL Server 2012, Oracle 12c, Data Modelling, Dimensional Modelling, ETL Architecture

Eingesetzte Qualifikationen

Informatica


Senior Informatica Consultant
HRS, Koeln
2/2015 – 6/2015 (5 Monate)
HOTEL
Tätigkeitszeitraum

2/2015 – 6/2015

Tätigkeitsbeschreibung

Informatica Powercenter Specialist, Informatica Development

Eingesetzte Qualifikationen

Informatica


Senior Informatica Consultant
HRS, Koeln
2/2015 – 6/2015 (5 Monate)
HOTEL
Tätigkeitszeitraum

2/2015 – 6/2015

Tätigkeitsbeschreibung

Informatica Powercenter Specialist, Informatica Development

Eingesetzte Qualifikationen

Informatica


Informatica Tech Lead
IBM Deutschland, Essen
5/2014 – 10/2014 (6 Monate)
Großhandel
Tätigkeitszeitraum

5/2014 – 10/2014

Tätigkeitsbeschreibung

The goal of this project was to create centralized Analytical and Reporting system for Karstadt Warehouse GmbH. The major part of the project was to replace existing SAP BW Reporting system with Informatica PowerCenter 9.5.1 for ETL and Cognos 10 for Reporting. Informatica PowerExchange 9.5.1 with BCI (Business Content Integration) & Data Integration using ABAP methods were used to connect to Karstadt SAP Retail system and read data from SAP Standard and Customized Data Sources. IBM Netezza 7 was used as Target system with Informatica PowerExchange for Netezza.

Eingesetzte Qualifikationen

Business Intelligence (BI), Datawarehouse / DWH, Oracle Business Intelligence (BI), Oracle Database, Oracle (allg.), SQL, RDB / RDBMS


Informatica Specialist
Deutsche Bank, Frankfurt
7/2013 – 3/2014 (9 Monate)
Banken
Tätigkeitszeitraum

7/2013 – 3/2014

Tätigkeitsbeschreibung

Auto Deployment

Deutsche Bank started this project to save huge time for deployment of all ETL components e.g. informatica powercenter workflows, informatica powerexchange data maps, parameter files, shell scripts,etc. This project helped Deutsche Bank to save time spend by deployers in deploying multiple environments, error free deployments and hence reduce cost.

Eingesetzte Qualifikationen

ETL


Senior Informatica Consultant
Deutsche Bank, Frankfurt
7/2013 – 12/2013 (6 Monate)
Banken
Tätigkeitszeitraum

7/2013 – 12/2013

Tätigkeitsbeschreibung

Informatica Specialist

SAP BP Integration

The major goal of this project is to provide SAP Business Partner data from SAP OPEN Hubs daily to various downstream applications. The initial load transferred around 1 billion records and daily delta/history load of around 5 million records. Informatica PowerCenter 9.1 and Informatica PowerExchange used to connect SAP BW source system and Oracle 11g as target system.


Informatica Consultant
Deutsche Bank, Frankfurt am Main
7/2012 – 6/2013 (1 Jahr)
Banken
Tätigkeitszeitraum

7/2012 – 6/2013

Tätigkeitsbeschreibung

Senior Informatica Consultant

Retail Banking - Savings Account Deposit Data Migration
This project involves migration of savings account deposits data from Mainframe IBM Z/OS systems to SAP Deposit Management application using PowerCenter 9.1 HF 1 and Power exchange 9.1. This involves reading data from flat files, mainframe data sets, oracle and writing data into flat files which will be then uploaded into SAP Deposit Management application. Power exchange 9.1 was used for the connecting to mainframe and reading of Mainframe data sets. ETL Informatica PowerCenter 9.1 was used for the extraction, transformation, and loading of data into the target systems. The project had only single load i.e. one time migration. This project involves data extract, transformation and loads of 250 to 500 million records.


Informatica Consultant
Deutsche Bank, Frankfurt am main
7/2011 – 6/2012 (1 Jahr)
Banken
Tätigkeitszeitraum

7/2011 – 6/2012

Tätigkeitsbeschreibung

Informatica Powercenter ETL Tool Development & Support for Data Migration and Data Integration Projects.

Retail Banking - Savings Deposit Accounts Integration
This project involves integration of savings deposit account data from SAP, Mainframe systems in to the Oracle enterprise data warehouse.
ETL activities includes loading of this data into Oracle enterprise data warehouse used for Retail banking reporting in Deutsche Bank, Germany. ETL Informatica PowerCenter 9.1 HF 1 was used for the extraction, transformation, and loading of data into the target systems. The project had several loads like Daily Loads, Weekly Loads, Monthly Loads, Quarterly Loads, and YTD Loads. These loads were implemented using Incremental Loading (Change Data Capture), and Slowly Changing Dimension Mappings. This project involves data extract, transformation and loads of 30 to 50 million records.


Senior Informatica Consultant
American Home Mortgage Servicing Inc, Texas
11/2010 – 7/2011 (9 Monate)
Banken
Tätigkeitszeitraum

11/2010 – 7/2011

Tätigkeitsbeschreibung

Informatica Powercenter Development and Support


Zertifikate

International Knowledge Measurement - Informatica Powercenter
Juli 2017

TOGAF 9.1 (Enterprise Architecture Framework) Certified Professional
Mai 2015

Informatica 9.5.1 Certified Professional
April 2014

Ausbildung

Bachelor of Engineering
(Computer science)
Jahr: 2007
Ort: Pune India

Qualifikationen

RDBMS - Oracle 11g/10g/9i, MS SQL SERVER 2005/08, Netezza 7
ETL Tools - Informatica Power Center 9.5.1, Power Exchange 9.5.1 for SAP, Mainframe , JMS & MQ.
Modelling – Data Modelling, Dimensional Modelling
Modelling Tools: PowerDesinger 16, Informatica Mapping Architect for Visio
Operating System- UNIX (Sun Solaris, Linux), Windows 7/Vista/XP
Languages – JAVA, SQL, PL/SQL, UNIX Shell scripting
Scheduler – Contorl-M, UC4, Informatica Scheduler
Version Control - Informatica Version Control, Subversion
Other Tools - Toad 9/8.5, PL/SQL-Developer, FTP, sFTP, WinSCP, FileZilla, Putty, HP Quality Center, Aginity Workbench for IBM Netezza

Über mich

- Having 10+ years of IT Consulting experience with emphasis on business requirements
analysis, ETL development, implementations, testing and production support of Data
Migration, Data Warehousing and Business Intelligence projects.
- Expert in development and designing of ETL methodology for supporting data
transformations using Informatica Power Center 9.5.1, Power Exchange 9.5.1
- Experience in creating Proof of Concepts using Informatica PowerCenter and
PowerExchange.
- Have experience in agile ETL Development using SCRUM method.
- Have experience in ETL design, ETL architecture using Informatica PowerCenter.
- Have experience in Informatica Mapping Architect for Visio for creating mapping templates for each Data Layer in DW.
- Have experience in Dimensional modeling and data modeling.
- Highly Skilled in ETL & Database Performance Optimizations.
- Experienced in analyzing business requirements and translating functional requirements
into technical design specifications like LLDs, JHBs.
- Experience in reading and writing data into Mainframe systems using Informatica Power
Exchange 9.1
- Experience in Informatica Powercenter administration tasks like installation, code
migration, etc.
- Worked with different data sources like Oracle, SQL Server, SAP BW, Mainframe Data
sets, Flat Files, XML files, JMS Queues and MQ queues.
- Hands on experiene in creating UC4 Job Handbooks for Informatica workflows.
- Hands on experience in writing, testing and implementation of the views, triggers,
stored procedures, functions, packages at database level using SQL, PL/SQL.
- Experience in relational database development using Oracle PL/SQL and SQL.
- Extensively worked on UNIX environments and Shell Script development.
- Hands on experience in handling large volumes of data in production environments.
- Worked on Unit Testing, Integration testing and Regression testing to verify load
order, time window and lookup with full load.
- Experience in leading onsite development team.
- Excellent aptitude to understand and meet client needs.
- Excellent communication, presentation, project management, leadership skills and a
very good team player and self-starter with ability to work independently and as part of
a team.

Persönliche Daten

Sprache
  • Deutsch (Grundkenntnisse)
  • Englisch (Muttersprache)
Reisebereitschaft
National
Arbeitserlaubnis
  • Europäische Union
Profilaufrufe
2725
Alter
36
Berufserfahrung
11 Jahre und 8 Monate (seit 05/2007)

Kontaktdaten

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

Jetzt Mitglied werden »