ETL ArchitectZencon Group • Wilmington, DE, United States
ETL Architect
Zencon Group • Wilmington, DE, United States
2 days ago
Job type
- Full-time
Job descriptionProject Management & Analytical Skills Documentation : Experience in creating detailed mapping documents, data dictionaries, and conversion plans. Soft Skills Teamwork : Ability to work effectively in project teams, often under tight deadlines. 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. 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 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.
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.
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.
Nice to Have
Role and Responsibility : -
Create a job alert for this search
Architect • Wilmington, DE, United States
Related jobs
Earn at least $2310 driving with Uber when you complete your first 192 trips in 30 days.Driving is an easy way to boost your income while maintaining the flexibility your schedule requires (gig, pa...Show more Earn at least $2310 driving with Uber when you complete your first 192 trips in 30 days.Driving is an easy way to boost your income while maintaining the flexibility your schedule requires (gig, pa...Show more 
As the nation's largest producer of clean, carbon-free energy, Constellation is focused on our purpose : accelerating the transition to a carbon-free future.
We have been the leader in clean ener...Show more
Hub Group Final Mile is now hiring a Non-CDL Independent Contractor!.Box Truck with Liftgate Required & Pallet Jack Required.
Home Daily - Gross $500 - $750 per Day •.Appliance Delivery / Install...Show more
Recent CDL-A Grads – Start Your Trucking Career with Paid Training! .We’ve got the perfect opportunity to launch your career!.
We’re looking for motivated, safety-minded recent grads ready to hit th...Show more Earn at least $2310 driving with Uber when you complete your first 192 trips in 30 days.Driving is an easy way to boost your income while maintaining the flexibility your schedule requires (gig, pa...Show more Recent CDL-A Grads – Start Your Trucking Career with Paid Training! .Just got your CDL-A, We’ve got the perfect opportunity to launch your career!.
We’re looking for motivated, safety-minded recent ...Show more 
Job Title : Azure Data Architect.Skills : ETL, Azure, Databricks, Azure Synapse, Data Factory, Databricks, Azure SQL, and related services.
Location : Wilmington, Delaware.We at Coforge are hiring Azur...Show more As the nation's largest producer of clean, carbon-free energy, Constellation is focused on our purpose : accelerating the transition to a carbon-free future.
We have been the leader in clean ener...Show more As the nation's largest producer of clean, carbon-free energy, Constellation is focused on our purpose : accelerating the transition to a carbon-free future.
We have been the leader in clean ener...Show more 
The hiring range for this role is : .This is the lowest to highest salary we.A candidate's position within the.Note : No amount of pay is considered to be wages or compensation until such amount is ea...Show more
Be the Power Behind Every Perfect Delivery!.Are you detail-oriented, fast-moving, and ready to make a real impact? As an .
Acirc; on our E-Commerce Fulfillment Team, youâll pl...Show more
At Period Architecture, we are a residential firm specializing in designs that evoke a sense of place, legacy, and stewardship of a region.
We prioritize listening to our clients, building strong re...Show more
BCforward is currently seeking a highly motivated Lead Architect Job for an opportunity in Wilmington, DE Location!.Please note this is the target date and is subject to change.BCforward will send ...Show more Earn at least $2310 driving with Uber when you complete your first 192 trips in 30 days.Driving is an easy way to boost your income while maintaining the flexibility your schedule requires (gig, pa...Show more As the nation's largest producer of clean, carbon-free energy, Constellation is focused on our purpose : accelerating the transition to a carbon-free future.
We have been the leader in clean ener...Show more 
The TMC Enterprise Architect will own the execution the IT strategy and roadmap that supports the enterprise vision and mission.
In addition, the IT solutions will enable achievement of business goa...Show more As the nation's largest producer of clean, carbon-free energy, Constellation is focused on our purpose : accelerating the transition to a carbon-free future.
We have been the leader in clean ener...Show more
Flexible $ : Earn At Least $2310 For Your First 192 Trips, Guaranteed.
Uber • Trainer, PA, US
Full-time +1
Last updated: 2 days ago • Promoted
Drive with Uber : Earn at least $2310 when you complete 192 trips.
Uber • Marcus Hook, PA, US
Full-time +1
Last updated: 2 days ago • Promoted
Manager Engineering - CORP
Constellation Energy • Christiana, PA, US
Full-time
Last updated: 2 days ago • Promoted
Non-CDL Independent Contractor - Home Daily - Earn $500-$750 / Day
Hub Group Final Mile • Bridgeton, NJ, US
Full-time
Last updated: 23 days ago • Promoted
Recent CDL-A Grads – Paid Training
SkillConnect LLC • Smyrna, DE, USA
Full-time
Last updated: 30+ days ago • Promoted
Flexible schedule - Earn at least $2310 by driving 192 trips with Uber
Uber • Boothwyn, PA, US
Full-time +1
Last updated: 2 days ago • Promoted
CDL-A Trainee Entry Level
SkillConnect LLC • Smyrna, DE, USA
Full-time
Last updated: 30+ days ago • Promoted
Azure Data Architect
Coforge • Wilmington, DE, US
Full-time
Last updated: 1 day ago • Promoted
Engineer, Electrical Design
Constellation Energy • Rising Sun, MD, US
Full-time
Last updated: 1 day ago • Promoted
Engineer, Core Design Methods Fuels
Constellation Energy • Christiana, PA, US
Full-time
Last updated: 2 days ago • Promoted
Senior Solutions Architect
Blue Cross Blue Shield Association • Wilmington, DE, United States
Full-time
Last updated: 30+ days ago • Promoted
Bi-lingual E-Commerce Fulfillment Team Member
Bell Nursery • Bridgeton, NJ, US
Full-time
Last updated: 7 days ago • Promoted
Project Architect
Period Architecture, Ltd. • Malvern, PA, US
Full-time
Last updated: 14 days ago • Promoted
Lead Architect
BCforward • USA, Delaware, Wilmington
Full-time +1
Last updated: 5 days ago
Earn At Least $2310 For Your First 192 Trips, Guaranteed.
Uber • Marcus Hook, PA, US
Full-time +1
Last updated: 2 days ago • Promoted
Engineer, Electrical Analytical
Constellation Energy • Malvern, PA, US
Full-time
Last updated: 2 days ago • Promoted
Enterprise Architect - Manufacturing
Terumo Medical Corporation • Elkton, MD, US
Full-time
Last updated: 30+ days ago • Promoted
Engineer, Sr Fuels - PWR Design
Constellation Energy • Christiana, PA, US
Full-time
Last updated: 2 days ago • Promoted