Data Warehouse Developer (Mid-Level Role)

Data Warehouse Developer (Mid-Level Role) 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 Tools1 year BI Publisher complex reports using MS Word templates3 years OBIEE MUDE (Multi-user Development Environment):RPD developmentDashboardsAnalyses ETL Experience (Any One Tool)3 years ETL experience using:Oracle Warehouse BuilderAttunity ComposeInformatica PowerCenterPentahoODITalend SQL & Data Modeling5 years SQL + PL/SQL in Oracle2 years SQL tuning3 years data modeling for reporting & analytics Preferred / Bonus Experience Extra scoring for: Extra ETL experience beyond 3 yearsAdditional SQL/PLSQL experience beyond 5 yearsAdditional SQL tuning beyond 2 yearsAdditional Attunity Compose experience Key ResponsibilitiesDevelop and maintain BI Publisher complex reportsCreate and optimize OBIEE/OAS dashboards, analyses, and RPD layersBuild and migrate ETL workflows using enterprise toolsTune SQL/PLSQL for scalable performanceSupport data modeling for analytics layersCollaborate 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: