Oracle BI Developer (OBIEE/OAS & Informatica) 13+Years Exp

ACS -

Menands, NY, United States

13 days ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Compensation

$85,000.0 - $95,000.0

Working hours

Regular working hours

Job source

www.careerjet.com

Tech stack

Oracle WebLogic Server Information Systems Data Validation Data Governance Data Integrity Extract Transform Load (ETL) Data Mapping Data Warehousing Software Design Documents Dimensional Modeling Systems Analysis Oracle Business Intelligence Enterprise Edition

+16 more

Oracle Databases Performance Tuning Query Optimization Regression Testing SAS (Software) Software Engineering SQL Stored Procedures PL-SQL SQL Databases System Integration Testing Strategies of Testing Sql Optimization Bi Publisher Oracle Service Cloud Information Technology Patch Management

Requirements

Experience supporting OBIEE 11g/12c and Oracle Analytics Server (OAS), including application development, enhancements, migrations, Web Catalog management, RPD development, and BI Publisher deployment across enterprise reporting environments.
Experience leading ETL development teams and designing enterprise data integration solutions using Informatica, with expertise in data standards, governance, best practices, and mentoring team members on data warehouse initiatives.
Experience developing Oracle database solutions using advanced SQL and PL/SQL, including performance tuning, query optimization, and converting complex SQL, stored procedures, and SAS logic into Informatica ETL mappings.
Experience administering OBIEE/OAS environments, including installation, configuration, upgrades, WebLogic administration, security configuration, patch management, environment migrations, and production support across Development, QA, UAT, and Production environments.
Experience optimizing and troubleshooting OBIEE performance, including query optimization, cache management, RPD tuning, aggregate navigation, and improving dashboard and report performance.
Experience performing data modeling and system analysis, including dimensional modeling, star and snowflake schema design, source-to-target mapping, and creating technical design documentation for enterprise data warehouse solutions.
Experience planning and executing ETL and Business Intelligence testing, including test strategy development, System Integration Testing (SIT), User Acceptance Testing (UAT), regression testing, data validation, reconciliation, and defect resolution.
Experience performing advanced data validation and troubleshooting using SQL and PL/SQL to ensure data integrity, accuracy, and consistency across enterprise ETL processes and reporting environments.
Experience delivering end-to-end Business Intelligence solutions, including requirements analysis, ETL development, semantic layer design, dashboard and report development, deployment, and implementation of enterprise data governance, lineage, and data quality frameworks.
Bachelor’s degree in Information Technology, Computer Science, Information Systems, or a related technical field.