About This Role
This ETL Developer role focuses on analyzing, understanding, and transforming data for OFSAA ALM and IRRBB within a banking technology context. It involves developing and maintaining ETL processes, working with large volumes of financial data, and collaborating with various teams to ensure data accuracy and integrity.
Responsibilities
- 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
Requirements
- 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 Informatica, Microsoft SSIS, Oracle Data Integrator (ODI), 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
- 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
Nice to have:
- Knowledge of OFSAA ALM and/or IRRBB data requirements
- Understanding of relevant OFSAA/SASA key tables and data structures
- Ability to understand ALM data requirements relating to accounts/instruments, balances, cash flows, interest rates, maturity, repricing, currencies, and related attributes
