Freelance INFORMATICA : repérez les talents nécessaires à votre projet

Déposez votre CV ou Déposez une mission gratuitement
Nos derniers

freelances INFORMATICA

Nos dernières

offres de missions INFORMATICA

Les freelances maîtrisant

INFORMATICA

ont aussi postulé à

INFORMATICA : spécificités

INFORMATICA est un fournisseur de produit spécialisé dans l'intégration de données d'entreprise. A l'aide des produits INFORMATICA, les organisations de tous types peuvent accéder, intégrer, migrer et consolider les données générées et utilisées par l'ensemble de leurs systèmes pour faciliter l'accès et l'exploitation des données. L'un des produits phares d'INFORMATICA est PowerCenter.

Exemple de missions d'Abderrezek, freelance INFORMATICA résidant dans les Hauts-de-Seine (92)

Skills

Apex programming Visualforce, triggers, classes, web services, API integrations, Bulk API, SOQL, Asynchronous Apex.
Front-end HTML, JavaScript.
IDE Force.com IDE, Sublime Text.
Salesforce Analytics wave analytics designing datasets, creating dashboards.
Data loading Data loader, Autorabit professional data loader , Informatica Cloud TDM .
Data visualization Tableau software, Google Charts.
Informatica Powercenter 8.6/9.1, 9.6.1,10.1.1.
SQL, PL/SQL.
Data modeling.
DBMS Oracle, SQL Server, MySQL
System Unix/Linux, Shell programming.
Languages C#, Java, PHP.
Others Control-m, Business Objects, postman, SoapUI

Certifications

2017 Salesforce AMD 201, Platform Developer I
2011 Oracle 11g OCA Oracle PL/SQL Developer Certified Associate 1Z0-144.

Professional Experience

March 2016-Today ALD AUTOMOTIVE

Salesforce Automation workflows, process builder, and visual workflows.
Salesforce development triggers, classes, Visualforce pages, Visualforce controllers.
Administrating users profiles, permission sets, roles.
Salesforce analytics designing datasets, dashboards, customizing the generated Json.
Integrating google charts in Salesforce for better data visualization.

As team lead of the ETL platform Broker

Responsible of Salesforce data integration using Informatica ETL 43 countries daily batchs integrations, real time integration Informatica real time, SOAP API , Soap web service.
Managing Powercenter platform servers migration, version upgrade, certificate installation, managing the ETL development team supervising developments, workload estimate, deliveries, quality check.

October 2014-February 2016 1 year and 5 months SOCIETE GENERALE FINANCE

BQSYLIQ project the aim is to deliver liquidity ratios including BASEL 3 LCR, NSFR and others

Design and development of the new features of BASYLIQ system including

Informatica mappings and workflows development
Shell ksh programming,
Development of stored procedures, SQL queries
Tuning of SQL queries, PL/SQL objects, and Informatica mappings
Execution automation control-m Jobs creation
Production support, analyzing and resolving execution issues
Using partitioning in most of the data-warehouse tables in order to improve the queries performance.

Technical environment PowerCenter 9.6.1, Oracle 11g, Ksh shell programming, control-m, ClearCase versioning software , HP Agile, Business Objects

March 2014-September 2014 7 months ERDF Électricité Réseau Distribution France

ETL Plateform migration from Informatica 9.1, Unix Solaris, Oracle 10g to Informatica 9.5, Linux Red hat, Oracle 11g, perfective and adaptive maintenance of the PDM application.
- Informatica administration Informatica software installation, domains and services configuration, creation of users, grant privileges to users.
- Informatica version upgrade from 9.1 to 9.5 repository containing all the mappings/workflows of the application.
- Installation of PDM application on the Red hat Linux server.
- Database configuration, users management, privileges, tnsnames, listener.
- Ksh scripts adaptation to the Linux Red hat server.
- Acceptance test plan, performance test plan, and data migration guidelines.
- Perfective and adaptive maintenance of the PDM application mappings, workflows maintenance.

Technical environment PowerCenter 9.1, 9.5, Oracle 10g/11g, Ksh shell.
June 2013-February 2014 9 months Tarkett flooring and sports surfaces

Development of Informatica mappings, workflows taking into account performance aspects to load the data warehouse, data-marts
Design of the mappings and job chain stages
Creating the database tables, indexes\u2026
Creating SQL server stored procedures
Managing partitioning in SQL server tables
Unit testing and delivery management

Technical environment PowerCenter 9.1.0 Informatica , SQL server 2008 R2, T-SQL, stored procedures, partitioning, SAP.
January 2012-May 2013 one year and five months Bouygues Telecom telephone company

