ETL Developer

Description:

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

Required Skills & Experience

• 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.
• Strong understanding of relational databases, data models, joins, keys, indexes, and data relationships.
• 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.

Primary Objective

To ensure that accurate, complete, and appropriately transformed source data is delivered to the OFSAA ALM/IRRBB solution through robust ETL processes, with appropriate validation and reconciliation against the bank's source data and requirements.

Enable Skills-Based Hiring No

Attachments Name