BI_Resource

Informatica Knowledge - 60 and OBIEE Knowledge 40 is expected. Must Haves Informatica min 5 years DAC min 5 years RPD min 5 years OBIEE (Reports, agents, web catalog) min 3 years Data Warehouse concepts (star schema, dimensions, facts) min 5 years Nice to Haves Power BI SQL PL/SQL Position Description and Tasks to be performed: Design and Implement the ETL Informatica and Oracle Business Intelligence architecture for the Agency Configure Informatica 9.6.1 and Oracle Business Intelligence 11.1.1.7.0 with Oracle database to store the repository, metadata information and the agency data Create Data Warehouse Dimensional Model as the BI solution Develop complex ETL Informatica Mappings for the Organization using various transformations available in Informatica like Expression, Lookup, Router, Joiner, Sequence Generator, Sorter, Filter, Aggregator and Update Strategy transformations for populating the target tables in the data warehouse Implement Slowly Changing Dimensions (SCD Type-1 and SCD Type-2) according to the Business requirements to capture the changes while maintaining the historic information Troubleshoot performance issues in the mappings and optimize performance by tuning the Informatica mappings Work with session logs, Informatica Debugger, and Performance logs for error handling to fix workflows and session failures In-depth understanding of RPD configuration, Load balancing & Security model Configure Logical Layer, Logical tables/dimensions, columns, Logical Joins/keys, set levels to support Drill-down, Aggregation, Level based hierarchies and Parent-child hierarchies Manage security privileges for each subject area and dashboards according to user requirements Develop various kinds of reports pivots, charts, tabular using global and local filters Work closely with end users to design reports & dashboards, suggesting better ways of reporting in OBIEE so that required information is visualized by end users Develop Reports/Dashboards with different Analytics views (Pivot table, Chart, Column Selector, with global and local filters) using Oracle BI Presentation services Provide post implementation support and necessary fixes for the user identified issues Other duties required Basic Qualifications: 5 years of experience developing solutions in an OBIEE 10/11G environment including Informatica PowerCenter (8.x/9.x) 3 years of demonstrated hands-on experience with OBIEE 11g presentation layer dashboards and analyses development. 3 years of demonstrated hands-on development experience with OBIEE 11g Repository development. 3 years of hands-on development experience with SQL and PL/SQL 5 years of hands-on experience in Dimensional Modeling 3 years of development experience with TOAD (SQL querying tool) 5 years for ETL Informatica Development Experience 3 years of Oracle OBIA/OBIEE application experience including implementation, configuration, troubleshooting, and report development Experience in upgrading the ETL/OBIEE environment from Informatica 8.6 to 9.6 and OBIEE 10.3 to OBIEE 11.7 Excellent Troubleshooting and root cause analysis skills Excellent communication and ability to document requirements and create functional and technical specifications Preferred Skills: 5 years of experience gathering requirements, designing, developing and documenting custom dashboards, reports, agents, actions, etc. 5 years of experience creating and modifying OBIEE reports Other Requirements: PowerBI knowledge is plus