Senior Business Intelligence (BI) Developer
Johnson Controls
📍 Hyderabad, Telangana, India
Job Description
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 prac...