Informatica ETL Developer

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.

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…