6-9 years of Experience in P&C Insurance on Guidewire DataHub/InfoCenter Platform.
Specialist Certifications on DHIC.
Experience on SQL Server databases.
Able to create PL/SQL stored procedures.
Experience on Guidewire ClaimCenter/ PolicyCenter/ BillingCenter data models.
Experience on SAP BODS ETL design & Administration.
Experience on Data Warehousing that includes analysis and development of Dataflows, mappings using needed transformations using BODS.
Experience in mapping Guidewire Insurance Suite of products (PC/BC/CC/CM) to DHIC.
Works with business in identifying detailed analytical and operational reporting/extracts requirements.
Experience building downstream extracts using DHIC.
Able to create Microsoft SQL / ETL complex queries.
Experience on Updating Data Specifications
Experience on DataHub and InfoCenter Initial loads and Delta loads.
Experience on DataHub and InfoCenter Guidewire Commit and Rollback utility.
Experience on Extending entities & attributes in DataHub and InfoCenter
Experience on Ref & Config Data spreadsheet maintenance.
Experience on Scheduling loads, solving integrity check issues, and balancing errors.
Experience on performance improvements on SAP BODS workflows especially on SQL database as source.
Works with business in identifying detailed analytical and operational reporting/extracts requirements.
Must have at least one DHIC on-premises to DHIC Cloud Upgrade experience
Good to have Skills:
SAP BODS administration, CICD.
Data Modelling Experience.
Mentioned above.
Mentioned above.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: ETL DeveloperEmployement Type: Full time