Guidewire Datahub developer

Job Requirements and Preferences :

Role : Guidewire datahub developer

Experience : 4 yrs to 10

Preferred Qualifications :

Preferred Knowledge / Skills :

Demonstrates expert abilities and extensive Application Managed Service projects and solutioning the Smartcomm integration with Guidewire Suite of applications on premises and SaaS, with proven success executing and leading all aspects of complex engagements within the Smartcomm application achieving on-time and on-budget delivery, as well as the following :

6+ years of experience as technical lead for Datahub and ETL tools

Strong understanding of data warehouse concepts and dimensional data modeling

Expertise with SQL queries, analytical services, reporting services

Experience with one or more SDLC methodologies

Expertise related to metadata management, data modeling, data model rationalization, and database products

Experience with data scripting and programming

Understands context of their project within the larger portfolio

Demonstrated a strong attention to detail

Possesses strong analytical skills

Demonstrated a strong sense of ownership and commitment to program goals

Strong verbal and written communication skills

Identifies and implements operational database requirements and proposed enhancements in support of requested application development or business functionality

Develops and translates business requirements into detailed data designs

Maps data between systems (in conjunction with Business Analysts)

Assists engineering and development teams as application data expert from physical data models to production implementations

Identifies entities, attributes, and referential relationships for data models using a robust enterprise information engineering approach

Creates tables, indexes, constants, and assist programmers with SQL, tuning and reviews

Participates in data analysis, archiving, database design, and development activities for migration of existing data as needed

Develops ETL interfaces from source databases and systems to the data warehouse

Works closely with application development teams to ensure quality interaction with the database

Job Functions :

(1) To be responsible for providing technical guidance or solutions

(2) To develop and guide the team members in enhancing their technical capabilities and increasing productivity

(3) To ensure process compliance in the assigned module, and participate in technical discussions or review.

(4) To prepare and submit status reports for minimizing exposure and risks on the project or closure of escalations.

Technologies

Guidewire PolicyCenter, BillingCenter, ClaimCenter and Conversion ETL tools

SQL competence (query performance tuning, index management, etc.) and a grasp of database structure are required.

Understanding of data modeling concepts.

Knowledge of at least one ETL tool (Informatica, SSIS, Talend, etc.)

Knowledge of different SQL / NoSQL data storage techniques

If interested people please share the cv to indumathi.j@pwc.com