Hi ,

Hope you are doing great!!

We have very urgent opening for the following positions and can setup
interview immediately.
If you have any suitable profile please send the resume in word format to
a...@compunnel.com,


*Position: ETL Data Warehouse Developer with OBIEEE*

*Location: Albany, NY*

*Duration: 6+ Months contract*



*Maximum Pay rate $45/hr on C2C*


*NO OPT/CPT*



*Must Have:*

·         *ETL development and OBIEE* *are the most important aspects*

·         *Data Warehouse*

·         *Data Modeling*

·         *Oracle 11g*

·         *SQL/ SQL Quey*



Description:

Sr. Developer Data Warehouse responsibilities include all aspects of the
OBIEE/ETL System Development Life Cycle. This involves design, development
and production support of OBIEE reports and dashboards, scheduling agents
and repository changes. For ETL, this involves design, development, and
production support of Informatica mappings and workflows, DAC scheduling
agent, and data warehouse database. The Sr. Developer will provide guidance
and mentoring on all components for OBIEE and ETL.



*Duties / Responsibilities:** Statements describing the essential
(absolutely necessary) actions performed to achieve required end results.*



·         Involved in design and development of repository
(creating/Modifying objects in Physical, Business and Presentation layer)
and the process of repository migration with AEG.

·         Creation/ maintenance of the STAR schema which forms the
framework of the OBIEE front end reporting platform.

·         Expressions mapped logical columns in BMM layer to physical
columns in the physical layer. Developed Reports/ Dashboards with different
Analytics Views (Drill-Down / Dynamic, Pivot Table, Column Selector,
Tabular with global and local Filters).

·         Involved in setting up Data level security for the BI Reports and
also handled the security and privileges from the Database to the Oracle
repository.

·         Work with AEG to perform and validate OBIEE
installations/upgrades.

·         Design, build and test new OBIEE reports including BI Publisher,
Dashboards, Answers, etc.

·         Researches and resolves technical problems associated with the
reporting applications.

·         Provide senior guidance on OBIEE Presentation Services and report
optimization techniques.

·         Create/ Update ETL Informatica jobs to load data from internal
and external systems to the data warehouse.

·         Create warehouse tables and extend warehouse columns to bring in
new source system changes.

·         Validate the data in the warehouse against the source systems.

·         Use of Data Warehouse Administration Console (DAC), for loading
and monitoring of the Oracle Business Analytics Warehouse.

·         Use of ETL processes to accommodate changes in source systems and
new business user requirements.

·         Work with AEG to perform and validate Informatica Powercenter 9.x
installations/upgrades.

·         Participate in defining standards and best practices for
administration.

·         Participate in defining and provide guidance on best practices
for developers.

*Education Required:*

   - Bachelor’s degree from an accredited college or university or
   equivalent experience.

*Background Experience Required:*


   - 7 years of experience in ETL development, data warehousing and data
   modeling.
   - Working knowledge in all phases of ETL development life cycle.
   - Has experience developing and maintaining Extraction, Transformation
   and Loading scripts using Informatica tool.
   - Has experience converting Business Information into Data Models.
   - Has knowledge in Data Flow Diagrams and ability to articulate Data
   flows in both business and IT terms from upstream application to downstream
   application.
   - Proven analytical skills.
   - Report development using OBIEE Analytics/Dashboard
   - Experience with Informatica.
   - Technical Skills / Knowledge Preferred: Oracle 11G; SQL; Knowledge of
   OBIEE.
   - Subject Matter Expertise/Experience Required.
   - Experience in performance tuning and loading optimization.
   - Ability to create technical documents and requirements.
   - Responsible for adhering to established safety standards
   - Must be able to remain in a stationary position for an extended period
   of time
   - Occasionally lifts, carries, or otherwise moves items weighing up to
   25 pounds
   - Work is constantly performed in an office environment
   - Performs other duties as may be assigned by management





Thanks and Regards,



*Amit Kumar*



*Sr. Talent Acquisition Specialist *



*Compunnel Software Group, Inc.*

*103 Morgan Lane, Suite 102, Plainsboro, NJ- 08536*

*www.Compunnel.com <http://www.Compunnel.com>*

Phone: (609) 606 9010 x 1786

Email: a...@compunnel.com

*Connect with me on Linkedin:*

https://www.linkedin.com/in/amit-kumar-83535084

-- 
You received this message because you are subscribed to the Google Groups "SAP 
ABAP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sap-abap+unsubscr...@googlegroups.com.
To post to this group, send email to sap-abap@googlegroups.com.
Visit this group at https://groups.google.com/group/sap-abap.
For more options, visit https://groups.google.com/d/optout.

Reply via email to