Job Summary

Role overview Experience 810 years Domain PC Insurance preferred Work model Offshore Hybrid Reports to Data Lead Insights Delivery Manager Primary skills Solid 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
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

Primary skills
Solid 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

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.

📌 Sr Specialist Architecture Kolkata
🏢 LTM
📍 Kolkata