Loading JobCrexa...

ETL Developer at Techsurge Private Limited | JobCrexa | JobCrexa

← Browse all jobs

T

ETL Developer

Techsurge Private Limited · Karachi, Pakistan

FULL TIME

Job Description

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.

#J-18808-Ljbffr