Senior Applications Consultant - ETL Informatica

at  Capgemini

JOB DESCRIPTION

Title – Senior Applications Consultant - ETL Informatica
Job Location – Atlanta GA
Duration – Fulltime

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 modelling principles.
• Knowledge with experience on writing PL SQL Stored procedures.
• Knowledge with experience on writing Shell scripts.
• Knowledge of Guidewire Claim Centre Data Model.
• Domain knowledge on Property Casualty Auto and Workers Comp insurance.
• Knowledge on GITHub Rally.
• Passionate about complex data structures and problem solving

• 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 thats 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