Vacancy expired!
- Analyze and migrate existing reports from Oracle Discoverer (now de-supported) to OBIEE.
- Create BI models to meet business reporting and analytics requirements.
- Interact with users to understand and recommend reporting/BI solutions that meet diverse, complex business reporting and analytic needs.
- Design, develop, implement and customize these solutions.
- Analyze and understand the organization’s data in order to design appropriate data models to support self-service BI reports and dashboards. •
- Create interactive user and executive-level dashboards for various business units including corporate, finance, asset management, housing development, communications, and loan servicing.
- Maintain data security for business units based on their roles and responsibilities.
- Provide technical support to resolve any production issues.
- Work with a variety of technologies and tools, that currently includes:
- Informatica Designer and Workflow Manager.
- Scheduling execution plans for Informatica jobs in the Oracle Data Warehouse Administration Console.
- Oracle Business Intelligence Repository.
- Oracle Business Intelligence Dashboard Developer.
- Data modelling in the Oracle OBIEE and creating materialized views in OBIEE Repository.
- Design, develop, test and implement open interfaces in various Oracle modules.
- Define and develop an implementation strategy for newly released features of Oracle Business Intelligence and Informatica with respect to version upgrades.
- Design, develop, customize, and test data ETL and/or ELT mappings and workflows.
- A Bachelor’s Degree from an accredited college in a related field.
- Strong communication and problem-solving skills.
- 3 plus years relevant experience.
- Experience working with Discoverer and OBIEE reports.
- Experience working with Oracle Analytics Server.
- Experience working with Oracle Financials ERP.
- Functional knowledge of ETL tool Informatica.
- Experience in designing and creating complex OBIEE and Dashboards.
- Ability to work independently or as part of a team
- Experience working with technical leads and business owners
- Understanding of end-to-end BI/DW development and operations life cycle
- Hands-on experience in logical and physical data modeling
- Strong experience in querying raw data, optimizing SQL and troubleshooting SQL
- Functional knowledge of Oracle database and Oracle OBIEE
- Demonstrated ability to work in a highly dynamic business environment providing direct support to business users