Senior OBIEE/OAS Lead with Informatica - 26-09449

Job Description

Job Description

Senior OBIEE/OAS Lead with Informatica

Location: Menands, New York
Duration: 30 Months
Experience Level: Senior
Education: Bachelor's Degree in IT or related field

We are seeking an experienced Senior OBIEE/OAS Lead with Informatica to lead enterprise business intelligence, data integration, and data warehouse initiatives.

The ideal candidate will have strong experience with OBIEE 11g/12c, Oracle Analytics Server (OAS), Informatica, Oracle databases, WebLogic, ETL, BI reporting, data modeling, performance tuning, testing, and enterprise data governance .

The candidate will provide technical leadership for BI and ETL initiatives, design enterprise data integration solutions, support BI platforms, optimize reporting environments, and ensure data quality across enterprise systems.

• Lead the development, enhancement, migration, deployment, and support of OBIEE 11g/12c and Oracle Analytics Server (OAS) environments.
• Develop and maintain Web Catalog, RPD, dashboards, reports, and BI Publisher solutions.
• Lead ETL teams and design enterprise data integration architecture using Informatica .
• Establish data standards, governance practices, development standards, and best practices.
• Mentor ETL and data warehouse development teams.
• Develop advanced SQL and PL/SQL solutions within Oracle database environments.
• Perform database performance tuning and optimization.
• Convert complex SQL, stored procedures, and SAS logic into Informatica mappings.
• Administer OBIEE/OAS environments, including installation, configuration, upgrades, patching, security, migrations, and production support.
• Support WebLogic administration and BI platform infrastructure.
• Support BI environments across DEV, QA, UAT, and PROD.
• Perform OBIEE/OAS performance tuning and troubleshooting.
• Optimize queries, cache management, RPD structures, aggregate navigation, dashboards, and reports.
• Analyze and resolve BI reporting and data warehouse performance issues.
• Design dimensional data models, including Star and Snowflake schemas .
• Develop source-to-target mappings and technical design documentation.
• Lead ETL and BI testing activities, including SIT, UAT, regression testing, data validation, reconciliation, and defect resolution .
• Perform advanced data validation and troubleshooting using SQL/PLSQL.
• Ensure data integrity, accuracy, consistency, and completeness across enterprise data pipelines and reporting systems.
• Participate in end-to-end BI implementation, including requirements gathering, ETL development, semantic layer design, reporting, testing, and deployment.
• Implement and support enterprise data governance, data lineage, and data quality frameworks .
• Collaborate with technical teams, business stakeholders, database teams, and data warehouse teams to deliver BI solutions.
• Provide technical leadership across architecture, design, implementation, and production support activities.

• 84+ months of experience supporting OBIEE 11g/12c and Oracle Analytics Server (OAS) , including development, enhancements, migrations, Web Catalog, RPD, and BI Publisher deployments.
• 72+ months of experience leading ETL teams and designing enterprise data integration architecture using Informatica .
• 72+ months of experience with Oracle database development , including advanced SQL/PLSQL programming, performance tuning, optimization, and conversion of 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, patching, migrations, and production support.
• 84+ months of experience with OBIEE performance tuning and troubleshooting , including query optimization, cache management, RPD tuning, aggregate navigation, and report/dashboard performance improvements.
• 48+ months of experience in data modeling and system analysis , including dimensional modeling, Star/Snowflake schema design, source-to-target mapping, and technical design documentation.
• 48+ months of experience in ETL and BI testing , including test strategy development, SIT, UAT, regression testing, data validation, reconciliation, and defect resolution.
• 48+ months of experience in advanced data validation and troubleshooting using SQL/PLSQL .
• 48+ months of experience in end-to-end BI implementation and data governance , including requirements gathering, ETL development, semantic layer design, dashboard/report development, deployment, data lineage, and data quality frameworks.
• Bachelor's Degree in Information Technology or a related field .