ETL Developer

Job Description

• Analyze and understand data requirements for OFSAA ALM and IRRBB.

• Identify required data elements from source systems/data warehouse and prepare source-to-target mappings.

• Develop and maintain ETL processes for extracting, transforming, validating, and loading data into OFSAA.

• Understand the OFSAA/SASA data model, including key tables, fields, relationships, and dependencies.

• Develop transformation and derivation logic based on functional ALM/IRRBB requirements.

• Develop complex SQL and PL/SQL queries, procedures, functions, and scripts for data processing and validation.

• Perform data cleansing, transformation, reconciliation, and data-quality checks.

• Validate data loaded into OFSAA against source systems and agreed requirements.

• Investigate and resolve data discrepancies affecting ALM/IRRBB calculations and outputs.

• Support SIT/UAT by preparing test data, performing data validation, and resolving ETL-related issues.

• Work closely with the OFSAA ALM techno-functional team, bank data teams, DBAs, and implementation vendors.

• Prepare technical documentation covering ETL processes, mappings, transformation rules, and data dependencies.

Required Experience and Skills:

• 2–5 years of relevant experience in ETL development, data engineering, or banking technology.

• Strong hands-on experience with SQL and PL/SQL.

• Experience with at least one enterprise ETL tool, such as:

• o Informatica

• o Microsoft SSIS

• o Oracle Data Integrator (ODI)

• o DataStage, Talend, or equivalent.

• Experience developing source-to-target mappings and transformation logic.

• Experience with data validation, reconciliation, and troubleshooting.

• Ability to work with large volumes of financial/banking data.

OFSAA / ALM Knowledge

• Knowledge of OFSAA ALM and/or IRRBB data requirements is preferred.

• Understanding of relevant OFSAA/SASA key tables and data structures is highly desirable.

• Ability to understand ALM data requirements relating to accounts/instruments, balances, cash flows, interest rates, maturity, repricing, currencies, and related attributes.

• Ability to translate functional requirements into technical ETL specifications and implementation.

• OFSAA implementation experience will be an added advantage.

Preferred Qualifications

• Bachelor's degree in Computer Science, IT, Software Engineering, Engineering, or a related field.

• Experience in banking or financial services.

• Experience with Oracle Database and enterprise data warehouses.

Key Competencies

• Strong analytical and problem-solving skills.

• Excellent SQL/PLSQL and ETL development capabilities.

• Strong attention to data accuracy and reconciliation.

• Ability to understand complex data requirements and convert them into practical ETL solutions.

• Good communication and collaboration skills.