Overview
We are seeking a Data Consultant to support a financial services firm with data migration initiatives. The consultant will apply their expertise in data analysis, mapping, cleansing, and validation while collaborating with technical teams to ensure the successful migration of complex datasets in compliance with industry standards.
Responsibilities
- Analyze and profile large datasets using SQL to identify data anomalies and quality issues.
- Define source-to-target mapping rules and transformation logic for accurate data migration.
- Investigate and apply transformation rules to resolve data quality issues and standardize formats.
- Perform data reconciliation through source-to-target comparisons and validation checks to ensure accuracy.
- Support ETL and migration testing by executing validation scripts and analyzing test results.
- Maintain data quality by documenting migration rules and ensuring compliance with financial services standards.
Requirements
- Proven experience in data analysis and profiling using SQL, with a focus on large datasets.
- Expertise in source-to-target data mapping for ensuring accurate data migration.
- Strong background in data cleansing and transformation, with attention to detail for resolving inconsistencies.
- Experience in data reconciliation and validation processes.
- Familiarity with ETL processes and migration testing methodologies.
- Knowledge of data quality governance and compliance in financial services.