Posted 2 days ago 6 views Report Job
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.
- 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.
- 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.
- 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.
- 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.
Job Details
Total Positions:
1 Post
Job Shift:
First Shift (Day)
Job Type:
Gender:
No Preference
Age:
18 - 65 Years
Minimum Education:
Bachelors
Career Level:
Mid-Level
Maximum Experience:
2 Years
Apply Before:
Oct 28, 2026
Posting Date:
Oct 22, 2026
What is your Competitive Advantage?
Get quick competitive analysis and professional insights about yourself
Talk to our expert team of counsellors to improve your CV!
Similar Job Titles
GIG-Senior Developer-Salesforce-Daikin
Naseeb Enterprise Inc, Hyderabad, Pakistan
Posted Oct 24, 2026I found a job on Rozee!
Ali Aziz
CEO
Shopistan
Aqib Irshad
Head of HR, Training & OD
FINCA
Zubair Anjum
Business Excellence Specialist
Nestle Pakistan
Usman Habib
Recruitment & Training Executive
ACS Synergy (Pvt) Ltd.
Zohaib Ali
Marketing Manager
Digital Online Devices
Mona Sharif
Senior Team Lead
Konext PVT. LTD
Ayesha Shaukat
Social Media Marketing Manager
Ivoke
Muzammil Baig
Digital Marketing Manager
IT Services Group
Sehrish Azhar
Motivational Speaker & Blogger
Living Upbeat
Babar Ahmed Khan
Territory Sales Manager
Engro Foods
