Lead Oracle Database Developer with OBIEE & ODI

About the role

Data architect to assist the Reporting team with MENA enhancements and other reporting duties. Position located in Albany, New York for a 7‑month engagement with NY State – Information Technology Services (ITS).

Responsibilities

• 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.
• Convert UNIX scripts into ODI.
• Convert Crystal Reports into OAS/OBIEE.
• Manage OBIEE reports and dashboard.

Requirements

• 12+ years of experience as a database architect determining structural requirements, reviewing objectives, evaluating systems, coding utilities, and resolving problems.
• 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.
• 100% onsite work required.
• Ability to provide copy of candidate identification (Driver’s License/Green Card/Visa and Passport if applicable) and any requested qualifications documents.