VS01710 - OFSAA ETL / ODI Technical Consultant

E4 Software Services Pvt Ltd.; Hinoba-an; On-site; PHP 800,000 - 1,200,000; Full time

Job summary

E4 Software Services Pvt Ltd. seeks a senior ODI/ETL developer to design, build, and optimize data integration pipelines for OFSAA finance data models.

You will collaborate with business teams to gather data requirements, map sources to targets, and ensure SIT/UAT and production support for OFSAA implementations. Must have 5+ years in ODI with strong SQL/PLSQL skills and experience in data staging structures.

Qualifications

• 5+ years of hands-on experience in Oracle Data Integrator (ODI), preferably supporting OFSAA implementations and financial services data models.
• Strong experience in designing, developing and maintaining ETL interfaces using ODI for extraction, transformation and loading of data from EDW/source systems into OFSAA.
• Experience in integrating data for OFSAA applications such as ALM, LRM, FTP, LLFP and PFT, including understanding of OFSAA staging/data structures.
• Strong SQL and PL/SQL skills, including development, troubleshooting and optimization of queries and database processing.
• Experience in ODI mappings, packages/workflows, scheduling, data transformations and performance tuning of ETL processes.
• Ability to perform source-to-target data mapping, data validation, reconciliation and troubleshooting of data-load/integration issues.
• Experience working with functional/business teams to understand data requirements and translate them into effective ODI/OFSAA integration solutions, including SIT/UAT and production support.

Responsibilities

• 5+ years of hands-on experience in Oracle Data Integrator (ODI), preferably supporting OFSAA implementations and financial services data models.
• Strong experience in designing, developing and maintaining ETL interfaces using ODI for extraction, transformation and loading of data from EDW/source systems into OFSAA.
• Experience in integrating data for OFSAA applications such as ALM, LRM, FTP, LLFP and PFT, including understanding of OFSAA staging/data structures.
• Strong SQL and PL/SQL skills, including development, troubleshooting and optimization of queries and database processing.
• Experience in ODI mappings, packages/workflows, scheduling, data transformations and performance tuning of ETL processes.
• Ability to perform source-to-target data mapping, data validation, reconciliation and troubleshooting of data-load/integration issues.
• Experience working with functional/business teams to understand data requirements and translate them into effective ODI/OFSAA integration solutions, including SIT/UAT and production support.

Skills

Oracle ODI

OFSAA

ETL Development

SQL

PL/SQL

Data Mapping

Data Integration

Production Support

SIT/UAT

Data Reconciliation

Job description

5+ years of hands-on experience in Oracle Data Integrator (ODI), preferably supporting OFSAA implementations and financial services data models.
Strong experience in designing, developing and maintaining ETL interfaces using ODI for extraction, transformation and loading of data from EDW/source systems into OFSAA.
Experience in integrating data for OFSAA applications such as ALM, LRM, FTP, LLFP and PFT, including understanding of OFSAA staging/data structures.
Strong SQL and PL/SQL skills, including development, troubleshooting and optimization of queries and database processing.
Experience in ODI mappings, packages/workflows, scheduling, data transformations and performance tuning of ETL processes.
Ability to perform source-to-target data mapping, data validation, reconciliation and troubleshooting of data-load/integration issues.
Experience working with functional/business teams to understand data requirements and translate them into effective ODI/OFSAA integration solutions, including SIT/UAT and production support.