ETL/ Datawarehouse Developer (Informatica, Oracle)

freiberufler ETL/ Datawarehouse Developer (Informatica, Oracle) auf freelance.de
Referenzen
offline
Verfügbarkeit einsehen
National
hi  |  en  |  de
auf Anfrage
50674 Köln
19.10.2018

Kurzvorstellung

Several years of BI projects, Informatica, OBIEE, ETL, exceptional analytical strengths, outstanding team-player work ethic, exemplary leadership talents

Ich biete

IT, Entwicklung

Projekt‐ & Berufserfahrung

Sr. ETL Consultant
ROVI Corp., Santa Clara
1/2012 – 8/2012 (8 Monate)
Medienbranche
Tätigkeitszeitraum

1/2012 – 8/2012

Tätigkeitsbeschreibung

Working on providing ETL solutions using Oracle IPM ( Intellectual Property Management).
Created datawarehouse to support IPM and working on oracle cubes.

Environment: Informatica 8.6, Oracle 10g/11g,OBIA 7.9, OBIEE, cubes,Unix


Datawarehouse Consultant
Sears Holding, Chicago
5/2011 – 12/2011 (8 Monate)
Konsumgüterindustrie
Tätigkeitszeitraum

5/2011 – 12/2011

Tätigkeitsbeschreibung

Supporting different applications and databases, datawarehouse, ODS etc. platforms.
Daily role and responsibilities are performance tuning, upgradation and maintenances.

Environment: Informatica 8.6, Oracle 10g/11g,OBIA 7.9, Hyperion,Unix


Sr. ETL Developer/BI Consultant
Cal Water, San Jose
7/2010 – 4/2011 (10 Monate)
Versorgungswirtschaft
Tätigkeitszeitraum

7/2010 – 4/2011

Tätigkeitsbeschreibung

We have implemented the OBIA solution at the client site. Expert in DAC, Informatica configuration and implementation.

Environment: Informatica 8.6, SQL 2008/2005,OBIA 7.9, Windows2003 R3


Sr. ETL Developer
JP Morgan Chase, Irving
1/2010 – 7/2010 (7 Monate)
Banken
Tätigkeitszeitraum

1/2010 – 7/2010

Tätigkeitsbeschreibung

Capturing and identification of default loans which come under the Obama Plans, Move them to the Mortgage Loan Modification

Environment: Informatica 8.6, IBM AIX 5, Oracle 10g, Apex MDR, Sybase, SQL2000/2005, Linux


Sr. Data Engineer
Alabama Powers, Birmingham
7/2009 – 12/2009 (6 Monate)
Versorgungswirtschaft
Tätigkeitszeitraum

7/2009 – 12/2009

Tätigkeitsbeschreibung

Creation of a Data Mart for reporting and monitoring the Power load, DTS conversion Project which required moving the Business logic in DTS to Informatica

Environment: Informatica 8.6, Oracle, Sybase, SQL 2000/2005, Linux


Sr. ETL Developer
20th Century Fox, Los Angeles
2/2008 – 6/2009 (1 Jahr, 5 Monate)
Medienbranche
Tätigkeitszeitraum

2/2008 – 6/2009

Tätigkeitsbeschreibung

Data Warehouse specialist, Integration of new business territories into existing EDW, Business reports and forecast for Fox clients (major retail/ distribution companies in the USA and around the world)

Environment: Informatica 8.5 X, Oracle, Teradata, SQL server 2000, UNIX, OBIEE


Sr.Informatica Developer
Cisco Systems, Inc., San Jose
4/2007 – 1/2008 (10 Monate)
High-Tech- und Elektroindustrie
Tätigkeitszeitraum

4/2007 – 1/2008

Tätigkeitsbeschreibung

Responsible for Designing and Creating Data Warehousing for LCMT system for Cisco HR IT using Informatica and Erwin/Viso. OBIEE was used for reporting purpose

Environment: Informatica 8X, Oracle, Teradata, UNIX, OBIEE


Informatica Developer
ADT Securities, Chicago
1/2007 – 3/2007 (3 Monate)
Dienstleistungsbranche
Tätigkeitszeitraum

1/2007 – 3/2007

Tätigkeitsbeschreibung

Responsible for transforming and loading data from various sources into Universal Customer Data Warehouse (UCDW) using Informatica

Environment: Informatica PowerCenter 7.1.4 (Workflow Manager, Work Flow Monitor, Designer), Oracle, UNIX, Trillium 7.7


Informatica Developer
Monitor Liability, Chicago
8/2006 – 12/2006 (5 Monate)
Versicherungen
Tätigkeitszeitraum

8/2006 – 12/2006

Tätigkeitsbeschreibung

Designing and developing mappings in Informatica for customer data warehousing, Report generation, developing the Slowly Changing Dimensions (SCD) type 1 and 2 for there Enterprise Data Warehouse (EDW) called Phoenix


Informatica Developer
US Cellular, Chicago
6/2006 – 7/2006 (2 Monate)
Telekommunikation
Tätigkeitszeitraum

6/2006 – 7/2006

Tätigkeitsbeschreibung

Strategic Development Framework (SDF) for process control infrastructure, ETL data load processes, Creation of sessions and workflows and worklets for various stages of SDF


Informatica Developer
LTD Commodities, Chicago
1/2006 – 6/2006 (6 Monate)
Konsumgüterindustrie
Tätigkeitszeitraum

1/2006 – 6/2006

Tätigkeitsbeschreibung

Migration project with main task of creating a one time mapping to load data in LTD’s customer database

Environment: Informatica PowerCenter 7x, SQL Server 2000, Window NT


Qualifikationen

SQL & PL/SQL, Oracle, SQL Server, Teradata, Sybase, DB2, Informatica PowerCenter, OBIEE, Microsoft Office (Excel, Word, Power Point, Access and Front Page), SAP, Windows XP/2000/98, UNIX and MSDOS

Persönliche Daten

Sprache
  • Hindi (Muttersprache)
  • Englisch (Fließend)
  • Deutsch (Grundkenntnisse)
Reisebereitschaft
National
Profilaufrufe
1128
Alter
38
Berufserfahrung
14 Jahre (seit 2005)

Kontaktdaten

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

Jetzt Mitglied werden »