-
US Citizen
-
Green Card
-
EAD (OPT/CPT/GC/H4)
-
H1B Work Permit
-
UG :- - Not Required
-
PG :- - Not Required
-
No of position :- ( 1 )
-
Post :- 19th Apr 2022
- Works with business stakeholders and IT teams to define data needs for the enterprise data warehouse
- Creates source to target 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
- Knowledge of Guidewire Policy Center, Guidewire Claims Center, SAP FS-RI & SAP FS-CD applications and their data is a huge plus
- Strong interpersonal skills and ability to work as part of a team
TECHNICAL QUALIFICATIONS
- 5+ years of data warehouse experience
- 5 years P&C Insurance subject matter experience (Policy and Claims)
- Advanced SQL knowledge
- 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