Senior Lead Informatica ETL Developer

About Capgemini

With more than 180,000 people in over 40 countries,
Capgemini is a global leader in consulting, technology and outsourcing
services. The Group reported 2015 global revenues of EUR 11.9 billion. Together
with its clients, Capgemini creates and delivers business, technology and
digital solutions that fit their needs, enabling them to achieve innovation and
competitiveness. A deeply multicultural organization, Capgemini has developed
its own way of working, the Collaborative Business Experience™, and draws on Rightshore®,
its worldwide delivery model.

 

Learn more about us at www.capgemini.com.

                                                                                           

Rightshore® is a trademark belonging to
Capgemini

 

Title: Senior Lead Informatica
ETL Developer

 

Job Description:

  • Responsible
    for the success of IT Transversal projects including developing and executing
    ETL and Data Quality projects.

  • Understanding
    of general ledgers (experience with GL data)

  • Understand
    and read Informatica code that has been written between the source systems and
    their OFSAA GL (target)

  • Troubleshoot
    and can dig in and identify the translation issues as data is transferred from
    source to target

  • Write
    technical specifications to be given to Informatica ETL developers

  • Manage
    the Informatica ETL / DQ environment

  • Support
    the internal ETL project developers to produce ETL code and projects as
    required.

  • Responsible
    of ETL/DQ implementations.

  • Responsible
    for application integration, development and deployment, following the bank and
    project charters

  • Help
    with data architecture, data warehousing and data mart modeling.

  • Consult
    with users, management, and technical personnel to clarify and validate
    business requirements.

  • Design
    innovative ETL/DQ solutions aligned with BNPP’s informational architecture.

  • Write/analyze
    functional requirements based on obtained business requirements.

  • Design
    ETL/DQ solutions and write ETL/DQ technical specifications.

  • Develop
    ETL interfaces and processes.

  • Develop
    DQ rules in accordance with the Data governance specifications.

  • Implement
    data integration best practices and conventions.

  • Develop
    PL/SQL packages and procedures by following the best practices / conventions
    within the team

  • Perform
    workload and risk analysis related to these solutions.

  • Help
    deploy application to UAT and production environments, and handle bug-fixes and
    implement possible system redesigns during these periods.

  • Insure
    quality of solutions by establishing strict code quality processes (design
    standards, code review)

  • Design
    testing strategy and elaborate test data sets.

  • Validate
    testing results.

  • Identify
    potential problems and proactively suggest changes and solutions.

  • Act
    as a reference for data integration and reporting solution.       

 

Others:

  • Behavioral
    skills:

  • Delivery
    focused

  • Being
    a true team player and effective communicator

  • Shows
    initiative, autonomy, self-motivated, self-starter

  • Experience
    working successfully in a multicultural environment        

 

Education/Experience/Skills:

  • BS
    in Computer Science or related IT field, or equivalent work experience
    required.

  • Very
    good knowledge in Informatica ETL (Power Center) and Data Quality.

  • Good
    track record in Oracle database development, i.e. good knowledge & practice
    of Oracle SQL and PL/SQL.

  • Good
    knowledge of data warehousing concepts and development methodologies.

  • Autosys
    experience or experience with other scheduling/monitoring tools

  • Must
    have strong technical and problem solving skill set (Banking industry
    experience is a plus)

  • Familiar
    with Waterfall development methodology (development lifecycle including source
    control)

 

Capgemini is an Equal Opportunity Employer
encouraging diversity in the workplace. All qualified applicants will receive
consideration for employment without regard to race, national origin, gender identity/expression,
age, religion, disability, sexual orientation, genetics, veteran status,
marital status or any other characteristic protected by law.

This is a general description of the Duties,
Responsibilities and Qualifications required for this position. Physical,
mental, sensory or environmental demands may be referenced in an attempt to
communicate the manner in which this position traditionally is performed.
Whenever necessary to provide individuals with disabilities an equal employment
opportunity, Capgemini will consider reasonable accommodations that might
involve varying job requirements and/or changing the way this job is performed,
provided that such accommodations do not pose an undue hardship.

 

Click the following link for more
information on your rights as an Applicant:
http://www.capgemini.com/resources/equal-employment-opportunity-is-the-law