Avaloq Migration Specialist

AMZ AI & TECHNOLOGY SOLUTIONS PTE. LTD.Singaporemycareersfuturezveřejněno 17. 11. 2026
Nutné:PythonDataFinTechLead

Role Summary

The Avaloq Data Migration Specialist is responsible for designing and executing data migration pipelines during core banking implementations, mergers, or system upgrades. You will collaborate with business analysts, legacy system architects, and banking operations teams to map complex financial records—including client static data, portfolios, securities, loans, and historical transactions—into the Avaloq Banking Suite with zero financial discrepancies.

Key Responsibilities

  • Data Analysis and Source-to-Target Mapping. Analyze legacy core banking databases and define detailed mapping rules to translate source fields into Avaloq's internal data structures and business objects.
  • ETL Pipeline Development. Build, optimize, and maintain Extraction, Transformation, and Loading (ETL) scripts using Oracle PL/SQL and Avaloq migration frameworks.
  • Data Cleansing and Quality Assurance. Identify corrupt, duplicate, or incomplete records in legacy systems. Establish data cleansing rules with business stakeholders prior to migration runs.
  • Reconciliation and Validation. Design automated reconciliation scripts to verify balances, positions, and static data between source systems and Avaloq across multiple mock migration cycles.
  • Mock Runs and Cutover Execution. Plan and execute dress rehearsals (mock migrations) to optimize runtimes. Lead technical data migration tasks during high-stakes go-live cutover weekends.
  • Defect Triage and Performance Tuning. Troubleshoot load errors, resolve data integrity issues, and optimize SQL queries to ensure large data volumes load within strict cutover windows.

Required Qualifications and Experience

  • Education. Bachelor’s or Master’s degree in Computer Science, Information Technology, Data Engineering, or a quantitative field.
  • Industry Experience. 4 to 8+ years of hands-on experience in core banking data migration, with at least 2–3 full-lifecycle Avaloq implementation or migration projects.
  • Database and Scripting Mastery. Advanced proficiency in Oracle SQL and PL/SQL, along with strong experience in Avaloq Script and Avaloq Migration Interfaces (AMI).
  • Avaloq Data Model Expertise. Deep understanding of how Avaloq stores core entities, including Business Partners, Containers, Positions, Orders, and Accounting structures.
  • Banking Domain Knowledge. Strong familiarity with private banking and wealth management instruments, such as equities, fixed income, derivatives, corporate actions, and credit facilities.
  • Analytical Rigor. High attention to detail with proven experience designing automated financial and count reconciliations to satisfy internal and external audit requirements.

Preferred Qualifications (Bonus)

  • Certifications. Avaloq Certified Professional (ACP) certification, particularly in Core, Migration, or Customization tracks.
  • ETL and Integration Tools. Experience with enterprise ETL platforms (such as Informatica, Talend, or SSIS) or scripting languages like Python for data pre-processing.
  • Regulatory and Compliance Awareness. Familiarity with data privacy laws, banking secrecy regulations, and audit trails required during cross-border or local banking migrations.