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