OFSAA ALM Data ETL Engineer

Techsurge Private Limited; Karachi Division; On-site; PKR 1,200,000 - 2,800,000; Full time

Job summary

Techsurge Private Limited is seeking an ETL/Data Engineering professional to design, develop, and maintain data pipelines for OFSAA ALM and IRRBB. The role requires extracting data from source systems, mapping to target structures, validating results, and ensuring data quality at scale.

You will work with OFSAA ALM/IRRBB data models, perform complex SQL/PLSQL, and collaborate with bank-data teams, DBAs, and implementation vendors to deliver accurate financial data processing solutions.

Qualifications

• 2–5 years of 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, MS SSIS, ODI, DataStage, or Talend.
• Experience developing source-to-target mappings and transformation logic.
• Experience with data validation, reconciliation, and troubleshooting.

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.

Skills

SQL

PL/SQL

Data engineering

Banking technology

2–5 years experience

Education

Bachelor's degree in Computer Science/IT/Software Engineering

Tools

Informatica

Microsoft SSIS

Oracle Data Integrator (ODI)

DataStage

Talend

Job description

Techsurge Private Limited is seeking an ETL/Data Engineering professional to design, develop, and maintain data pipelines for OFSAA ALM and IRRBB. The role requires extracting data from source systems, mapping to target structures, validating results, and ensuring data quality at scale.

You will work with OFSAA ALM/IRRBB data models, perform complex SQL/PLSQL, and collaborate with bank-data teams, DBAs, and implementation vendors to deliver accurate financial data processing solutions.