ETL Architect Job at Zencon Group, Wilmington, DE

Sk5yeVpwRnRuMHl2bWplL3E2aWRHSWUrNFE9PQ==
  • Zencon Group
  • Wilmington, DE

Job Description

Job description :-

  • 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, Financial, etc.).
  • Data Quality & Validation: Skills in data validation, cleansing, and reconciliation.
  • Business & Domain Knowledge
o Credit Card Operations: Understanding of credit card lifecycle, transaction processing, account management, and compliance (PCI DSS).


o Regulatory Requirements: Awareness of financial regulations and data privacy laws relevant to credit card data.
  • Project Management & Analytical Skills
o Requirements Gathering: Ability to work with business analysts and stakeholders to gather and document data mapping requirements.


o 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
o Communication: Excellent verbal and written communication skills for collaborating with cross-functional teams.


o ttention 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 credit card system conversions, 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.
Role and Responsibility :-
  • 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.
  • Key Responsibilities
  • nalyze 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.

Job Tags

Similar Jobs

InterSolutions

Experienced Apartment Leasing Consultant Job at InterSolutions

 ...Job Description Job Position: Leasing Location: Fairhope, AL 36532 Pay Rate: $17 - $19/hr Shift: Description: Advance Your Career as an Experienced Apartment Leasing Agent! Are you a property management professional ready to take the next step in your... 

Palm Palm

PASTRY COOK Job at Palm Palm

 ...discounts Flexible schedule Opportunity for advancement Now Hiring: Pastry Cook New Restaurant | Open Kitchen | Elevated Food in a Relaxed Space Open kitchen Concept that bakes with purpose, finishes with flair, and serves with heartand were looking for a... 

eTeam

Recruiter Job at eTeam

 ...Sourcer (Recruiter III) Location: Atlanta, GA (30328) Shift Hours: M-F (8 AM - 5 PM) Work Mode: REMOTE OPP Duration: 6 months...  ...pm local time ~ Start times can vary but must available and online during core hours Be online and available through Teams... 

Aveanna Healthcare

Aveanna Healthcare Private Duty Nurse LPN - Trach Child Job at Aveanna Healthcare

 ...and Company-Paid Life Insurance ~ Paid Time Off Available ~ Flexible scheduling- full-time, part-time, or PRN. Days, nights, and weekend shifts we will work with your availability!~24/7 Local support from operators and clinicians ~ Aveanna has a tablet in each... 

Independent Tree

Arborist/Tree Climber Job at Independent Tree

 ...duties in support of specific job assignments Learn to climb trees! Learn what it means to be a team member of a tree crew while...  ...standards Installing cabling & bracing systems Tree planting & care Tree Removal Properly maintain and operate all tools...