Senior Business Intelligence Developer
Location: Chicago, IL (out by O’Hare Airport)
Type: Full time/permanent hire
Contact: Mary at firstname.lastname@example.org
Note: This is an onsite position. US Citizens and Green Card Holders are encouraged to apply. Unfortunately, this position does not offer sponsorship at this time.
- Experience using Informatica PowerCenter in development of ETL mappings, transformations, and data flows.
- Experience in designing, building and supporting data warehouse solutions in Oracle 12i.
- Experienced in all aspects of the delivery of Distribution Sector BI solutions and related components: data warehousing, data management, BI architectures and tools, interfaces and conversions.
- In-depth knowledge of and experience in OBIEE RPD modeling, implementing a complex OBIEE security model, expert in manipulating OBIEE RPT system session variables for RPD, and Dashboard Answers solutions.
- Implemented OBI with BI Server CLUSTER and High Availability Presentation services.
- Expert OBIEE Administration – cache management, catalog migration and security setup. Knowledgeable in options like LDAP, SSO and external security table integration.
- Experienced in setup, configuration and troubleshooting of OBIEE (Scheduler/Delivers).
- Delivering reporting solutions based on OBIEE Dashboard/Answers, RPD, BI Publisher.
- Involved in all phases of SDLC, including functional requirements gathering, proof of concept, gap analysis, design, and development.
- Architect solutions for performance-related issues by tuning OBIEE requests/Dashboards using BI caching methods, aggregated navigation, partitioning the data warehouse tables and materialized views.
- Interact with all divisions of the company for their BI-based application requirements.
- Bachelor’s Degree and/or years of equivalent experience
- Required Skills: Informatica PowerCenter or MDM, OBIEE, PL/SQL, SQL, UNIX Shell Scripting, ODBC
- Preferred Skills: Oracle BI Certified Professional, Informatica Data Quality, Informatica Enterprise Data Catalog, Manta, Oracle Toad or other development platform, DOMO, XML, Java, MS Access, Visual Basic, HTML, Jira, Slack.
Forbes Technical Consulting