Develop High Level, detail-level ETL design including data capture, integration, data staging, transformation and aggregation.\u200b
Development of the new functionalities database design, Shell scripting programming to process data and run Informatica Mappings
Conducting analyses of ETL processes and suggest improvements, database tuning, SQL, PL/SQL performance improvement. \u200b
Creation of technical documentation such as high level design, design Proposals, low Level detailed Design and Implementation specifications for ETL processes.\u200b
Installation and configuration of informatica software server and client tools, creation of the repository database, creation of the repository and integration services.
Release management using IBM Rational Synergy
Training of new consultants.

Technical environment PowerCenter 9.1.0 Informatica , Oracle 10g, Unix, Shell, SQL, PL/SQL, MDM IBM infosphere, SIEBEL CRM, Oracle OBIEE, Teradata, IBM Rational Synergy

July 2011-December 2011 6 moths BNP CARDIF insurance company

Within BNP insurance CARDIF, an insurance company, in the \u201cInterfaces and Master I\u201d team \u201cMaster I\u201d is an insurance Business software used by the BNP to manage life insurance contracts .

System evolution, adaptive, perfective, and corrective maintenance using Informatica
PL/SQL development
Optimization of Informatica workflows and processes
SQL and PL/SQL optimization
Analyze and process of the production incidents

Technical environment PowerCenter 8.6.0 Informatica , Oracle 11g PL/SQL, Unix Shell
July 2010-June 2011 one year Sodexo incentive services

Carry out several incentive services restaurant tickets, baby-sitting services, giveaway services, transport services, culture services.

Data Model evolution
Evolution and corrective maintenance of the web services PL/SQL managing the back office\u2019s checks and cards command requests.
Creation and evolution of the PL/SQL packages including stored procedures, functions, triggers, collections, dynamic SQL and PL/SQL, exceptions handling\u2026
SQL and PL/SQL requests optimization
Management of the clients refund checks reception, checking and validation of the payment transactions, XML refund files generation PL/SQL programming .
Technical advice to the team members about the developments and queries optimization.
Optical service project aiming to letting elders who don\u2019t benefit of the CMU health insurance complementary to have access to a high quality French made glasses along with the best individual optical service

Database data model design.
Web services development PL/SQL
Application test.
Data loading based on excel files supplied PL/SQL procedures and functions
Technical accepting testing
Resolution of technical and business issues, communicate with the final clients and perform solutions.

Technical environment Oracle 10g, PL/SQL, Shell linux, XML, web services

October 2008-June 2010 one year and six months Macifilia Macif Paris

Macifilia is a MACIF subsidiary was committed to reshape and modernize its offer, to optimize and organize its management using a new open, nimble, and effective information system, capable to carry his offer, in order to provide a consistent approach and reduce costs
Assignment
Within the Migration team of five consultants in coordination with a Project Manager, I carried out the migration of several insurance products toward the business software Wynsure.

Analyze of the data bases Oracle, AS400, Access containing insurance products data.
Database design.
Conception and development of data loading using Informatica Powercenter, quality assessment, test and following their deployment in the several environments acceptance tests, full deployment.
Account for work load estimation, and issues encountered.
PL/SQL implementation of data extraction complex queries, procedures, functions, performance enhancement.
Adaptative and corrective maintenance.

Technical environment PowerCenter 8.6 Informatica , Oracle 10g, PL/SQL

March 2008-September 2008 7 months, Internship TRACE ONE PARIS

Study and implementation engineer
Trace one is the leader in e-collaborative solutions in SaaS mode Software as a Service , of the MDD own-brand products for big retail chains and national brands for the suppliers and the food-processing industrials of all sorts.

Assignment
Implementation of the Business Intelligence part of the trace one collaborative application.

Self-training of the MS reporting services tool.
Analyze of the existing database data modal.
Design and implementation of the reporting database based on the global existing one.
Implementation of T-SQL stored procedures for the selection of the data used in the reports performance improvement, dynamic management of filters depending on the user choices.
Reports implementation using SQL reporting services, filtering parameters management using C#, Reports graphic interface\u2019s implementation using ASP.net, handling the authentification and security access.

Technical environment SQL Server 2005, PL-SQL, Visual Studio 2005, MS Reporting Services, ASP .net, C#

Languages
English, French, Arabic fluent

Education
2008 Master 2 Degree in computer Science, from the University of Poitiers.
Special
Current driving license
Interest

Voir le profil complet de ce freelance