OBIEE / Oracle Analytics / ETL Developer

Global Associates, Inc.
Menands, NY, United States
10 days ago

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
7 years minimum
Working hours
Regular working hours
Job source

Tech stack

Oracle WebLogic Server Information Systems Data Validation Data Governance Data Integrity Extract Transform Load (ETL) Data Warehousing Software Design Documents Dimensional Modeling Systems Analysis Oracle Business Intelligence Enterprise Edition Oracle Databases
+14 more
Performance Tuning Query Optimization Regression Testing SAS (Software) SQL Stored Procedures PL-SQL SQL Databases System Integration Testing Strategies of Testing Sql Optimization Bi Publisher Oracle Service Cloud Information Technology Data Lineage

Requirements

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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:52 min

Navigating data warehouse performance for application developers

Adnan Rahic · JS Congress

1:53 min

Mapping end-to-end data lineage for regulatory compliance

Ferd Scheepers · WWC 2022

2:36 min

Integrating business experts and conceptualizing analytical use cases

Stefan Donsa Stefan Donsa +1 · LIVE

1:40 min

Serving documentation and visualizing data lineage automatically

Matthias Niehoff Matthias Niehoff · WWC 2023

1:21 min

Establishing employee experience as an independent strategic discipline

Rudi Bauer Rudi Bauer +1 · Cappuccino with HR

1:45 min

Structuring data flow using a medallion architecture

Christoph Fassbach Christoph Fassbach +1 · WWC 2024

Videos

See all

Related articles

See all