1. Home
  2. ETL Developer

ETL Developer

TechSurge Inc Unverified

Karachi , Pakistan

Apply Now

Posted Recently 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.

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.

Skills

data-cleansing-data-scrubbing Talend Oracle Informatica insurance-consulting-and-technology data-engineering training-and-development database-as-a-service-dbaas sensors-test-measurement data-validation extract-transform-and-load-etl data-processing performance-level-pl SQL data-model data-warehouse application-lifecycle-management asset-lifecycle-management-alm asset-liability-management-alm job-descriptions

Job Details

Total Positions:
1 Post
Job Shift:
First Shift (Day)
Job Type:
First Shift (Day)
Job Location:
Karachi, Pakistan
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

TechSurge Inc

· 11-50 employees - Karachi
Follow

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!
Try Rozee Premium

Similar Job Titles

ETL Developer

Naseeb Enterprise Inc, Karachi, Pakistan
Posted Oct 22, 2026

ETL Developer

Naseeb Enterprise Inc, Karachi, Pakistan
Posted Oct 21, 2026

Data Engineer - ETL

Naseeb Enterprise Inc, Lahore, Pakistan
Posted Oct 20, 2026

Database Administrator (DBA) – PostgreSQL

Naseeb Enterprise Inc, Islamabad, Pakistan
Posted Oct 22, 2026
View All
I found a job on Rozee!