Post Job Free
Sign in

Informatica PowerCenter Administrator

Location:
Calgary, AB, T2Y 4Y4, Canada
Posted:
March 03, 2013

Contact this candidate

Resume:

Professional Summary

To obtain an Informatica PowerCenter Administrator position that will

enable me to

utilize my experience in information technology

Technical Skills

. Languages : PL/SQL, SQL, JAVA, C

. Web Development: PHP, HTML, XML

. Database Systems: ORACLE (9i,10g, 11g), MICROSOFT SQL

Server (2005, 2008), MYSQL

. Operating Systems: WINDOWS (NT, 2003, XP), LINUX

. OLAP: ORACLE EXPRESS

. ETL: INFORMATICA POWERCENTER, TALEND OPEN,

STUDIO,MICROSOFT DTS

. Method: MERISE, UML

Soft Skills

A self-motivated individual, good time management

skills, pay attention to details, a

great problem solver, good communication skills, a

quick-learner, and a responsible

team player

Education

Oracle Database Administrator

2012

SAIT Polytechnic, Calgary, AB

Master of Economy and Management (IQAS)

2006-2007

University of Picardie, Amiens, France

Bachelor of Information Technology (IQAS)

2001-2005

University of Sfax, Sfax, Tunisia

Experience

Oracle Database Administrator

2012

SAIT Polytechnic, Calgary, AB

. Created and configured database in Linux and Windows

environment using command lines and GUI tools

. Created tables and constraints

. Created users, profiles and granted privileges

. Created materialized views for improving performance

. Loaded data into the database using SQL*Loader,

import/export, external tables, and data pump

. Developed and tested storage strategies and disaster-

recovery plan that guaranteed recovery performance and

high availability

. Established auditing plan

. Recovered lost objects and data files

Business Intelligence Developer

2008-2010

Business & Decision, Bordeaux, France

. Analyzed the production data in order to understand their

availability and semantic

. Interviewed the future Application Users to help complete

the book of Specifications

. Created repository, datawarehouse and data marts

. Imported source definition from different sources such as

tables, flat files (source analyser)

. Created target definition(target designer)

. Developed mapplet and mapping(mapplet and mapping

Designer)

. Created session, scheduled and executed jobs(workflow

manager)

. Leaded the application tests

. Created users and granted privileges

. Developed the application User Manual

. Trained Users

. Maintained and upgraded repository

. Tuned source queries and mapping(aggregator, lookup,

joiner, expression)

Business Intelligence Developer

2007-2008

Fininfo, Paris, France

. Benchmarked and tested business intelligence ETL and

report open tools and business intelligence ETL and

report none open source to Understand the advantages and

disadvantages of each tool and did a proposal for which

tools fit better according the reality of the Company

. Developed entity relational and datawarehouse models

. Designed and created cubes with SQL SERVER 2005

(Analysis services) to receive data

. Planned and implemented Extract - Transform - Load (ETL)

processes by using Talend Open Studio as ETL

. Extracted data from different sources(Excel, Mysql, Sql

Server), cleaned and loaded them into the cubes

Volunteer History

Volunteer Admin/Internet Advertisement/Research

2011-2012

Heart & Stroke Foundation of Alberta, Calgary, AB

Languages

Advanced ability to speak and write in French



Contact this candidate