Senior BI Analytics/Data Warehouse Dev.Posted: November 7, 2009
The IDEAL CANDIDATE will have 3-5 years of progressive experience with Data Warehouse and ETL tools. Experience installing BI Analytics is a requirement. Experience using Informatica is a requirement. · Experience with OBIEE is a requirement. Experience with Oracle eBusiness Suite Applications is essential.
DESCRIPTION:
· Work as part of team to Design, Build and Test the implementation of BI Financial Analytics and Procurement Analytics into a Teradata database using Informatica to extract the data from source tables in Oracle eBusiness Suite.
· Set up the Dashboard reports in Oracle Business Intelligence Enterprise Edition (OBIEE).
· Assist with creation of reports, dashboards, etc. based on business user specifications.
· Assist users with refinement of dashboards and use of OBIEE.
· Assist development team with linking of key components of BI Analytics to specific data required for the reports that is stored in Teradata 3rd Normal Form.
· Assist with ongoing maintenance of Repository for OBIEE.
· Develop, maintain, and enhance business intelligence applications such as dashboards, queries and reports.
· Create reports, dashboards, etc. based on business user specifications.
· Assist with ETL Processes (Extract, Transform and Load).
· Assist users with refinement of dashboards and use of OBIEE.
· Support business users with data issue resolution and system access problems.
· Provide support on creation of ad hoc data warehouse queries.
· Provide production support.
REQUIRED SKILLS:
· Ideal candidate will have 3-5 years of progressive experience with Data Warehouse and ETL tools
· Experience installing BI Analytics is a requirement.
· Experience using Informatica is a requirement.
· Experience with OBIEE is a requirement.
· Experience with Teradata Data Warehouse would be a plus.
· Experience with Oracle eBusiness Suite Applications is essential.
· Ability to integrate various data sources with Multiple Relational Databases like Oracle, SQL Server, Lotus Notes and data from flat files.
· Experience in Oracle application development or in Teradata environment using SQL, PL/SQL, stored procedures, Triggers, Packages, etc. is a plus.
· Experience in analyzing and fine tuning SQL, PL/SQL queries in an Oracle or Teradata environment is a requirement.
· A firm understanding of development life cycle including analytical skills necessary to satisfy testing documentation and Change Management requirements.
· Knowledge of Java, JSP, HTML, XML development a plus.
· knowledge of Microsoft Windows 200x, and Lotus Notes is a plus. Please refer to job code 4187 when responding to this ad.
|
