Senior Business Intelligence (BI) Developer at Johnson Controls

Hyderabad, Andhra Pradesh, India -

Full Time

Start Date

Immediate

Expiry Date

13 Sep, 26

Salary

0.0

Posted On

15 Jun, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Informatica PowerCenter, OBIA, OBIEE, Oracle BI Publisher, SQL, PL/SQL, Siebel CRM, Data Warehouse Architecture, DAC, OAS, OAC, ETL, RPD Development, XML, XSLT, Performance Tuning

Industry

Industrial Machinery Manufacturing

Description

Job Description- Candidate should have experience in at least 2 of the below tool sets. ETL - Informatica =================================== 5+ years of experience working with Informatica PowerCenter (especially with OBIA implementation or migration experience (for example, 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 (Oracle Business Intelligence Applications) solutions, especially with Siebel CRM as a source. repository (RPD) development, In-depth experience implementing and supporting OBIA (Oracle Business Intelligence Applications) solutions, especially with Siebel CRM as a source. Strong experience in Oracle SQL, Procedures and troubleshooting Reporting performance SQL issues fine tuning. . Bi Publisher ======================================== 5+ Years of Experience in Oracle BI Publisher. Oracle publisher Analytics. 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. Understanding of Siebel’s data model and web service framework. Ability to map Siebel business requirements to BI Publisher reporting solutions. Integrate Siebel CRM with BI Publisher, configuring data models that connect to Siebel’s 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. WSDL-based data sets using Siebel CRM web service integration for real-time or near-real-time reporting. 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 report. Johnson Controls: Enhancing the Intelligence of Buildings Your buildings have a purpose. They are places for people to live or work. Facilities for learning or healing. Venues for entertainment and shopping. Sites for the specialized storage of tangible goods or mission-critical data. Your buildings have a huge variety of functions; they are central to your mission. This is where Johnson Controls comes in, helping drive the outcomes that matter most. Through a full range of systems and digital solutions, we make your buildings smarter. A smarter building is safer, more comfortable, more efficient, and, ultimately, more sustainable. Most important, smarter buildings let you focus more intensely on your unique mission. Better for your people. Better for your bottom line. Better for the planet. At Johnson Controls, we’ve been making buildings smarter since 1885, and our capabilities, depth of innovation experience, and global reach have been growing ever since. Today, we offer the world’s largest portfolio of building products, technologies, software, and services; we put that portfolio to work to transform the environments where people live, work, learn and play.

How To Apply:

Incase you would like to apply to this job directly from the source, please click here

Responsibilities

Design, develop, and maintain BI solutions including dashboards, reports, and ETL pipelines using OBIA and OBIEE. Collaborate with technical teams to map Siebel CRM data and ensure accurate reporting and system integration.