Technical Specialist (IN)
HCLTech
HCLTech
Seeking a CIMax/DB2 Specialist to provide deep expertise for a legacy insurance applications and DB2 data modernization initiative. This role is pivotal in supporting data discovery, profiling, extraction, mapping, and migration of historical and operational data into the Databricks Lakehouse platform.
Collaborate closely with architects and domain teams to understand intricate legacy datasets, business rules, and data dependencies. Ensure precise transformation and reconciliation between legacy systems and target canonical models. Drive improvements in data quality, support regulatory and reporting needs, and help preserve institutional knowledge while facilitating a scalable, cloud-based analytics ecosystem.
Analyze CIMax and DB2 data structures, relationships, and business rules supporting crop insurance operations. Conduct data profiling, source system assessments, and mapping activities for migration to the Lakehouse platform.
Identify data dependencies, transformation requirements, historical retention strategies, and reconciliation controls. Partner with Guidewire, domain, and engineering teams to harmonize legacy and target-state datasets. Validate data completeness, accuracy, and consistency across migration cycles.
Support audit, regulatory, and operational reporting requirements. Troubleshoot source-system issues, document technical metadata, and offer expertise during SIT, UAT, production deployment, and hypercare phases to ensure successful modernization and business continuity.
Key skillsets include deep IBM DB2 Database Expertise, CIMax Application Knowledge, and experience with Legacy System Data Migration. Proficiency in SQL Performance Tuning & Query Optimization, Data Profiling, Mapping & Reconciliation, and Insurance Data Architecture & Integration is essential.
This position is based in India and requires specialized knowledge in navigating complex data modernization journeys within the insurance sector. Candidates should be adept at ensuring data integrity and supporting critical business functions through seamless data transitions.
HCLTech
IT Consulting