ETL Informatica developer

About Capgemini <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

With more than 170,000 people in over 40 countries, Capgemini is one of the world's foremost providers of consulting, technology and outsourcing services. The Group reported 2014 global revenues of EUR 10.5 billion. Together with its clients, Capgemini creates and delivers business and technology solutions that fit their needs and drive the results they want. A deeply multicultural organization, Capgemini has developed its own way of working, the Collaborative Business ExperienceTM, and draws on Rightshore®, its worldwide delivery model.

Learn more about us at http://www.capgemini.com/ .

 

Rightshore ® is a trademark belonging to Capgemini 

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. 

 

Job Overview:

ETL Informatica developer

 

Duties & Responsibilities: 

Provide technical option assessments as needed

Work with BAs to understand functional and non-functional requirements

Create detailed design specifications for ETL-related components

Develop ETL packages to extract, transform, and load source to target stores

Write and execute unit tests to ensure that development meets basic requirements

Collaborate with Data Modelers and DBAs to ensure necessary modeling and physical table creation completed to support deliverables

Collaborate with Release/Environment Management to triage and resolve batch errors in test environments

 

Skill, Experience & General information required:

Informatica development

Advanced SQL skills (especially with writing queries) 

6+ years of experience as an ETL Developer

Proficient with data mapping applications, data profiling tools, and metadata repository software

Proficient with relational databases (SQL Server, DB2) and experience with relational data modeling

Use-case analysis experience

Insurance business domain experience

 

Location :  West Bend, Wisconsin