
Closed
Posted
Paid on delivery
I’m preparing a full core-banking replacement and need a specialist who can take ownership of two critical streams: the end-to-end data-mapping strategy from our legacy systems into the new relational model and the final financial-statement reconciliation that proves every cent lands in the right place before we go live. You will design and document the mapping logic, build the ETL pipelines, and work side-by-side with our Portuguese-speaking finance and IT teams to validate each rule. Once the pipelines run, I’ll look to you to reconcile GL balances, customer positions, and every subsidiary ledger until we hit 100 % accuracy. Mock migration cycles are already planned by the wider programme team; your outputs must plug straight into those rehearsals so the data track never becomes the bottleneck. Our target stack is a modern relational database (SQL-based), so advanced SQL scripting, performance-tuning skills, and hands-on experience with enterprise ETL tools are essential. Prior work inside regulated banking environments—especially where accounting integrity was audited—is a must. Deliverables I expect from you • Comprehensive source-to-target mapping workbook, signed off by business and tech stakeholders • Automated ETL jobs (code + runbooks) ready for deployment in our CI/CD pipeline • Reconciliation artefacts: control totals, cross-checks, and executive summary proving 100 % balance agreement I’ll review each milestone against data-quality KPIs (completeness, accuracy, timeliness) and accounting tolerances of zero. If you thrive under tight cut-over deadlines, let’s talk.
Project ID: 40770921
39 proposals
Remote project
Active 4 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
39 freelancers are bidding on average $6,657 USD for this job

As an experienced finance and IT professional, I understand the intricacies of data management within banking systems and have successfully executed similar complex data migration projects in my 10+ year career, making me an ideal candidate for your core banking data migration lead role. My expertise spans from designing mapping strategies to building ETL pipelines and reconciling financial statements, exactly what you need for this project. I have firsthand experience working with enterprise ETL tools and modern SQL-based databases, crucial skills that align perfectly with your target stack. Notably, my experience includes working in regulated banking environments where accounting integrity is of paramount importance, a must-have quality you mentioned in your project description. From my previous projects, I understand the importance of data accuracy and have developed robust procedures to ensure 100% reconciliation.
$7,500 USD in 7 days
6.6
6.6

Greetings from Germany, I am an experienced IT professional with over 13 years of experience in software development, technical project management, database architecture, and enterprise application delivery. With over 7 years of experience in the financial sector, I bring a strong understanding of banking processes, financial data, and complex IT environments. At CANEI AG, I worked on financial solutions involving DATEV integration, invoicing, and financial planning databases. I also contributed to electronic invoicing projects and document approval workflow automation, including work related to Deutsche Factoring Bank. My technical expertise includes Microsoft SQL Server, database design, complex SQL queries, stored procedures, data structures, and enterprise system integration. As a Technical Project Manager, I can coordinate stakeholders, translate business requirements into technical specifications, manage risks, and ensure structured testing, data validation, and reconciliation. I combine hands-on technical knowledge with proven experience leading development teams and delivering complex IT projects. My focus is on data integrity, controlled migration processes, clear documentation, and reliable delivery. I would welcome the opportunity to discuss your core banking migration requirements and how my financial-sector experience and technical leadership can contribute to a successful project. Best regards, Shuja Ahmed
$10,000 USD in 90 days
6.1
6.1

⭐⭐⭐⭐⭐ Core‑Banking Data Mapping & Reconciliation Specialist ❇️ Hi My Friend, I hope you are doing well. I checked all of your project requirements and I can see you are looking for a data‑mapping and reconciliation specialist. You have no need to look any further as Zohaib is here to help you! My team is already doing 50+ similar projects for banking data migration. I will design a clear mapping workbook, build robust SQL‑based ETL pipelines and add automated reconciliation scripts, all delivered within your CI/CD flow and budget. I will also provide detailed runbooks and validation support in Portuguese. ➡️ Why Me? I can easily do your migration as I have 5 years of experience in SQL, ETL design, data mapping, financial reconciliation, banking regulations, performance tuning. Not only this, I have a strong grip on data quality testing, CI/CD integration and audit documentation. ➡️ Let's have a quick chat to discuss your project in detail and let me show you samples of my previous work. Looking forward to discussing with you in chat. ➡️ Skills & Experience: ✅ SQL Scripting ✅ ETL Development ✅ Data Mapping ✅ Financial Reconciliation ✅ Banking Compliance ✅ Performance Tuning ✅ CI/CD Pipelines ✅ Runbook Creation ✅ Data Quality Testing ✅ Audit Documentation ✅ Portuguese Communication ✅ Team Collaboration Waiting for your response! Best Regards, Zohaib
$6,000 USD in 2 days
6.3
6.3

