Lead Oracle Database Developer with OBIEE & ODI

Sligo Software Solutions Inc.; City of Albany (NY); On-site; USD 120,000 - 160,000; Full time

Job summary

Sligo Software Solutions, Inc. seeks a Lead Oracle Database Developer with OBIEE & ODI to lead data architecture and BI integration for a NY State ITS client in Albany. The role emphasizes OBIEE/OAS development, ODI data integration, and dashboard management on an onsite basis.

The candidate will manage ODI scripts, data warehouse structures, and conversion tasks from UNIX to ODI, as well as migration of Crystal Reports to OBIEE/OAS. Strong SQL/PLSQL skills and UNIX experience are required.

Qualifications

• 12+ years of experience in data/BI environments.
• Experience analyzing client operations and requirements; provides database support.

Responsibilities

• Manage ODI SQL scripts for transferring, loading, and editing data between databases.
• Manage data warehouse to hold LATS and WFA data.
• Manage scripts for loading LATS and WFA data from extracts into Oracle tables using UNIX.
• Convert UNIX scripts into ODI.
• Convert Crystal Reports into OAS/OBIEE.
• Manage OBIEE reports and dashboards.

Skills

SQL/PLSQL

Oracle Database

Tools

ODI

OBIEE

UNIX

Oracle Analytics Server

Job description

Greetings from Sligo Software Solutions, Inc. !!
This is Dasharatham from SLIGO. We have an urgent requirement for Lead Oracle Database Developer with OBIEE & ODI position with our client.

Title: Lead Oracle Database Developer with OBIEE & ODI

Location: Albany, New York

Duration: 7 Months

Client: NY State - Information Technology Services (ITS)

Job ID: SLG - 26 - 11551

Respond by: 09/24/26 5:00 PM

Description

Data architect to assist the Reporting team with MENA enhancements and other reporting duties.

Duties

• Manage ODI SQL scripts for transferring, loading, and editing data between databases.
• Manage data warehouse to hold LATS and WFA (Work Force Analytics) data.
• Manage scripts for loading LATS and WFA data from extracts into Oracle tables using UNIX.
• Conversion of UNIX scripts into ODI.
• Conversion of Crystal Reports into OAS/OBIEE.
• Manage OBIEE reports and dashboard.

Mandatory Requirements

• Experience (12+ Years)
• Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems.

Requirements

• This is an 100% Onsite.
• 60 months of experience with Oracle Business Intelligence Enterprise Edition (OBIEE) / Oracle Analytics Server (OAS).
• 60 months of experience with Oracle Data Integrator (ODI).
• 60 months of experience with UNIX.
• 60 months of experience with SQL or PL/SQL.
• R sum
• Copy of Candidate Identification (i.e., Driver s License/Green Card/Visa and Passport if applicable)
• Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.)