Application Support Specialist
Disclaimer: Hunt UK Visa Sponsors aggregates job listings from publicly available sources, such as search engines, to assist with your job hunting. We do not claim affiliation with LTIMindtree. For the most up-to-date job details, please visit the official website by clicking "Apply Now."
Key Responsibilities
Good Knowledge of Phinsys Insurance product Suite
Design and Develop ETL Processes Create robust ETL workflows to extract transform and load data from various sources into the data warehouse
IRIS Library Setup Cloning
Set up Rapport connections to new IRIS libraries
Clone staging dimension and fact control flows from existing IRIS libraries
Clone and configure staging tables dimension views and fact views including conformed and increment views
Update cloned control flow tasks and containers to reflect new connection strings naming conventions and source system codes
Testing Validation
Perform smoke tests on cloned control flows and views to ensure data quality eg uniqueness of natural keys completeness of joins
Adjust primary keys and surrogate key links as needed
Validate initial loads and incremental processing using inflight reconciliation
Documentation Issue Tracking
Clone and update mapping documents for each control flow type
Log issues and discrepancies in DevOps for tracking and resolution
Conduct schema comparisons and checkins for version control
Deployment Reconciliation
Integrate cloned control flows into master control flows
Update and execute initial load scripts postdeployment scripts and cleardown scripts
Modify MDS extracts and data fix procedures to include new source system codes
Redeploy TandemStaging and Tandem environments and validate data loads
Run technical and business reconciliations to ensure data integrity
Required Skills Experience
Strong experience with IRIS library architecture and ETL control flows
Proficiency in SQL schema comparison tools and data validation techniques
Familiarity with DevOps for issue tracking and deployment workflows
Experience with MDS extracts surrogate key management and reconciliation processes
Ability to work independently and collaboratively in a fast paced environment
Preferred Qualifications
Prior experience in data warehousing or BI development
Exposure to TandemStaging and Tandem environments
Knowledge of data governance and quality assurance practices
Copyright © 2025