Data Architect with Credit Card Industry Experience

Role: Data Architect with Credit Card Industry Experience

Location: Wilmington, DE

Client: Banking

Type: Contract

Start Date: ASAP

Roles & Responsibilities

The Credit Card Systems Conversion Data Mapping Specialist is responsible for analyzing, mapping, and migrating data between legacy and new credit card 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.

Technical Skills
Data Mapping & Migration: Experience with data mapping, data migration, and ETL (Extract, Transform, Load) processes.
Database Knowledge: Proficiency in SQL, relational databases (Oracle, SQL Server, DB2), and data Modeling.
Credit Card Systems: Familiarity with major credit card processing platforms (e.g., TSYS, FIS, First Data, etc.).
Data Quality & Validation: Skills in data validation, cleansing, and reconciliation.
Business & Domain Knowledge
Credit Card Operations: Understanding of credit card lifecycle, transaction processing, account management, and compliance (PCI DSS).
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.

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.

Key Responsibilities

• Analyze existing credit card 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.

Alchemy: Transforming Your Professional Vision into Reality

Since our inception in 2013, Alchemy has been dedicated to reshaping organizational performance through innovative IT services. With a vision to empower businesses seeking a transformative edge, we ve positioned ourselves at the forefront of digitization and software modernization.

Our name reflects our mission: to transmute technology into gold-standard solutions for our esteemed clients. We proudly serve a diverse range of sectors, including IT and ITES, BFSI, Telecom and Media, Automotive, Manufacturing, Energy, Oil and Gas, Real Estate, Retail, Healthcare, and more.

With a global footprint spanning the USA, India, Europe, Canada, Singapore, Japan, and parts of Central and West Africa, we harness a unique blend of competencies, frameworks, and cutting-edge technologies. Together, we drive growth and innovation across industries, helping organizations turn their visions into reality.

Alchemy Connecting Talent with Opportunities (Diversity, Equity and Inclusion)