Technical Architect – ETL

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.

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.

Gathers
files from the client and consults with the client to gather data feed layouts.
Creates
ETL scripts using Informatica Powercenter. Works
closely with the Business Analyst, to ensure that the end to end designs meet
the business and data requirements.Works
closely with the PM to develop and update the task plan for ETL work, to keep
the manager aware of any critical task issues and dependencies on other teams,
and ensure that the end-to-end designs meet the business and data requirements.Deploys
ETL scripts to productionized servers, and automating the load process.

[Any
Salesforce skill would be desirable, but not necessary]

Qualifications:

Ability
to work alone or as a team member. Must be self-motivated and require minimal
management to complete tasks on time.Excellent
communication skills are a necessity. This role will work directly with clients
when gathering source files and file definitions.Ability
to pick up and extend new technologies quickly.Ability
to do ETL development using Informatica Powercenter 9.x.Have
Unix experienceHave
experience with a scheduling tool (Autosys/Ctrl M/etc)Must
have a sound understanding of relational structures, dimensional data modeling,
structured query language (SQL) skills, Good
knowledge and hands on experience working with data in multiple formats such as
XML, CSV, Flat files , etc.Prior
experience working with Insurance organizations is a plus