ETL Developer
Posted Updated
Summary
Builds and maintains ETL processes that load banking data into Oracle OFSAA for ALM/IRRBB analytics: analyzing source systems, writing source-to-target mappings, complex SQL/PL-SQL, and validating and reconciling data. Core stack: SQL, PL/SQL, and enterprise ETL tools like Informatica, SSIS, or ODI.
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.