Sign upLog in

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

ACS Consultancy Services

Menands, NY

Apply
JOB DETAILS
SKILLS
Acceptance Testing, Best Practices, Business Intelligence, Business Solutions, Computer Science, Configuration Management, Data Modeling, Data Quality, Data Warehousing, Database Design, Database Extract Transform and Load (ETL), Database Programming, Dimensional Modeling, Enterprise Data Integration, Identify Issues, Informatica, Information Technology & Information Systems, Integration Testing, Leadership, Mentoring, Oracle, Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle Database, Oracle PL-SQL, Oracle WebLogic Server, Performance Analysis, Performance Tuning/Optimization, Production Support, Production Systems, Quality Assurance, Query Optimization, Reconciliation, Regression Testing, Reporting Dashboards, Requirements Management, SQL (Structured Query Language), Security Patches, Snowflake Schema, Software Development, Star Schema, Stored Procedures, Strategic Planning, System Integration (SI), System Test, Systems Analysis, Team Lead/Manager, Technical Writing, Technical/Engineering Design, Test Data, Test Plan/Schedule, Test Strategy, Testing, Website Conversion
LOCATION
Menands, NY
POSTED
1 day ago

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

Location: Menands, NY (Hybrid)

We are currently seeking candidates who meet the following qualification

Qualifications:

  • 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.

If you meet these qualifications, please submit your application via link provided in Linkedin
Kindly do not call the general line to submit your application.

About the Company

A

ACS Consultancy Services