Business Intelligence Developer (OBIEE/OAS & Oracle Data Warehouse) 13 years + Years of Exp
ACS -
Menands, United States of America
15 days ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Compensation
$ 95KJob location
Menands, United States of America
Tech stack
Computer Programming
ETL
Database Queries
JSON
Oracle Business Intelligence Enterprise Edition
Oracle
Oracle Warehouse Builder
SQL Stored Procedures
SQL Server Reporting Services
SQL Server Integration Services
Information Technology
Data Management
Requirements
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Experience designing and maintaining both logical and physical database models.
- Proven experience in Oracle database design and development, including the creation and management of triggers, packages, and stored procedures.
- Experience performing Extract, Transform, and Load (ETL) processes, including monitoring, troubleshooting, and resolving data load failures.
- Hands-on experience with SQL Server Integration Services (SSIS) design, development, and deployment.
- Experience developing and maintaining reports using SQL Server Reporting Services (SSRS).
- Strong SQL programming skills, including writing complex queries and working with JSON data in Oracle databases.
- Experience collaborating with stakeholders to gather data requirements, participate in status meetings, and communicate data-related updates.
- Ability to maintain accurate documentation and detailed logs of data management activities, processes, and issue resolution.
Benefits & conditions
- $85,000-95,000 per year