Senior Business Intelligence

Role Overview: You should have experience in at least 2 of the following tool sets: ETL - Informatica: - 5+ years of experience working with Informatica PowerCenter, especially with OBIA implementation or migration experience (e.g., 7.9.x to 11g/12c). - Hands-on experience with OBIA (Oracle Business Intelligence Applications), including prebuilt and custom ETL scenarios. - Proficient with DAC (Data Warehouse Administration Console): configuring, managing, scheduling, and monitoring ETL execution plans. - Expertise in data warehouse architecture, star/snowflake schema, slowly changing dimensions, and ETL best practices. - Strong SQL skills; experience with Oracle databases (writing, debugging, optimizing SQL and PL/SQL). - Understanding of performance tuning and troubleshooting in Informatica and DAC. - Familiarity with source control, release migration, and OBIA upgrade practices. - Monitor daily DAC execution plans and troubleshoot failures. - Migrate ETL code and DAC configurations between environments (dev/QA/prod). OBIEE/OBIA Technical Consultant (Siebel): - 5+ years of experience working with OBIEE / OAS / OAC. - Design, develop, and maintain OBIEE dashboards, reports, KPIs, and analyses based on business requirements. - Implement, configure, and customize OBIA pre-built analytics modules (e.g., Sales, Service) for Siebel CRM. - Map and extend OBIA logical and physical data models to fit custom business needs. - Troubleshoot data, performance, and integration issues in OBIEE dashboards and OBIA ETL pipelines. - Analyze and translate business requirements into technical BI solutions. - Work closely with Siebel CRM technical and functional teams to map source fields and understand business processes. - Perform data quality and validation activities to ensure accurate reporting from Siebel to OBIEE. - Collaborate on system upgrades, patching, and migrations for OBIEE, OBIA, and Siebel integration. - Support production and non-production environments, monitor jobs, and resolve incidents related to BI processes. - Hands-on experience with Security (Support LDAP) and troubleshooting. - In-depth experience implementing and supporting OBIA solutions, especially with Siebel CRM as a source. BI Publisher: - 5+ Years of Experience in Oracle BI Publisher. - Hands-on experience in developing Oracle BI Publisher data models, reports, and templates (RTF and Excel). - Knowledge of Siebel EAI and SOAP-based integrations. - Consuming and parsing WSDL/web service responses. - Writing and tuning SQL queries against Siebel transactional or data warehouse schemas. - Ability to map Siebel business requirements to BI Publisher reporting solutions. - Integrate Siebel CRM with BI Publisher, configuring data models that connect to Siebels transactional database and invoking Siebel web services as XML data sources. - Develop data models in BI Publisher that leverage SQL queries directly against Siebel OLTP or data warehouse schemas. - Test and validate reports for data accuracy, performance, and layout correctness when consuming both SQL and web service data from Siebel. - Experience with BI Publisher administration (user roles, security). - Experience with report scheduling, bursting, Sub-templates, and distribution in BI Publisher. - Familiarity with XML, XSD, and XSLT for template development. - Creating and troubleshooting Scheduled reports. Role Overview: You should have experience in at least 2 of the following tool sets: ETL - Informatica: - 5+ years of experience working with Informatica PowerCenter, especially with OBIA implementation or migration experience (e.g., 7.9.x to 11g/12c). - Hands-on experience with OBIA (Oracle Business Intelligence Applications), including prebuilt and custom ETL scenarios. - Proficient with DAC (Data Warehouse Administration Console): configuring, managing, scheduling, and monitoring ETL execution plans. - Expertise in data warehouse architecture, star/snowflake schema, slowly changing dimensions, and ETL best practices. - Strong SQL skills; experience with Oracle databases (writing, debugging, optimizing SQL and PL/SQL). - Understanding of performance tuning and troubleshooting in Informatica and DAC. - Familiarity with source control, release migration, and OBIA upgrade practices. - Monitor daily DAC execution plans and troubleshoot failures. - Migrate ETL code and DAC configurations between environments (dev/QA/prod). OBIEE/OBIA Technical Consultant (Siebel): - 5+ years of experience working with OBIEE / OAS / OAC. - Design, develop, and maintain OBIEE dashboards, reports, KPIs, and analyses based on business requirements. - Implement, configure, and customize OBIA pre-built analytics modules (e.g., Sales, Service) for Siebel CRM. - Map and extend OBIA logical and physical data models to fit custom business needs. - Troubleshoot data, performance, and integration issues in OBIEE dashboards and OBIA ETL pipelines. - Analyze and translate business requirements into technical BI solut