Informatica Powercenter Certified ETL Entwickler

freiberufler Informatica Powercenter Certified ETL Entwickler auf freelance.de
Verfügbarkeit einsehen
National
de  |  en
75‐95€/Stunde
60489 Frankfurt am Main
16.07.2019

Kurzvorstellung

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

Ich biete

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

Fokus
  • talend

Projekt‐ & Berufserfahrung

Senior ETL Consultant
Commerzbank, Frankfurt
10/2017 – 3/2019 (1 Jahr, 6 Monate)
Banken
Tätigkeitszeitraum

10/2017 – 3/2019

Tätigkeitsbeschreibung

Job Type: Freelancer
Role: Senior ETL Consultant
Project
Compliance - AML Reporting - Singapore
This was a data Integration project which includes providing data from various banking applications like Murex Cash, Murex Equity, Murex Currency, etc. for compliance reporting.
Project Technology Stack
Source System: Flat Files, MS SQL Server
Target System: Oracle, Flat Files
ETL Tool: Informatica Powercenter 10.1
Other programming languages: Oracle SQL & PLSQL, Unix Shell Scripting, UC4 Scripting
Scheduling Tool: Automic UC4

Responsibilities:

- Participate in scoping, data quality analysis, source system data analysis, target system requirements, volume analysis, and migration window determination.
- Understand, analyze, and define business requirements.
- Design discussions with Business Analyst & Business users.
- Design mapping sheets and ETL Architecture.
- Design ETL jobs as per the quality and software development standards.
- Design and implement technical enhancements of Data Warehouse as required.
- Source to target data mapping analysis and design.
- Analyze, design, develop, test and document ETL programs from detailed and high level specifications, and assist in troubleshooting.
- Record, analyze, and implement customer requirements.
- Creation of project-related documents like HLD, LLD, etc.
- Complex ETL development and Quality Assurance.
- Design and develop various slowly changing dimension loads e.g. Type 1, Type 2, and Type 3
- Responsible for finding various bottlenecks and performance tuning at various levels like mapping level, session level, and database level.
- Extensive use of various active and passive transformations like Filter, Router, Expression, Source Qualifier, Joiner, and Look up, Update Strategy, Sequence Generator, Rank, and Aggregator.
- Debugging and troubleshooting Sessions using the Informatica Debugger and Workflow Monitor.
- Implement various loads like Daily Loads, Weekly Loads, and Quarterly Loads.
- Assist production migration team at client site in performing the final data migration/integration.
- Participate in Project Status Review meetings, Software Quality Control activities like defect prevention, etc.
- Conduct Integration test, business user test and stress test of the migration.
- Perform test using sample test data in accordance with the client data migration/integration needs.
- Contact point for problems in the Production environment and Defects Tracking with business. (3rd-Level-Support)
- Supported deployment team in various environment's deployments
- Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems

Eingesetzte Qualifikationen

Datawarehouse / DWH, ETL, Informatica


ETL Tech Lead
Aldi Sued, Muelhiem an der Ruhr
6/2015 – 9/2017 (2 Jahre, 4 Monate)
Konsumgüterindustrie
Tätigkeitszeitraum

6/2015 – 9/2017

Tätigkeitsbeschreibung

Job Type: Freelancer
Role: ETL Tech Lead
Project: Retail Enterprise Data Warehouse
Project Technology Stack
Source System: MS SQL Server, Flat Files, Oracle
Target System: Oracle Exadata
ETL Tool: Informatica Powercenter 10.1
Other programming languages: Oracle SQL & PLSQL, Unix Shell Scripting
Scheduling Tool: Informatica Scheduler
Project Methodology: Scrum/Agile

Responsibilities
- Participate in scoping, data quality analysis, source system data analysis, target system requirements, volume analysis and migration window determination.
- Analyze, design, develop, test and document ETL programs from detailed and high level specifications and assist in troubleshooting.
- Creation of project-related documents like HLD, LLD, etc.
- Implement various loads like Daily Loads, Weekly Loads, and Quarterly Loads.
- Perform data cleansing tasks.
- Perform test using sample test data in accordance with the client data migration/integration needs.
- Contact point for problems in the Production environment and Defects Tracking with business. (3rd-Level-Support)
- Helped Business Analyst in refining mapping specification documents.
- Developed Informatica Powercenter mappings to move data from stage to target tables
- Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements.
- Documented various input databases and data sources.
- Debugging and troubleshooting Sessions using the Informatica Debugger and Workflow Monitor.
- Complex ETL development and Quality Assurance.
- Responsible for finding various bottlenecks and performance tuning at various levels like database, ETL, etc.
- Created Materialized Views and partitioning tables for performance reasons.
- Worked on various back end Procedures and Functions using PL/SQL.
- Developed UNIX shell scripts to perform various user requirements.
- Designing Tables, Constraints, Views, and Indexes etc.
- Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems
- Tuned complex Stored Procedures for faster execution
- Responsible for Analyzing and Implementing the Change Requests .
- Involved in handling the changes in compiling jobs and scripts according to the database changes.

Eingesetzte Qualifikationen

Datawarehouse / DWH, Informatica


Senior ETL Consultant
HRS, Koeln
1/2015 – 5/2015 (5 Monate)
Dienstleistungsbranche
Tätigkeitszeitraum

1/2015 – 5/2015

