Technical Data Analyst

*Responsibilities:* *Data Analysis & Data Profiling* · Perform detailed analysis and profiling ofsource and target system data to assess data quality, identify inconsistencies,and mitigate migration risks. · Analyze customer, KYC, onboarding, and referencedata to identify data quality issues, anomalies, and business impacts. · Conduct data discovery and assessment exercisesto understand data structures, relationships, and dependencies. · Define and monitor data quality metrics,baseline assessments, and governance controls throughout the migrationlifecycle. *Data Mapping & Migration Design * · Develop comprehensive source-to-target datamapping specifications. · Translate business requirements into detailedfunctional and technical specifications. · Define migration rules, transformation logic,enrichment requirements, validation criteria, and reconciliation processes. · Collaborate with business stakeholders toresolve data ambiguities, mapping gaps, and data-related issues. *Data Quality & Anomaly Detection* · Analyze data to identify anomalies, duplicates,missing records, and data inconsistencies. · Investigate root causes of data quality issuesand recommend remediation strategies. · Define and execute data quality controls toensure data integrity throughout the migration lifecycle. · Support data cleansing, enrichment, andremediation initiatives. *ETL & Migration Pipeline Validation* · Partner with ETL developers and technical teamsto validate migration pipelines and data transformation processes. · Review ETL designs, transformation logic, anddata processing workflows to ensure alignment with business rules. · Troubleshoot migration failures, exceptions,reconciliation discrepancies, and performance issues. · Validate data transformations and migrationoutcomes against agreed business requirements. *Testing & Reconciliation * · Design and execute migration testing activities,including User Acceptance Testing (UAT), mock migrations, dry runs, andproduction validation. · Perform detailed source-to-target reconciliationto ensure data completeness, accuracy, and consistency. · Validate record counts, data integrity,transformation results, and migration success criteria. · Support defect tracking, issue resolution, andtest result reporting. *Requirements:* · Proven experience working within Banking orFinancial Services environments. · Strong understanding of KYC/eKYC processes,customer onboarding, Customer Due Diligence (CDD), and regulatory compliancedata requirements. · Experience delivering large-scale datamigration, transformation, or modernization programs. · Strong hands-on experience with Microsoft SQLServer. · Advanced SQL development and querying skills,including complex joins, stored procedures, functions, views, Common TableExpressions (CTEs), performance optimization, and data validation queries. · Strong understanding of relational databases,data modelling, data warehousing concepts, and data migration methodologies. · Experience working with ETL pipelines, dataintegration processes, and data transformation workflows. · Demonstrated expertise in data profiling, datamapping, data reconciliation, data quality assessment, and root cause analysis. · Ability to analyze, interpret, and validatelarge and complex datasets. · Experience with source-to-target mapping,migration rule definition, and data validation activities. · Strong analytical, troubleshooting, andproblem-solving skills with the ability to identify data anomalies and driveresolution. · Experience in banking data transformation,migration, or regulatory data programs is highly preferred. · Knowledge of data governance principles and dataquality frameworks is advantageous. · Experience with data migration tools,frameworks, and automation solutions is preferred. · Knowledge of Power BI or other reporting andanalytics platforms is an added advantage. · Experience working in multinational or regionalbanking environments is preferred.