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.
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:
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