Architect; ATC- Data Integration

Position: Architect (ATC)- Data Integration
Location: Bengaluru

Collaborate with business stakeholders, data architects, and IT teams to gather and understand data migration requirements.
Analyze legacy banking and insurance systems (e.g., core banking, policy admin, claims, CRM) to identify data structures and dependencies.
Work with large-scale datasets and understand big data architectures (e.g., Hadoop, Spark, Hive) to support scalable data migration and transformation.
Perform data profiling, cleansing, and transformation using SQL and ETL tools, with the ability to understand and write complex SQL queries and interpret the logic implemented in ETL workflows.
Develop and maintain data mapping documents and transformation logic specific to financial and insurance data (e.g., customer KYC, transactions, policies, claims).
Validate migrated data against business rules, regulatory standards, and reconciliation reports.
Support UAT by preparing test cases and validating migrated data with business users.
Ensure data privacy and security compliance throughout the migration process.
Document issues, risks, and resolutions related to data quality and migration