What are the responsibilities and job description for the Oracle Data Integrator Developer position at Kapital Data Corp?
Technical Skills :
- Database Expertise :
Proficiency in SQL and PL / SQL for querying and manipulating data.
Hands-on experience with Extract, Transform, Load (ETL) tools like Oracle Data Integrator (ODI), Informatica, or Talend.
Familiarity with the architecture and data structures of the specific legacy systems being used (e.g., PeopleSoft, SAP, or custom-built systems).
A bility to create scripts for data extraction and transformation in languages like Python, Shell scripting, or PowerShell (a plus).
Strong knowledge of mapping legacy data to Oracle Cloud data structures.
Functional Skills :
Familiarity with the data models of Oracle Cloud modules (e.g., GL, AP, AR, Payroll, Core HR).
Awareness of business processes in finance (FSCM) and human resources (HCM) to validate and align data conversion.
Skills to validate extracted data and perform data cleansing to ensure consistency and accuracy.
Ability to identify and resolve issues during the data extraction and conversion process.
Soft Skills :
Ensuring the accuracy and completeness of extracted data.
Ability to collaborate with business analysts, functional consultants, and other team members to understand requirements and address issues.
Documenting the extraction process, transformations applied, and challenges encountered for future reference.
Preferred Experience :
