Location: Albany, NY 12236 (Hybrid - up to 50% remote with approval)

Contract: 5-Year Contract | (Minimum 6-Month Commitment Before Replacement)

Work Hours: 40 hrs / week | Monday-Friday

Onsite Requirement: Must be onsite in Albany, NY for minimum first 6 months

The Data Warehouse Developer is responsible for developing BI Publisher reports, OBIEE/OAS dashboards, ETL processes, SQL tuning, and supporting enterprise data modeling efforts. The resource will work closely with reporting and analytics teams on ongoing DW enhancements and migrations.

Mandatory Experience Requirements

The candidate must meet ALL the following:

Reporting & Analytics Tools

1 year BI Publisher complex reports using MS Word templates
3 years OBIEE MUDE (Multi-user Development Environment):
- RPD development
- Dashboards
- Analyses

ETL Experience (Any One Tool)

3 years ETL experience using:
- Oracle Warehouse Builder
- Attunity Compose
- Informatica PowerCenter
- Pentaho
- ODI
- Talend

SQL & Data Modeling

5 years SQL + PL/SQL in Oracle
2 years SQL tuning
3 years data modeling for reporting & analytics

Preferred / Bonus Experience

Extra scoring for:

Extra ETL experience beyond 3 years
Additional SQL/PLSQL experience beyond 5 years
Additional SQL tuning beyond 2 years
Additional Attunity Compose experience

Key Responsibilities

Develop and maintain BI Publisher complex reports
Create and optimize OBIEE/OAS dashboards, analyses, and RPD layers
Build and migrate ETL workflows using enterprise tools
Tune SQL/PLSQL for scalable performance
Support data modeling for analytics layers
Collaborate with analytics/reporting teams on DW enhancements

Education: Bachelor's in Computer Science, IT, or Engineering

Recruiter Submission Template -

Full Name:

Highest Degree (Field, University & Completion Year):

Total experience as Data Warehouse Developer?

Do you have at least 1 year experience creating BI Publisher complex reports using MS Word templates?

Do you have at least 3 years OBIEE MUDE experience (RPD, dashboards, analyses)?

Do you have at least 3 years ETL development experience using one tool (OWB, Attunity Compose, Informatica, Pentaho, ODI, Talend)?

Do you have at least 5 years SQL & PL/SQL development in Oracle?

Do you have at least 2 years SQL performance tuning experience?

Do you have at least 3 years data modeling experience for reporting & analytics?

Do you have experience maintaining RPD layers and building OBIEE/OAS dashboards?

Are you able to work onsite in Albany, NY for the first 6 months (mandatory)?

Do you reside within the contiguous United States?

Total Years of Overall DW/ETL/SQL/OBIEE Experience:

Motivation for Interest in This Position:

Contact Number:

Email ID:

LinkedIn Profile URL:

Full Address (Street, City, State, Zip):

Notice Period (in weeks):

Current Work Authorization Status (e.g., US Citizen, Green Card, H1B, etc.):

Expected Hourly Rate:

Is it W2 / C2C, If C2C, May I know your corporation name?

Are you ready to relocate on your own expenses at Albany, NY and commit to the minimum 6-month onsite requirement and full-time 40 hrs/week schedule?

Professional References (3 Required):

Reference Company #1:

Contact Person:

Address:

City, State, Zip:

Telephone Number:

Email Address:

Number of years Proposer or candidate provided services to this entity:

Brief description of the services provided:

Reference Company #2

Contact Person:

Address:

City, State, Zip:

Telephone Number:

Email Address:

Number of years Proposer or candidate provided services to this entity:

Brief description of the services provided:

Reference Company #3:

Contact Person:

Address:

City, State, Zip:

Telephone Number:

Email Address:

Number of years Proposer or candidate provided services to this entity:

Brief description of the services provided:

Veracity Software Inc

New Jobs

Data Warehouse Developer (Mid-Level Role)