OBIEE Developer

Openkyber; Alaska; On-site; USD 120,000 - 150,000; Full time

Job summary

Openkyber in Menands, NY seeks a Senior OBIEE / Oracle Analytics / ETL Developer to lead enterprise BI initiatives. The role requires advanced OBIEE/OAS experience, ETL design using Informatica, and strong SQL/PL/SQL skills across complex data warehouses.

You will supervise ETL teams, administer OBIEE/OAS environments, perform performance tuning, data modeling, and ensure data governance, quality, and reporting reliability across DEV to PROD. A bachelor's degree is required.

Qualifications

• Proven experience with OBIEE 11g/12c and Oracle Analytics Server deployments.
• Strong ETL design and implementation using Informatica in enterprise data warehouses.
• Advanced SQL/PL/SQL performance tuning and query optimization.
• Experience administering OBIEE/OAS environments and WebLogic.
• Background in dimensional modeling and data governance for BI platforms.
• Hands-on BI testing, SIT/UAT, data validation, and defect resolution.
• Leadership of ETL development teams with mentoring responsibilities.
• Bachelor's degree in Information Technology, Computer Science, Information Systems, or related field.

Responsibilities

• Lead end-to-end BI/ETL initiatives across enterprise data warehouses.
• Design and optimize Informatica mappings and OBIEE dashboards/reports.
• Administer OBIEE/OAS environments, including WebLogic and security.
• Mentor ETL teams and enforce best practices for data governance and quality.
• Perform data validation, testing, and performance tuning for reliability.
• Collaborate with stakeholders to translate requirements into technical designs.

Skills

OBIEE / Oracle Analytics

ETL development

Informatica

Oracle SQL / PL/SQL

WebLogic administration

Data modeling

BI testing

ETL governance / data quality

Education

Bachelor's degree in IT/CS/IS or related field

Tools

Informatica PowerCenter

Oracle OBIEE

WebLogic

SAS

Job description

Title: Senior OBIEE / Oracle Analytics / ETL Developer Location: Menands, NY, USA Duration: 30 Months Required Qualifications

84 months of experience supporting OBIEE 11g/12c and Oracle Analytics Server (OAS), including development, enhancements, migrations, Web Catalog, RPD, and BI Publisher deployments in enterprise reporting environments.

84 months of experience in OBIEE/OAS performance tuning and troubleshooting, including query optimization, cache management, RPD tuning, aggregate navigation, and dashboard/report performance optimization.

72 months of experience leading ETL development teams and designing enterprise data integration solutions using Informatica, including data standards, governance, best practices, and mentoring for enterprise data warehouse initiatives.

72 months of experience in Oracle database development, including advanced SQL/PL/SQL programming, performance tuning, query optimization, and converting complex SQL, stored procedures, and SAS logic into Informatica mappings.

72 months of experience administering OBIEE/OAS environments, including installation, configuration, upgrades, WebLogic administration, security configuration, patching, migrations, and production support across DEV, QA, UAT, and PROD environments.

48 months of experience in data modeling and system analysis, including dimensional modeling, star and snowflake schema design, source-to-target mapping, and technical design documentation for enterprise data warehouses.

48 months of experience in ETL and BI testing, including test strategy development, System Integration Testing (SIT), User Acceptance Testing (UAT), regression testing, data validation, reconciliation, and defect resolution.

48 months of experience performing advanced data validation and troubleshooting using SQL/PL/SQL to ensure data integrity, accuracy, and consistency across enterprise data pipelines and reporting systems.

48 months of experience delivering end-to-end BI and data warehouse solutions, including requirements gathering, ETL development, semantic layer design, dashboard and report development, deployment, and implementation of enterprise data governance, data lineage, and data quality frameworks.

Bachelor's degree in Information Technology, Computer Science, Information Systems, or a related field.