ETL Tester – FIS ALM; Ambit

Sight Spectrum is seeking an experienced, highly technical, and accomplished ETL Tester - FIS ALM (with Ambit) with a strong background in banking treasury and data validation to join our client engagement team on a full-time, permanent basis in Riyadh, Saudi Arabia. In this specialized banking data warehouse and ETL testing role, you will spearhead validating complex data pipelines, testing FIS ALM platforms (Balance Sheet Manager, Liquidity Risk, FTP), and ensuring absolute financial data integrity.

You will work closely with treasury analysts, database administrators, and software development squads to maintain carrier-grade reporting accuracy. Ideal candidates bring a robust academic degree in computer science or finance, deep practical mastery of Microsoft SSIS and ETL validation methodologies, and immediate availability for deployment in Riyadh.

As an ETL Tester - FIS ALM (with Ambit) at Sight Spectrum in Riyadh, Saudi Arabia, you will take full ownership of end-to-end data validation, source-to-target mapping verification, and functional testing for asset liability management solutions. Your day-to-day responsibilities encompass testing Microsoft SSIS packages, troubleshooting data mismatches, load failures, and transformation errors, executing financial data reconciliation, and performing functional and regression testing of ALM data loads and reports.

You will document test cases, defects, resolutions, and complete data lineage while collaborating with banking stakeholders. Working in a fast-paced treasury and banking technology environment, you will drive data quality and financial accuracy.

• Execute rigorous end-to-end ETL testing and data validation for FIS ALM platforms (including Balance Sheet Manager, Liquidity Risk, and Funds Transfer Pricing).
• Apply deep domain expertise in Asset Liability Management (ALM) concepts, treasury operations, and banking data flows.
• Test, validate, and troubleshoot Microsoft SSIS packages, staging tables, and automated data warehouse loading scripts.
• Investigate and troubleshoot complex data mismatches, load failures, data transformation errors, and field mapping issues.
• Perform detailed source-to-target mapping verification and financial data reconciliation across disparate banking systems.
• Conduct thorough functional testing of ALM data loads, financial calculations, regulatory reports, and dashboards.
• Execute comprehensive regression testing following ETL bug fixes, schema enhancements, and system upgrades.
• Support FIS ALM solutions and Ambit integrations, ensuring flawless end-to-end data pipeline performance.
• Document detailed test cases, test scenarios, defect logs, technical resolutions, and comprehensive data lineage maps.
• Collaborate proactively with treasury teams, data engineers, and project managers to ensure audit-ready financial reporting.

• Bachelor's degree in Computer Science, Information Technology, Finance, Data Analytics, or a related discipline.
• Minimum 3+ years of professional experience in ETL testing, data warehousing, or database validation within the banking and treasury domain.
• Hands-on professional experience testing and supporting FIS ALM platforms and Ambit solutions.
• Strong conceptual understanding of Asset Liability Management (ALM), treasury workflows, and financial risk metrics.
• Proven practical expertise in testing Microsoft SSIS packages, stored procedures, and complex data migration pipelines.
• Solid proficiency in source-to-target data mapping, reconciliation techniques, and SQL query writing.
• Excellent documentation skills covering test cases, defects, resolutions, and end-to-end data lineage.
• Professional availability for…