Senior OBIEE/OAS Lead with Informatica
IT Engagements, Inc. · Menands, NY · 1 mo ago
Information TechnologyFull-time
About the role
Senior OBIEE/OAS Lead with Informatica
Responsibilities
- Supporting OBIEE 11g/12c and Oracle Analytics Server (OAS), including development, enhancement, migrations, web catalog, RPD, and BI Publisher deployments across enterprise reporting environments.
- Leading ETL teams and designing enterprise data integration architecture using Informatica, including data standards, governance, best practices, and mentoring for data warehouse initiatives.
- Administering OBIEE/OAS environments, including installation, configuration, upgrades, WebLogic administration, security setup, patching, migrations, and production support across DEV/QA/UAT/PROD.
- Experience in OBIEE performance tuning and troubleshooting, including query optimization, cache management, RPD tuning, aggregate navigation, and report/dashboard performance improvements.
- Experience in data modeling and system analysis, including dimensional modeling, star/snowflake schema design, source-to-target mapping, and technical design documentation for enterprise data warehouses.
- 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.
- Experience in advanced data validation and troubleshooting using SQL/PL/SQL to ensure data integrity, accuracy, and consistency across enterprise data pipelines and reporting systems.
- 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.
Requirements
- 10 years of experience (Not less than 10 years)
Qualifications
- Bachelor's Degree in IT field
Skills
- OBIEE 11g/12c and Oracle Analytics Server (OAS)
- Informatica
- Oracle database development
- ETL and BI testing
- Data modeling and system analysis
- End-to-end BI implementation and data governance
Benefits
N/A
Pay
N/A
Schedule
N/A