Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
datawarehouse Oracle OWB Developer Data Marts Reporting Developer ETL Processes Deve
 
Requirement id 15472
Job title Developer
Job location in Albany, NY
Skills required PL/SQL, datawarehouse, Oracle, OWB Developer Data Marts Reporting Devel
Open Date 12-Sep-2013
Close Date
Job type Contract
Duration 24 Months
Compensation DOE
Status requirement ---
Job interview type Face to Face interview
   Email Recruiter: coolsoft
Job Description Developer: PL/SQL, datawarehouse, Oracle, OWB Developer Data Marts Reporting Devel

Description Minimize section
A Data Warehouse/Business Intelligence Developer resource is needed for the OCFS Data Warehouse.

The primary job duties of this position include: data security, data modeling and database design, and assisting in establishing and maintaining standard development practices for the data warehouse.

The benefits to OCFS are primarily increased availability of CONNECTIONS data and an increase in reporting flexibility. The impact from not approving this request is a limitation on and a significant delay in the delivery of CONNECTIONS reports and the associated ODS data extract solution. The workload of the current Data Warehouse staff is too great to absorb the work performed by this resource.

1. Work in coordination with a team of developers to expand the current Data Warehouse.

2. Work with Business Analyst & customers on analysis and logical design for mappings and ETL.

3. Perform unit testing and correct all identified bugs.

4. Perform complex PL/SQL coding in a Data Warehouse environment.

5. Writing Extract/Transform/Load (ETL) routines for the Data Warehouse to support the CONNECTIONS initiatives.

6. Modify Data Warehouse routines as needed to support the functionality and security requirement for CONNECTIONS.

7. Design/model, construct, load, and validate the data tables though the enterprise Data Warehouse architecture to support CONNECTIONS Data Warehouse projects and Cognos Reporting.

8. Design & Develop the new/re-write NCANDS project.

Requirements:

1. 60 months experience in a data warehouse setting as a developer utilizing an enterprise data warehouse with dependent data marts. 7.5 10

2. 60 months experience using advanced Extract/Transform/Load techniques including bulk select, bulk insert, arrays, dynamic SQL and developing detailed incremental ETL processes. 7.5 10

3. 60 months experience building, maintaining and optimizing Data Marts for efficient usage by applications and users for such tasks as reporting. 7.5 10

4. 48 months experience in an Oracle Data Warehouse as a developer performing development work. 7.5 10

5. 60 months experience using PL/SQL 7.5 10

6. 48 months experience developing and testing maps in Oracle Warehouse Builder (OWB) or Informatica, including data versioning techniques. 7.5 10

7. 60 months problem solving technical issues demonstrating high ability to think and resolve issues under pressure. 7.5 10
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 15472 while calling.
 
Other jobs in NY: Albany (4), Bethpage (6), BUFALLO (1), Buffalo (6), Commack (4), Commack Long (1), Jericho (5), Long Island (4), Long Island City (2), Manhattan (5), Midtown NYC (1), New York (41), New York City (8), NYC (2),
PL/SQL job openings in Albany, NY
Jobs List

Expert Software Architect - 7164
Create date: 01-Sep-2022
Description:

Qualifications

Software Architect: Makes high-level design choices and dictates technical standards, including software coding standards, tools, and platforms. Designs multi-leveled architecture or component interactions of a large scale software system.
Expert 84+ months: Candidate is able to provide.... (This job is for - MVC Jobs in NY Albany Architect - (in Albany, NY))

Expert Business Analyst - 7140
Create date: 26-Aug-2022
Description:

Qualifications

Business Analyst- Analyzes an organization or business domain (real or hypothetical) and documents its business or processes or systems, assessing the business model or its integration with technology with distinct deliverables to a solution.
Expert 84+ months - Candidate is able to pro.... (This job is for - Obiee Jobs in NY Albany Analyst - (in Albany, NY))

Senior IT Specialist - 7028
Create date: 09-Aug-2022
Description:

Day-to-Day tasks

Guide an agile development team working on a complex employer account financial system, including designing and developing modules that establish receivables, calculate fees and interest, apply remittances, establish and reverse refunds, and reconcile funds and other account maintenance activi.... (This job is for - WODM J2EE Jobs in NY Albany Specialist - (in Albany, NY))

Expert Programmer - 7061
Create date: 04-Aug-2022
Description:

Qualifications

Programmer: Creates computer software. May specialize in one area of computer software or may write code for many kinds of software.
Expert (84+ Months):Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her .... (This job is for - REST SOAP Jobs in NY Albany Consultant - (in Albany, NY))

Expert IT Specialist - 7000
Create date: 20-Jul-2022
Description:

Qualifications