I can support your core-banking migration with a structured approach to source-to-target data mapping, SQL-based ETL development, data-quality validation, and financial reconciliation. My focus is on traceable transformation rules, repeatable migration runs, and clear evidence that migrated data agrees with approved accounting controls. My proposed workflow includes reviewing legacy schemas, documenting field-level mappings, defining transformation and exception-handling rules, developing automated ETL scripts, and building reconciliation checks for GL balances, customer positions, and subsidiary ledgers. I would also prepare runbooks, validation reports, and CI/CD integration documentation to support mock migration cycles. I understand that zero accounting variance is a critical acceptance requirement. I would use control totals, record counts, balance comparisons, and exception reports to identify discrepancies and demonstrate reconciliation results rather than assume accuracy without evidence. To assess the scope, could you clarify which legacy systems and target database are involved, which ETL and CI/CD platforms you use, and whether finance-approved mapping rules already exist? I would also welcome details about the reconciliation tolerances and audit requirements. I can then propose milestones, validation checkpoints, and a realistic delivery plan aligned with your migration schedule.
$5,000 USD in 3 days
5.8
5.8

As we align the underlying data-mapping strategy of your legacy systems with the new relational model, I bring along extensive experience in delivering comprehensive source-to-target mapping workbooks as well as building robust ETL pipelines. Not only do I possess advanced SQL scripting skills, but also expertise in performance-tuning and hands-on experience with enterprise ETL tools. Having previously worked in regulated banking environments, my adherence to accounting integrity - which was audited no less - surpasses the most stringent of requirements. Ensuring 100% accuracy through GL balance reconciliations, customer positions cross-checks, subsidiary ledger verifications and more isn't just something I'm acquainted with but good at. Additionally, my knowledge of modern relational databases including oracle can be harnessed to ensure timely and seamless integration. My proficiency extends beyond just data migrations to automation & integrations which is definitely a big plus here.
$7,500 USD in 3 days
4.5
4.5

Hi, Fernando here, from Mexico. What matters most in moving your core banking data migration lead is keeping your rankings, customers and order history through the move. I'm a senior full stack developer with 12+ years of experience working with SQL, Data Processing and Data Analysis. For your core banking data migration lead, the real challenge is field mapping and URL redirects. A common issue: running the full import without a test batch, so one mapping error repeats across every record. My plan: first, map every field and URL and test-import a small batch. Then, run the full migration and set up 301 redirects. Finally, compare record counts and spot-check orders before go-live. I've done migration work in SQL, so I check early for duplicate SKUs and broken image links. A few questions to better understand the scope: 1. Does a plugin hold data like loyalty points? That data doesn't move by default, so I map it before importing. 2. Okay to freeze product edits during the final sync? I'd recommend a short freeze, so nothing changes mid-sync. 3. Need Cash on Delivery with pincode checks? COD is still common in India, and pincode checks cut failed deliveries. I can start right away. Happy to go over the details here in chat and suggest the best approach. Looking forward to hearing from you, Fernando
$6,300 USD in 20 days
3.7
3.7

<<<✔Consider it DONE✔>>> YO! I understand your project and I'm eager to help. With my extensive and diverse experience in web and data management, I believe I can excel in your project role as a Core Banking Data Migration Lead. Data mapping and reconciliation are my forte - having designed and documented complex mapping logics and built seamless ETL pipelines. My strong background in using SQL databases and enterprise ETL tools will enable me to deliver and validate the data with rigorous accuracy. Looking forward to being part of your project! You will surely be impressed by my work! Not sure what the next step is? I offer free and professional consultation -- I'm just a text away. All the very best, Josh
$7,500 USD in 2 days
2.8
2.8

