US Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Corp-Corp
W2-Permanent
W2-Contract
Contract to Hire
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 5th Dec 2023
Works with business stakeholders and IT application teams to define data needs for the enterprise data warehouse
Creates source (GW PC) to target (DWH) mapping documents to capture application data elements for loading from source systems into the enterprise data warehouse
Collaborates with ETL team to ensure that source to target mappings are correctly translated into ETL code
Performs data validation to confirm data is moved into the data warehouse correctly
Works with reporting teams to assist them in understanding the data warehouse model and optimal ways to use it
TECHNICAL QUALIFICATIONS
5 + years P&C Insurance subject matter experience (GW Policy)
10 + years of data analysis experience extracting OLTP data specifically for a data warehouse
Advanced SQL knowledge working with extracting data from OLTP applications
Extensive knowledge of Data Warehousing, ETL and BI Architectures, concepts and frameworks
Capable of creating and tuning Semantic layer Reporting Views
Capable of facilitating data discovery sessions involving business subject matter experts
Knowledge of RDBMS platforms (e.g. SQL Server, DB2) with experience in generating DDL
GENERAL QUALIFICATIONS
Knowledge of Guidewire Policy Center, Guidewire Claims Center applications and their data is a huge plus
Strong interpersonal skills and ability to work as part of a team