OBIEE/OAS Lead with Informatica

Maagsoft Inc.
Menands, United States of America
2 days ago

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Menands, United States of America

Tech stack

Application Integration Architecture
Oracle WebLogic Server
Data Validation
Data Governance
Data Integrity
ETL
Data Warehousing
Software Design Documents
Systems Analysis
Oracle Business Intelligence Enterprise Edition
Oracle
Performance Tuning
Query Optimization
Regression Testing
SAS (Software)
SQL Stored Procedures
PL-SQL
SQL Databases
Strategies of Testing
Sql Optimization
Bi Publisher
Oracle Service Cloud

Requirements

  • 84 Months Experience supporting OBIEE 11g/12c and Oracle Analytics Server (OAS), including development, enhancement, migrations, web catalog, RPD, and BI Publisher deployments across enterprise reporting environments.
  • 72 Months Experience leading ETL teams and designing enterprise data integration architecture using Informatica, including data standards, governance, best practices, and mentoring for data warehouse initiatives.
  • 72 Months Experience in Oracle database development, including advanced SQL/PL/SQL programming, performance tuning, optimization, and conversion of complex SQL, stored procedures, and SAS logic into Informatica mappings.
  • 72 Months Experience administering OBIEE/OAS environments, including installation, configuration, upgrades, WebLogic administration, security setup, patching, migrations, and production support across DEV/QA/UAT/PROD
  • 84 Months Experience in OBIEE performance tuning and troubleshooting, including query optimization, cache management, RPD tuning, aggregate navigation, and report/dashboard performance improvements.
  • 48 Months Experience in data modelling and system analysis, including dimensional modelling, star/snowflake schema design, source-to-target mapping, and technical design documentation for enterprise data warehouses.
  • 48 Months Experience in ETL and BI testing, including test strategy development, SIT, UAT, regression testing, data validation, reconciliation, and defect resolution across BI and data warehouse systems.
  • 48 Months Experience in advanced data validation and troubleshooting using SQL/PLSQL to ensure data integrity, accuracy, and consistency across enterprise data pipelines and reporting systems.
  • 48 Months Experience in end-to-end BI implementation and data governance, including requirements gathering, ETL development, semantic layer design, dashboard/report development, deployment, and enterprise data governance, lineage, and quality frameworks.
  • Bachelor's Degree in IT field

Required Documentation:

  • Resume
  • Copy of Candidate Identification (i.e., Driver's License//Visa and Passport if applicable)
  • Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.)

Apply for this position