Hi there, I can help structure the data migration process with clear source-to-target mapping, SQL-based ETL workflows, and automated reconciliation checks. My focus would be on documenting transformation rules, validating data completeness, and creating control totals and exception reports to identify discrepancies before cutover. I understand the importance of auditability and financial accuracy in core-banking migrations. I’d be happy to discuss your legacy systems, target database, ETL tools, and reconciliation requirements to determine whether my technical experience aligns with your programme. Best regards, Abdul Rehman
$7,669 USD in 7 days
2.6
2.6

Hi, Owning both data streams of your core-banking replacement, the source-to-target mapping into the new relational model and the reconciliation that proves every GL balance, customer position and subsidiary ledger lands to the cent, with outputs that plug straight into your mock migration cycles, is exactly what I can provide. I have worked with Oracle, SQL Server and DB2 for many years, my latest migration moved a hospital group's records from Oracle to MySQL with Apache Hop, every row carrying its source key so reruns never duplicated, and I built a multi-book accounting system with ledgers, period closing and bank statements matched against the journal. What you get: 1. The mapping workbook: every source field to its target with the transformation rule, the owner and a sign-off column for business and IT. 2. ETL jobs as code in your CI/CD with runbooks, rerunnable for each mock cycle and keyed on source IDs, so a rehearsal can be repeated without cleanup. 3. Reconciliation at three levels: record counts, amount totals per GL account and currency, and every subsidiary ledger tied back to the GL, with an exception list per cycle and an executive summary showing zero difference. Interest accrued between the last legacy batch and the extract, and rounding between decimal precisions, are checked first, since most cut-over breaks come from those two. Which legacy core are you moving from, and which ETL tool is the programme standardising on? Best regards
$6,000 USD in 60 days
1.0
1.0

Hello, I understand you need a core-banking migration specialist to lead data-mapping strategy, build production ETL pipelines, and execute 100% accurate GL/subsidiary ledger financial reconciliation alongside your Portuguese-speaking finance and IT teams. The goal is to deliver a fully audited, zero-tolerance data migration framework ready for mock cut-over rehearsals. Here’s what I can provide: * Source-to-target data mapping workbook covering legacy data structures to the target SQL relational model. * High-performance, CI/CD-integrated automated ETL pipelines with full error handling and audit logging. * Comprehensive reconciliation engine generating automated control totals, cross-checks, and GL balance verification reports. I bring over 4+ years of experience in SQL engineering, database architecture, complex ETL pipelines, data integration, and system migration logic. Just to clarify a few things: 1. What target SQL relational database engine will be used (e.g., PostgreSQL, Oracle, Microsoft SQL Server)? 2. Will documentation and stakeholder meetings require bilingual interaction (English/Portuguese), or is English sufficient for technical deliverables? Please come to the chat box to discuss more about your project. Best regards, Indresh Kushwaha
$7,500 USD in 7 days
0.0
0.0

Hello, I would like to apply for this core-banking replacement engagement. I am a Software Developer with 18+ years of experience building scalable backend systems for fintech, enterprise, and cloud-based applications. My background is particularly relevant to your two critical streams: legacy-to-target data mapping and financial reconciliation with zero accounting tolerance. I have hands-on experience with SQL-based relational databases, including PostgreSQL, MySQL, Oracle, and MS SQL Server, along with advanced SQL scripting, query optimization, and performance tuning. I also have practical experience in legacy system integration and data-migration design, including work on Indian GST data-migration design for a data lake. This involved understanding source-system structures, defining transformation and validation rules, and ensuring data completeness and accuracy across the target model.
$5,200 USD in 25 days
0.0
0.0

GURGAON, India
Payment method verified
Member since Nov 12, 2013
$15-25 USD / hour
$750-1500 USD
$2-8 USD / hour
$10000-20000 USD
$15-25 USD / hour
₹100-400 INR / hour
₹750-1250 INR / hour
₹750-1250 INR / hour
$5000-10000 USD
₹1500-12500 INR
₹12500-37500 INR
₹12500-37500 INR
$250-750 USD
₹750-1250 INR / hour
₹600-1500 INR
₹7000-12000 INR
$500-700 USD
₹1500-12500 INR
₹400-750 INR / hour
₹12500-37500 INR
₹12500-37500 INR
₹100-400 INR / hour
₹12500-37500 INR
₹12500-37500 INR
₹750-1250 INR / hour