Senior Business Intelligence (BI) Developer

As an experienced candidate in at least 2 of the mentioned tool sets, your role will involve: - Hands-on experience with Informatica PowerCenter, especially with OBIA implementation or migration experience (e.g., 7.9.x to 11g/12c) - Proficiency with DAC (Data Warehouse Administration Console) for 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 with experience in Oracle databases for 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 - Migrating ETL code and DAC configurations between environments - Monitoring daily DAC execution plans and troubleshooting failures For the OBIEE/OBIA Technical Consultant (Siebel) position, your responsibilities will include: - Designing, developing, and maintaining OBIEE dashboards, reports, KPIs, and analyses based on business requirements - Implementing, configuring, and customizing OBIA pre-built analytics modules for Siebel CRM - Mapping and extending OBIA logical and physical data models to fit custom business needs - Troubleshooting data, performance, and integration issues in OBIEE dashboards and OBIA ETL pipelines - Analyzing and translating business requirements into technical BI solutions - Supporting production and non-production environments, monitoring jobs, and resolving incidents related to BI processes - In-depth experience implementing and supporting OBIA solutions, especially with Siebel CRM as a source - Strong experience in Oracle SQL, procedures, and troubleshooting reporting performance SQL issues In the area of Bi Publisher, your tasks will include: - Developing Oracle BI Publisher data models, reports, and templates - Knowledge of Siebel EAI and SOAP-based integrations - Writing and tuning SQL queries against Siebel transactional or data warehouse schemas - Integrating Siebel CRM with BI Publisher and configuring data models that connect to Siebels transactional database - Testing and validating reports for data accuracy, performance, and layout correctness when consuming both SQL and web service data from Siebel - Experience with BI Publisher administration, report scheduling, bursting, sub-templates, and distribution - Familiarity with XML, XSD, and XSLT for template development This role requires a candidate with hands-on experience in the specified tool sets and a solid understanding of data warehousing concepts and BI reporting practices. As an experienced candidate in at least 2 of the mentioned tool sets, your role will involve: - Hands-on experience with Informatica PowerCenter, especially with OBIA implementation or migration experience (e.g., 7.9.x to 11g/12c) - Proficiency with DAC (Data Warehouse Administration Console) for 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 with experience in Oracle databases for 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 - Migrating ETL code and DAC configurations between environments - Monitoring daily DAC execution plans and troubleshooting failures For the OBIEE/OBIA Technical Consultant (Siebel) position, your responsibilities will include: - Designing, developing, and maintaining OBIEE dashboards, reports, KPIs, and analyses based on business requirements - Implementing, configuring, and customizing OBIA pre-built analytics modules for Siebel CRM - Mapping and extending OBIA logical and physical data models to fit custom business needs - Troubleshooting data, performance, and integration issues in OBIEE dashboards and OBIA ETL pipelines - Analyzing and translating business requirements into technical BI solutions - Supporting production and non-production environments, monitoring jobs, and resolving incidents related to BI processes - In-depth experience implementing and supporting OBIA solutions, especially with Siebel CRM as a source - Strong experience in Oracle SQL, procedures, and troubleshooting reporting performance SQL issues In the area of Bi Publisher, your tasks will include: - Developing Oracle BI Publisher data models, reports, and templates - Knowledge of Siebel EAI and SOAP-based integrations - Writing and tuning SQL queries against Siebel transactional or data warehouse schemas - Integrating Siebel CRM with BI Publisher and configuring data models that connect to Siebels transactional database - Testing and validating reports for data accuracy, performance, and layout correctness when consuming both SQL and web service data from Siebel - Experien