ETL Tester – FIS ALM (with Ambit) | SightSpectrum | Riyadh, Saudi Arabia

SightSpectrum; Riyadh; On-site; SAR 180,000 - 240,000; Full time

Job summary

SightSpectrum is seeking an experienced ETL Tester - FIS ALM (with Ambit) in Riyadh, Saudi Arabia. You will own end-to-end data validation for ALM data loads, validate source-to-target mappings, and test FIS ALM platforms including Balance Sheet Manager, Liquidity Risk, and Funds Transfer Pricing.

You will test SSIS packages, troubleshoot data mismatches, perform data reconciliation, and document test cases, defects, and data lineage while collaborating with treasury analysts and data engineers

Qualifications

• Bachelor's degree in CS/IT/Finance/Data Analytics or related field.
• 3+ years in ETL testing, data warehousing, or DB validation in banking.
• Hands-on with FIS ALM platforms and Ambit solutions.
• Strong ALM knowledge, treasury workflows, and financial risk metrics.
• Proficient in SSIS, stored procedures, and data migration pipelines.
• Solid SQL, data mapping, reconciliation skills, and end-to-end data lineage.
• Excellent documentation of test cases, defects, and resolutions.

Responsibilities

• Own end-to-end ETL testing and data validation for FIS ALM platforms.
• Validate source-to-target mappings and perform functional/regression testing.
• Test SSIS packages, staging tables, and data warehouse load scripts.
• Investigate data mismatches, load failures, and transformation errors.
• Document test cases, defects, resolutions, and data lineage maps.
• Collaborate with treasury teams, DBAs, and developers for audit-ready reporting.

Skills

ETL testing

Data warehousing

SQL

SSIS

Data validation

ALM concepts

Documentation

Education

Bachelor's degree in Computer Science / Information Technology / Finance / Data Analytics

Tools

Ambit

FIS ALM

Power BI

Tableau

Job description

Position Summary

SightSpectrum 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.

Detailed Job Description

As an ETL Tester - FIS ALM (with Ambit) at SightSpectrum 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.

Key Responsibilities

• 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.

Required Qualifications & Skills

• 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 full-time employment in Riyadh, Saudi Arabia (Application email: [e-mail]; WhatsApp: [phone]).

Nice-to-Have Skills

• Professional testing certifications such as ISTQB Certified Tester or database administration credentials.
• Hands-on familiarity with advanced BI reporting tools (Power BI, Tableau) and financial data visualization.
• Prior working experience in tier-1 banking institutions, financial consultancy firms, or fintech implementation partners.
• Advanced Python or shell scripting skills for automated data verification and test data generation.
• Bilingual proficiency in English and Arabic.

Application Information

• Recruiter: SightSpectrum Recruitment Team
• Contact Name: Rajeshwari Palaniappan (IT Recruiter)
• Email: [e-mail]
• Phone / WhatsApp: [phone] (WhatsApp only / No calls)
• Application URL: Unspecified
• Salary/Rate: Competitive and commensurate with banking experience
• Deadline: Open until filled
• Notice Period: Immediate joining preferred
• Contract Duration: Permanent / Full-Time (Riyadh, Saudi Arabia)

Recruitment Pro Tip

When applying for specialized banking ETL testing roles, ensure your resume explicitly highlights your FIS ALM platform experience, SSIS testing complexity, and financial data reconciliation methodology.