Senior Specialist - Architecture

Role overview

Experience 810 years

Domain PC Insurance preferred

Work model Offshore Hybrid

Reports to Data Lead Insights Delivery Manager

Primary skills

Strong SQL and performance tuning

Balancing Control and reconciliation frameworks

Data warehousing concepts including SCD handling

ETL redesign and migration

ETL testing and sourcetotarget validation

Analytical and communication skills

Leading the Data Track

Secondary skills

Duck Creek Insights and Extract Mapper

PC Policy domain knowledge

APIintegration services RESTSOAP XMLJSON

SQL Server Azure SQL

Scripting for job automation

Agile with Azure DevOps or JIRA

Working with onshore teams

Roles and responsibilities 11 in the document include

Building Balancing Control between Duck Creek Policy and Insights Staging using record counts amount totals and exception reports

Validating data in the Policy schema tables in Insights Staging and the Insights Warehouse

Redesigning the Informatica ETL from Insights Warehouse to DIL and from DIL to PHLY Staging

Making Extract Mapper changes redesigning ETL and supporting APIintegration services for the Umbrella LOB

Writing sourcetotarget mappings tuning SQL and ETL performance fixing defects and supporting SITUAT and deployment in Agile sprints