IT Specialist - Works in the field of Information Technology, experienced in the usage and support of a collection of development platforms, technical architectures or business applications and products that run on those platforms - beyond that of a Programmer.
Expert 84+ months - Candi.... (This job is for - ETL Jobs in NY Albany Specialist - (in Albany, NY))
 
 PL/SQL job openings in other states
Jobs List

NC FAST Senior Data Engineer (743008)
Create date: 30-Jul-2024
Hybrid

No of Submissions : 1

start date :08/12/2024

End date :08/08/2025

submission deadline : 08/06/2024

client info : NCDHHS-NCFAST

Note:

* Agency Interview Type: Either Webcam Interview or In Person

* DHHS-ITD requires the services of Specialists in the ro.... (This job is for - job Jobs in NC Durham Engineer - (in Durham, NC))

GDOT Esri ArcGIS Developer 2 (740541)
Create date: 26-Jul-2024
* Hybrid

No of Submissions : 2

Start date : 08/26/2024

End Date : 06/30/2025

Submission deadline : 08/09/2024

Client Info : GDOT - IT App

Note:

* Agency Interview Type : Either Web Cam or In Person

Description :

The Georgia Dept. of Transportation (GD.... (This job is for - job Jobs in GA Atlanta Developer - (in Atlanta, GA))

GDOT Esri ArcGIS Developer 3 (740540)
Create date: 26-Jul-2024
No of Submissions :2

Start date :08/26/2024

End Date :06/30/2025

Submission deadline :08/09/2024

Client Info :GDOT - IT App

Note:
* Agency Interview Type:Either Web Cam or In Person
* Hybrid

Description :


The Georgia Dept. of Transportation (GDOT) is seeki.... (This job is for - job Jobs in GA Atlanta Developer - (in Atlanta, GA))

NC FAST Data Engineer (735339)
Create date: 28-May-2024
Hybrid

No of Submissions : 1

start date :06/17/2024

End date :06/20/2025

submission deadline : 06/03/2024

client info : NCDHHS-NCFAST

Description :



The Department of Health and Human Services (DHHS) requires the a.... (This job is for - Oracle Jobs in NC Durham Engineer - (in Durham, NC))

VDOT System Analyst 2 (734662)
Create date: 01-May-2024
No of Submissions : 2

Start date : 05/20/2024

End date : 06/30/2024

Submission deadline : 5/6/2024

Client info : VDOT

Note :

* Hybrid

* Please submit candidates who already live in Richmond, VA

* Long-Term position requires onsite 3 days a week at 1401 East Br.... (This job is for - job Jobs in VA Richmond Analyst - (in Richmond, VA))
 
 PL/SQL job openings in NY
Jobs List

Expert IT Specialist - 7511
Create date: 19-Dec-2022
start date: 01/30/2023

End date: 01/30/2025

submission deadline: 12/26/2022

Note :

* On-site/Remote : On-site

* Interview : Phone or video call; then in-person

Description:

There are several application systems developed using .... (This job is for - J2EE Jobs in NY NewYork Specialist - (in New York, NY))

Expert Systems Developer - 7086
Create date: 15-Aug-2022
Description:

Qualifications

Systems Developer - Develops and implements applications and programs for the backend processing systems used in businesses and organizations.
84+ Months Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her.... (This job is for - job Jobs in NY Rensselaer Developer - (in RENSSELAER, NY))

Expert Systems Architect - 7009
Create date: 26-Jul-2022
Description:

Qualifications

Systems Architect - Defines the architecture of a computerized system (i.e., a system composed of software and hardware) in order to fulfill certain requirement, including a breakdown of the system into components, the component interactions and interfaces (including with the environment, especi.... (This job is for - ETL Jobs in NY NewYork Architect - (in New York, NY))

Expert Programmer - 6919
Create date: 12-Jul-2022
Description:

Qualifications

IT Specialist - Works in the field of Information Technology, experienced in the usage and support of a collection of development platforms, technical architectures or business applications and products that run on those platforms - beyond that of a Programmer.
Programmer: Creates compu.... (This job is for - J2EEAPEX Jobs in NY NewYork Consultant - (in New York, NY))

Expert Software Analyst - 6931
Create date: 08-Jul-2022
Description:

Qualifications

Software Analyst -Studies the software application domain, prepares software requirements, and specification documents. Liaises between the software users and the software developers. Conveys the demands of software users to the developers. Skills include working knowledge of software technology.... (This job is for - SSRS Jobs in NY Rensselaer Analyst - (in RENSSELAER, NY))
(Developer: PL/SQL, datawarehouse, Oracle, OWB Developer Data Marts Reporting Devel in Albany, NY)
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     

    About Us     Services    Privacy policy    Legal     Contact us