ETL Informatica Senior Developer

3/2017 – 9/2017

'CLD' (Creditloss Database) project:
• ETL consulting: Development, optimization, Workflows analysis (reverse engineering)
• Integration of SAP data sources
Technical environment: Informatica PowerCenter 9.1, Power Exchange, Microsoft SQL Server 2014

Informatica

10/2013 – 7/2015

Migration Framework project:
• Design and Build of Informatica Workflows
• Defects/ Bugs analysis and resolving
• Assistance to the Production Team
o Monitoring (Jobs and Workfows)
o Documentation (instruction manual, planning documents)

Data Integration Platform (DIP) project:
• Consumer and Commercial data integration into an Open Data Store :
o Creation of sources in PowerExchange by importing Cobol copybooks
o Design and Build of Informatica Workflows : Data loading from source files to a staging, to an intermediate,
and then to a core database (relational model with constraints)
• Load management and scheduling process : Adaptation of a framework designed by Informatica company experts
o Controller workflows (Processing days and timeframe checking), scheduler workflows (scheduling)
o Scanner workflows (Landing directories scanning, filename validation)
o Worker workflows (Data processing)

Technical environment: Informatica PowerCenter 9.5, Power Exchange, Microsoft SQL Server 2012, Informatica Data Quality, SVN (Subversion)

Informatica

11/2012 – 7/2013

Data integration into a global sales Datamart :
• Design of the staging environment according to the sources format: Multiple data sources differing from countries
(Oracle application, Oracle CRM on demand, flat files)
• Modeling and data integration into a star-schema: Fact and dimension tables
• Design and Build of Informatica Workflows
• Support, dealing with tickets, coordination with an offshore team and business analysts

Technical environment: Informatica PowerCenter 8.6, Oracle 11g, UNIX, Oracle application, PL/SQL, UNIX shell scripting

Informatica

5/2012 – 10/2012

Senior ETL developer for GESTOR project:
• Interfacing Gestor (time clock software) to the Natixis Information System with Informatica workflows
• Design and Build of a PL/SQL project for a specific interface related to long-term sick leaves management.

Technical environment: PL/SQL, Informatica PowerCenter 8.6, Oracle 10g, UNIX, Dimension.

Informatica

4/2007 – 12/2011

From 2008 onwards: Additional management responsibilities which included:

• Responsible for a contract management reporting system
• Management of the BI systems development lifecycle : Versions, budget, planning
o Responding to customer requests: Viability study, cost and time estimates
o Participating in feedback forums
o Maintenance : Production monitoring and incident management
• Liaising with different departments (Business analysts, production and database administrators)
• Assisting the Hyperion software users
• Technical upgrading and adhering to company standards

From 2007: Senior ETL developer which included...

• Creating and loading of a new data warehouse (dimensional modeling)
• Reporting on issues and malfunctions related to a loading process
• Evolution of a geographic information system :
o Integration of a new source of data
o Implementation of a new geocoder component
• Development of an interface from «Fraudulent claims» Data warehouse
• Production of Hyperion reports from a « Distribution channel » Data warehouse
• Implementation of a Testing Framework (able to detect regression issues)
• Implementation of ClearCase software
• Testing latest versions of the versions, deployments to staging environment
• Documenting technical specifications

Technical environment: Informatica PowerCenter 8.6, PL/SQL, Oracle 9i-11g, Hyperion 8, ClearCase, Quality Center, UNIX

Informatica