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:
