Logo
INENT, Inc.

Informatica ETL Developer

INENT, Inc., Santa Clara, California, us, 95053

Save Job

Company Description INENT Inc. focuses on understanding, addressing and resolving Talent Acquisition, Engagement and Management needs. The core team has over many years of experience in a variety of industries and management disciplines. We serve our clients with the highest level of service standards, never compromising our integrity and commitment to excellence. The products and services are targeted at niche markets in information technology, health care, Financial Services, government, education and other industries.

INENT Services Includes:

Software Development The services offered cover Custom Software Development, Application Development, Web Application Development, Software Outsourcing, Website Design and Software Maintenance. Our goal is to deliver premium quality software development services and products while giving unmatched value to enterprises worldwide at an affordable cost.

Staffing Solutions: INENT, Inc. provides full implementation, upgrade, support and staff augmentation services

Job Description The BI Technical Specialist will report into the Global IT Applications organization, with responsibility for analysis, design, development, configuration, customization, validation, deployment, and post-implementation support for enterprise Business Intelligence solutions. The successful candidate needs an in depth knowledge of OBIEE using Siebel CRM and Oracle E-Business Suite as the source systems. The reporting solutions will be based on the OBIEE reporting platform with Informatica as the ETL platform. The resource must have working knowledge of multiple Siebel CRM and Oracle E-Business Suite modules, including Sales, Marketing, Services, Financials, and Logistics. Must have knowledge across the entire BI technology stack (Database, ETL, metadata, front end development).

Core Responsibilities

Guide & mentor organization with the correct BI Design as well as data modeling

Participate in Technical Design Document creation

Collaborate with Technical and Business Analysts to design / extend the physical data model and security model

Participate in the design, configuration, development, and maintenance of Siebel Applications, Oracle E-Business Suite pre-built DAC and ETL repositories and execution plans.

Participate in the design, configuration, development, and maintenance of customized ETL mappings.

Building the business model and mapping layer which may include hierarchies, dimensions, and aggregates.

Provide an end to end BI solution by configuring metadata and building Analytics Repository, dimensional modeling design, building business models, generating reports and creating dashboards using Analytics and OBIEE.

Install, configure, tune and manage the enterprise ETL layer for enterprise BI solutions

Assist with continuous capacity planning and tuning for Performance for the ETL and OBIEE environments

The candidate must have the following competencies:

Ability to communicate verbally and in writing with all levels of employees and management, capable of successful formal and informal communication, speaks and writes clearly and understandably at the right level required including the ability to articulate complex technical information in a clear, concise manner both up and down the organization

Ability to work in complex business domains with rapidly changing requirements

Excellent analytical and troubleshooting skills - must approach problems and issues in a logical/systemic manner, research issues to the lowest level and resolve them decisively

Strong technical knowledge of Siebel’s packaged BI Applications, including approach to implementing, extending and supporting.

Ability to work independently and within a team environment with technical staff, and business experts to develop solutions to business requirements and client problems

Self-motivated and able to plan work effort and manage to schedule and priorities

Minimum of a Bachelor’s degree or equivalent in Computer Science, Electrical Engineering or in related field.

5+ years of technical experience in data warehousing, data management and data modeling.

Must have 3 years implementation experience with Oracle Business Intelligence (OBIEE) software

Working experience with SQL, PL/SQL, Unix, shell scripting

Demonstrated expertise in performance tuning enterprise-class BI solutions

Qualifications Technical Requirements

Hands-on experience in Data Warehouse implementation

Strong Informatica developer

Siebel CRM or some CRM as source data

Pentaho experience

RPD experience - plus

Plus: Experience in customizing OOTB Informatica workflows by following the standards recommended as well as developing new workflows and registering them in DAC.

Strong technical understanding of ERP data structures and how they relate to establishing data warehousing, data management and analytic architectures.

Solid understanding of the OBIEE Suite (OBI Server, Dashboard, Answers, and Analytics)

OBIEE architecture and administration experience

Hands on experience with ETL, Dimensional Modeling, and performance tuning of the BI applications

Must have experience with Oracle BI, Siebel 8.x, DAC, ETL, workflows. Pentaho experience a plus.

Experience in customizing workflows by following the standards recommended for customizing Oracle BI Applications as well as developing new workflows and registering them in DAC

Ability to understand ETL process and debug issues

Building the business model and mapping layer which may include hierarchies, dimensions, and aggregates

Experience with Solaris and Linux environments; experience with Windows administration, a plus

Knowledge of Oracle Business Intelligence Enterprise Edition Plus (OBIEE), Pentaho, and OLAP Reporting tools

Additional Information Job Location #J-18808-Ljbffr