Job description:-
* Data Mapping & Migration: Experience with data mapping, data migration, and ETL (Extract, Transform, Load) processes.
* Database Knowledge: Hands-On Proficiency in SQL, relational databases (Oracle, SQL Server, DB2), and data modeling.
* Data Quality & Validation: Skills in data validation, cleansing, and reconciliation.
* Data Architecture & Design : Experience with Data Transformation programs, creating and managing the data architecture roadmaps and designing and maintaining new and existing data schema's and designs.
* Business & Domain Knowledge :
* Good knowledge of Investment banking and Financial services domain.
* Regulatory Requirements: Awareness of financial regulations and data privacy laws relevant to credit card data.
* Project Management & Analytical Skills
* Requirements Gathering: Ability to work with business analysts and stakeholders to gather and document data mapping requirements.
* Problem Solving: Strong analytical and troubleshooting skills for resolving data discrepancies.
* Documentation: Experience in creating detailed mapping documents, data dictionaries, and conversion plans, Data Flow Diagrams, Epics and Features.
* Soft Skills
* Communication: Excellent verbal and written communication skills for collaborating with cross-functional teams.
* Attention to Detail: High level of accuracy and attention to detail in data mapping and validation.
* Teamwork: Ability to work effectively in project teams, often under tight deadlines.
Nice to Have
* Prior experience in Investment banking data transformations, data mapping, or similar financial services projects is highly preferred.
* Experience with large-scale data migration projects, especially in banking or payments industry.
* Programming Languages: Knowledge of scripting or programming languages (Python, Java, etc.) for data manipulation.
* Tools : Knowledge on Snowflake/DBT, Kubernetes, S3, Databricks etc.
Role and Responsibility :-
* The Data Mapping Specialist is responsible for analyzing, mapping, and migrating data between legacy and new processing systems. This role ensures the integrity, accuracy, and completeness of data throughout the conversion process, working closely with business stakeholders, IT teams, and vendors.
* Analyze existing Investment system data structures and identify mapping requirements for conversion to new platforms.
* Develop detailed data mapping documentation, including source-to-target mapping, transformation rules, and data dictionaries.
* Collaborate with business analysts, system owners, and technical teams to gather requirements and validate mapping logic.
* Design and execute data migration and ETL processes, ensuring data quality, consistency, and compliance with regulatory standards.
* Perform data validation, reconciliation, and troubleshooting to resolve discrepancies during conversion.
* Support testing activities, including unit, system integration, and user acceptance testing, by providing test data and validating results.
* Document conversion processes, mapping logic, and any issues encountered for future reference and audit purposes.
* Ensure compliance with PCI DSS and other relevant data privacy and security regulations.
* Provide post-conversion support, including data issue resolution and process optimization.