Job Title: Informatica Developer with Insurance Industry Experience
Location: Woodland Hills, CA (Onsite)
Duration: 4-6 Months
Rate: $68.00 Per Hour C2C All Inclusive

New Capgemini Onboarding Process Updates:
Due to additional onboarding requirements, a meet and greet is required for all new hires.
Selected candidates must be willing to go to the closest Capgemini/Client office location as indicated by the project team to meet and greet with a Capgemini team member prior to starting their assignment.
If the candidate is not local, Capgemini will pay the expenses.

Responsibilities:
Proficient in project management activities, encompassing planning, design, scope definition, estimation, resource administration, client interaction for understanding change requests and project delivery.
Delivering end to end projects in Agile and Waterfall model within stipulated timeline.
Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.
Gather requirements and business process knowledge in order to transform the data in a way that's geared towards the needs of end users.
Ensure that the Data Architecture is Scalable and Maintainable.
Work with the business in designing and delivering correct, high quality data.
Manage the resource and project effectively.

Required Skills:
Knowledge with experience of at least one ETL tool (SSIS, Informatica PowerCenter, IICS, Talend, etc.).
SQL knowledge (Query Performance Tuning, Index Maintenance, etc.) as well as an understanding of database structure.
Knowledge of Data Modeling principles.
Knowledge with experience on writing PL/SQL, Stored Procedures.
Knowledge with experience on writing Shell Scripts.
Knowledge of Guidewire Claim Center Data Model.
Domain knowledge on Property & Casualty, Auto and Workers Comp insurance.
Knowledge on GitHub, Rally.
Passionate about complex data structures and problem solving.

Primary Skills:
Informatica PC, IICS, Unix/Linux Shell Scripting, DB2, Jenkins CI/CD.