Employee Portal
Technical Lead Oracle Business Intelligence Consultant( Contract )
REFERENCE # 18-00110
TITLE # Technical Lead Oracle Business Intelligence Consultant

Meet Your Recruiter

Erin Chiz
Senior Technical Recruiter & Resource Manager
Phone: 860-674-1636 ext: 246
Email: echiz@itechsolutions.com
View ALL Jobs for Erin Chiz
View FEATURED Jobs For Erin Chiz

Meet Your Recruiter

Erin Chiz
Senior Technical Recruiter & Resource Manager
Phone: 860-674-1636 ext: 246
Email: echiz@itechsolutions.com
View ALL Jobs for Erin Chiz
View FEATURED Jobs For Erin Chiz
Technical Lead Oracle Business Intelligence Consultant

Consultant is Required to work on-site, 5 day/week and honor State work day/Holiday Schedule.
The Technical Lead Oracle Business Intelligence consultant will play an intermediary role between the functional and business functions assisting in the definition and implementation of a BI solution.
The Oracle BI Developer/ Administrator will be responsible for the installation, configuration, development and deployment of BI and supporting tools including OBIEE/ODI and BI Apps.  
  • Customize and build complex ETL mappings using ODI.
  • Interpret complex delivered multi-dimensional ETL maps.
  • Oversee and/or assist in the design and development of multi-dimensional ETL maps and views.
  • Performance tune ETL jobs, BI tools, sessions and queries.
  • Participate in installation/ configuration of BI tools.
  • Participate in definition of Security in Oracle BI tool.
  • Develop reports, dashboards, and hierarchies and implement security using OBIEE.
  • Develop and test application and automated interface processes.
  • Write SQL scripts and views.
  • Manage BI sessions, web browser, BI server and query cache.
  • Troubleshoot and resolve system and data issues.
  • Conduct unit, integration and user acceptance testing.
  • Participate in build out and test of batch schedule.
  • Participate in deployment of BI Solution.
  • Monitor, troubleshoot and resolve production support issues.
Required Skills / Experience:
  • A minimum of 5 years of dimensional data modeling and data profiling experience for data warehouse development.
  • A minimum of 3 years of experience with Enterprise data warehouse architecture and/ or design.
  • A minimum of 3 years of experience in ETL development and system analysis.
  • Multi-module experience preferred.
  • Specific skill with OBIEE/ OBI Apps/ ODI with exposure to PeopleSoft source data is preferred.
  • Experience working on a minimum of two (2) BI implementations.
  • Strong performance tuning skills of ETLs, queries and batch processes.
  • Experience with OBIEE (11g and higher), RPD, Answers, Reports and Dashboards.
  • Experience integrating disparate systems of record into conformed dimensions and fact tables.
  • Experience with PS Query preferred.
  • Excellent documentation and communication skills.
  • Strong Knowledge in Oracle SQL and PL/SQL
  • Basic knowledge in Linux Environment (ODI Server is running in Linux Servers)
  • Knowledge in Administering WebLogic Server 10.3.6
  • Knowledge in Administering OBIEE Enterprise Manager (Fusion Middleware Control)
  • Knowledge in Troubleshooting ODI related errors from the WebLogic / ODI Logs
  • Knowledge in startup, shutdown, error monitoring, troubleshooting WebLogic / ODI Servers.
  • Knowledge in applying Patches on ODI Environment. (WebLogic and ODI)
  • Working Knowledge in ODI 12c
  • Knowledge in Upgrading ODI 11g to ODI 12c ( WebLogic and OBIEE Components)
For more information please contact Erin Chiz at 860-261-2840.

Since 1995, iTech Solutions Inc., has been providing IT Consulting and Direct Hire Services to the Insurance, Financial, Communications, Manufacturing  and Government sectors with local offices in Connecticut, Minnesota, Colorado,  Massachusetts, Tennessee, and New Jersey / Pennsylvania area. 

Our recruiting strategy is simple, if you want to find qualified IT professionals then use IT professionals to find them.   So at iTech Solutions,  our personnel are all career IT professionals with a wide range of IT experience.  We can honestly say our staff understands the technologies, the complexities of finding and selecting the appropriate personnel and the pressures of running successful IT projects.  

Employer will not sponsor applicants for any employment visas, at hiring or in the future, including but not limited to H-1B visas. Corp-to-Corp or subcontract personnel will not be considered for this position.
Back Forward to a friend Apply Here

iTech Solutions is a National Professional Services Firm, specializing in Technical Staffing, Recruiting and Consulting Services for Information Technology, Engineering and Business professionals. iTech Solutions, Inc. does not support and will not post: Any posting that does not comply with applicable laws relating to labor and employment, equal employment opportunity and employment eligibility requirements; and Any posting that requires U.S. citizenship or lawful permanent residence in the U.S. as a condition of employment, unless otherwise required in order to comply with law, regulation, executive order, or federal, state, or local government contract.
iTech Solutions, Inc is an equal opportunity employer.
iTech Solutions is a E-Verify program participant. This employer will provide the Social Security Administration (SSA) and, if necessary, the Department of Homeland Security (DHS), with information from each new employee's Form I-9 to confirm work authorization.