Tätigkeitsbeschreibung

Job Type: Freelancer
Role: Senior ETL Consultant
Project: Hotel Enterprise Data Warehouse
Project Technology Stack
Source System: MS SQL Server, Flat Files, Oracle, XML
Target System: Sybase IQ
ETL Tool: Informatica Powercenter 9.5
Other programming languages: Oracle SQL & PLSQL, Unix Shell Scripting
Scheduling Tool: Control-M
Project Methodology: Waterfall
Data Modeling: Data Vault

Eingesetzte Qualifikationen

Informatica


Senior ETL Consultant
Karstadt, Essen
5/2014 – 12/2014 (8 Monate)
Konsumgüterindustrie
Tätigkeitszeitraum

5/2014 – 12/2014

Tätigkeitsbeschreibung

Job Type: Freelancer
Role: ETL Tech Lead

Project:
Karstadt information systems for measures and analytics (KARISMA)

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 and create new enterprise data warehouse 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.
Project Technology Stack
Source System: SAP, IDOC, Flat Files, XML
Target System: IBM Netezza
ETL Tool: Informatica Powercenter 9.5, Informatica Powerexchange 9.5
Other programming languages: Oracle SQL & PLSQL, Unix Shell Scripting
Scheduling Tool: Informatica Scheduler
Project Methodology: Waterfall

Eingesetzte Qualifikationen

Informatica


Senior ETL Consultant
Deutsche Boerse, Frankfurt
1/2014 – 4/2014 (4 Monate)
Banken
Tätigkeitszeitraum

1/2014 – 4/2014

Tätigkeitsbeschreibung

Job Type: Freelancer
Role: Senior ETL Consultant
Project: Data Integration

Eingesetzte Qualifikationen

Informatica


Senior ETL Consultant
Deutsche Bank, Frankfurt
7/2011 – 12/2013 (2 Jahre, 6 Monate)
Banken
Tätigkeitszeitraum

7/2011 – 12/2013

Tätigkeitsbeschreibung

Job Type: Employee & Freelancer
Role: Senior ETL Consultant

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

Projects:
#1 Retail Banking - Postbank Savings Deposit Accounts Migration
#2 Retail Banking - Postbank Savings Deposit Accounts Integration
#3 Retail Banking - Auto Deployment
#4 Retail Banking - LDAP Integration

Eingesetzte Qualifikationen

Informatica


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

11/2010 – 7/2011

Tätigkeitsbeschreibung

Job Type: Employee
Role: Senior ETL Consultant

Project :
Enterprise Data Warehouse

Eingesetzte Qualifikationen

Informatica


Software Engineer
Sigma Systems, Pune
10/2008 – 10/2010 (2 Jahre, 1 Monat)
Telekommunikation
Tätigkeitszeitraum

10/2008 – 10/2010

Tätigkeitsbeschreibung

Job Type: Employee
Role: Software Engineer
Oracle, Unix, Java Development & Support

Eingesetzte Qualifikationen

Oracle Database, Java (allg.)


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

ETL Tools
Informatica PowerCenter, Informatica Big Data Management,
Informatica Power Exchange, Talend

Databases
Oracle 12c, Oracle Exadata 12c, Microsoft SQL Server 2016,
MySQL, Netezza, Sybase IQ, HDFS
Big Data Technologies/Ecosystem
HDFS, YARN, MapReduce, Hive, Pig, HBase, Spark, Oozie, Flume and Sqoop

Modeling
Data Modeling, Dimensional Modeling, Data Vault
Modeling Tools
PowerDesinger, Informatica Mapping Architect for Visio

Software Development Methods
Agile, SCRUM, Waterfall
Programming Languages
JAVA, SQL, PL/SQL, UNIX Shell scripting
Scheduler
Control-M, Automic UC4, Informatica Scheduler

Version Control
Informatica Version Control, Subversion, Tortoise SVN
Other Tools - Hue, Eclipse, Toad, PL/SQL-Developer, FTP, sFTP, WinSCP, FileZilla,
Putty, HP Quality Center, Aginity Workbench for IBM Netezza


International Knowledge Measurement
Certificate: Informatica Powercenter
July 2017
Percentile: 93%

Informatica PowerCenter 9.x Certified Professional
Certificate No. 004-000384
March 2014
Percentile: 72%

TOGAF 9.1 (Enterprise Architecture Framework) Certified
Professional from OPEN GROUP
Certification ID. 96457
May 2015
Percentile: 75%

Über mich

- Having 10+ years of IT Consulting experience with emphasis on business requirements
analysis, ETL development, implementations, testing and production support of Data Lake, Data Migration, Data Warehousing and Business Intelligence projects.
- Expert in development and designing of ETL methodology for supporting data
transformations using Informatica Power Center 10.2/10.1.1/9.6, Power Exchange 9.5.1
- Experience in creating Proof of Concepts
- 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 10.2
- Experience in Informatica Powercenter administration tasks like installation, code
migration, connection setup, user access, etc.
- Worked with different data sources like Oracle, MS SQL Server, SAP BW, Mainframe Data sets, Flat Files, XML files, JMS Queues and MQ queues.
- Hands on experience in creating UC4 Jobs for Informatica workflows, shell scripts, etc.
- 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.

Persönliche Daten

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

Kontaktdaten

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

Jetzt Mitglied werden »