Senior Oracle SOA & ETL Integration Lead (Contract)

Infojini Inc; New York (NY); On-site; USD 80,000 - 120,000; Part time

Job summary

A government services company in New York, NY is hiring a Senior Oracle SOA Developer for a contract position. Responsibilities include researching backend databases, developing ETL processes, and creating REST APIs using Oracle technologies. Candidates should have at least 5 years of experience with SQL, PL/SQL, and data modeling, along with skills in dashboard creation using OBIEE and Power BI. This is a mid-senior level role requiring strong communication and teamwork abilities.

Qualifications

• Minimum 5 years of proficient experience in Oracle technologies such as SQL and PL/SQL.
• Minimum 3 years of proficient experience in dimensional data modeling.
• Minimum 5 years of proficient experience in ETL development using ODI.
• Minimum 5 years of experience creating dashboards and custom reports with Oracle OBIEE and Power BI.
• Understanding of Oracle SOA Dehydration Store schema for custom ETL with SOA/Fusion 12.2.1.4.

Responsibilities

• Research the backend database to identify required Objects for development.
• Create REST APIs in SOA/Fusion version 12.2.1.4.
• Develop ETL processes using Oracle Data Integrator (ODI) Tool version 12.2.1.
• Design dimensional models and Snowflake schemas using data cardinality principles.
• Build dashboards and reports with OBIEE and Power BI.

Skills

Oracle SQL

PL/SQL

Dimensional data modelling

ETL development using ODI

Creating dashboards with OBIEE

Power BI

Team collaboration

Strong communication skills

Tools

Oracle Data Integrator (ODI)

OBIEE

Power BI

Job description

A government services company in New York, NY is hiring a Senior Oracle SOA Developer for a contract position. Responsibilities include researching backend databases, developing ETL processes, and creating REST APIs using Oracle technologies. Candidates should have at least 5 years of experience with SQL, PL/SQL, and data modeling, along with skills in dashboard creation using OBIEE and Power BI. This is a mid-senior level role requiring strong communication and teamwork abilities.