Sr. OBIEE | Informatica Consultant

Location: Gurgaon, Haryana, India

Department: Amex - Gurgaon - 1

Type: Full Time

Min. Experience: Experienced

Centroid is looking for a Senior Oracle Business Intelligence Consultant to play a hands-on role within our fast paced, high growth consulting organization. You will have the opportunity to work with our many clients on exciting BI projects, OBIEE and OBIA implementations, and custom BI/DW solutions utilizing leading edge Oracle technologies including Oracle Exalytics Engineered Systems.

We are seeking candidates that have expert level experience with Oracle’s BI Foundation Suite and BI Applications.  Experience with E-Business Suite is a plus.  The right candidate should have completed multiple full lifecycle implementations and should have deep technical knowledge of these solutions.

As a Sr. BI Technical Consultant, you will be expected to deliver fundamental guidance, planning, and actionable recommendations required to minimize project risks while accelerating implementation readiness and execution.  You should be familiar with proven methodologies to streamline the implementation process for new implementations and upgrades alike.

  • Candidate will be involved in the full software lifecycle covering planning, design, implementation, testing, documentation, delivery and maintenance of Oracle BI and Data Warehousing solutions.
  • Candidate will keep up to date on Oracle BI solutions including OBIEE architecture, Oracle BI tools, upgrade options, enhancement best practices, add-ons and features in OBIEE with a view to improving the productivity and quality of our projects.
  • Candidate will work with the business to gather requirements and guide them in understanding how to maximize their usage of Oracle BI.
  • Candidate must be able to analyze, estimate, and prepare functional and technical specifications.
  • Candidate must be able to identify where design decisions have wider impacts, and raising those as well as risks and issues as appropriate.
  • Candidate will communicate technical solutions to client and consulting staff in a clear and concise manner.
  • Candidate is expected to complete the build of code on time and as per application coding standards, and perform unit testing.
  • Candidate will create and maintain thorough, up-to-date, functional and technical systems documentation for any and all customization and maintenance actions taken. Perform and document program unit tests based on sample data, functional test conditions and stipulated expected results; resolve any issues of functionality (i.e., debug program logic errors).
  • Candidate must be a self-starter with solid interpersonal skills --- projecting a very positive customer-service-oriented attitude.
  • Must be a team player with solid verbal and written communication skills.
  • In addition to being a hands-on team member, the candidate will be involved in leadership activities providing technical guidance and training to other team members and clients.

Required  Experience:

  • 5+ years of experience in OBIEE (Oracle Business Intelligence Suite Enterprise Edition).
  • 5+ years of OBIEE Architect, Configuration, and Deployment experience.
  • 3+ years of Oracle BI Applications experience including Informatica, ODI, DAC, OBAW

Oracle BI Foundation Experience:

  • Hands on experience in developing & deploying RPD, including physical layer, business model and mapping layer, and presentation layers in OBIEE 11g.
  • Hands on experience in developing and deploying Analysis, Dashboards, BI Publisher, and Web Catalog in OBIEE 11g.
  • Experience developing complex data models and RTF templates using BI publisher.
  • Experience with migration techniques for OBIEE components into various test and production environments.
  • Experience with configuring and administration of multi-user development (MUD) environments in OBIEE 11g.
  • Experience with advanced OBIEE features for performance tuning such as aggregates and cache management.
  • Experience modeling and implementing OBIEE security at object and data levels.
  • Experience with deploying applications on Weblogic application servers.
  • Experience with OBIEE and Weblogic administration and patching.

Oracle BI Applications Experience:

  • Experience implementing and extending the Analytics Applications (Financial Analytics, Sales Analytics, Procurement & Spend Analytics, Supply Chain Analytics, etc.) for Oracle E-Business Suite (EBS).
  • Experience with implementation and administration of Data Warehouse Administration Console (DAC) to configure, monitor, and schedule ETL routines of the Oracle Business Analytics Warehouse.
  • Experience developing and extending ETL data mappings in Oracle Data Integrator (ODI) and Informatica.
  • Experience with tuning data integration flows to ensure optimum use of resources.
  • Experience developing and extending the Oracle Business Analytics Warehouse.
  • Technically proficient in all aspects of the Oracle BI Applications solution including OBIEE, Informatica ETL, ODI, DAC, and Data Warehousing/OBAW.
  • Experience with testing of the end-to-end solution and validating results with business representatives.

Oracle Database and Data Warehousing Experience:

  • Data warehouse design and development experience.
  • Excellent command of Data Warehousing, OLAP, and ETL best practices.
  • Experience writing SQL queries and optimization of SQL queries.
  • Expertise in understanding Oracle database and OLAP concepts.
  • Data modeling expertise with relational, multi-dimensional, and star and snowflake schemas.
  • Proficient use of Oracle technologies like materialized views, PL/SQL, & Stored Procedures (triggers, functions).
  • Experience designing fast data retrieval solutions, using a range of database and SQL tuning techniques.

Education Required:
Bachelor's degree in Computer Science, Business Information Systems, or Computer Information Systems or equivalent required.  Master’s degree preferred.


Forward this Position
Recipient email address (one)
Your name
Your email address
Enter a message (optional)
Apply for this Position
* Required fields
First name*
Last name*
Email address*
Location *
Phone number*

Attach resume as .pdf, .doc, or .docx (limit 2MB) or paste resume

Paste your resume here or attach resume file

Desired salary*
Earliest start date?*
What is your notice period ?*
What makes you a good fit for this position?*
Human Check*