Current Job Openings

Database Architect: 800 North Pearl, Menands, NY 12204

Due Date:
Tuesday, February 25, 2020 10:00 PM

Job Title:
Database Architect

800 North Pearl, Menands, NY 12204

Scheduled Work Hours:
Full Time - TBD

Service Scope:
Daily Tasks will include but not limited to the following:

1. Analyze the current architecture and processes in order to accurately develop an executable conversion plan;

2. Create and maintain requirements documentation which will include defining current processing and architecture and new processes and architecture;

3. Adhering to a project timeline and related project activities;

4. Using ETL software, develop ETL process to meet requirements as defined in requirements documentation and data models;

Develop business intelligence reports to meet requirements as defined in requirements document.

Mandatory Skills:
Database Architect:
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.

Senior: 60 - 84 months
Candidate is able to work independently, without assistance and provides guidance to others. May have an advanced education.

Desired Skills:
- 72 Months Experience with Oracle OBIEE 11g presentation layer, dashboards, analyses development, OBIEE Repository development and BI Publisher Objects.
- 36 Months Experience with INFORMATICA 9.x or higher in a data warehouse environment implementing warehousing concepts, complex mapping and merging data from multiple source systems such as Sybase IQ, ORACLE, XML, and flat files.
- 36 Months Experience with OBIEE Repository Migration and Catalog Migration to Production Environment.
- 84 Months Experience developing complex SQL, PLSQL with Oracle 8g, 9i, 10g or higher to migrate data (i.e. Sybase IQ to Oracle dimensional model).
- 48 Months Experience with developing dashboard page and landing page using HTML, CSS JavaScript.
- 36 Months Experience writing UNIX scripts to validate and ftp files, and for calling Informatica workflows.
- 36 Months. Experience converting complex PLSQL such as stored procedures to Informatica mappings.
- 18 Months Experience with Pentaho.
- Bachelor’s degree in computer science, information science, engineering, or mathematics.

Apply for this job

« Back to Current Job Openings