Informatica Developer with Oracle 11g in harrisburg PA (8+ EXP)

Specific Duties:

 

1.            Meet with end users and technical staff to gather data requirements

2.            Perform intensive data analysis on source system data bases.  Analyze and understand source system

        database, find required data, and profile the data.

3.            Review and create dimensional and normalized data models.

4.            Develop Oracle SQL and PL/SQL code, including packages, procedures, functions, views and complex analytical

        queries.

5.            Develop complex ETL using Oracle PL/SQL and Informatica PowerCenter

6.            Diagnose, analyze, troubleshoot and choose appropriate solution to fix data related issues.

 

Required Skills and Experience

 

1.            Required:  7+ years Oracle development experience that includes writing complex SQL and PL/SQL, and doing

        performance tuning

2.            Required: 5+ years data warehouse development experience

3.            Required:  5+ years of data modeling experience

4.            Required: 2+ years dimensional modeling experience

5.            Required: 3+ years experience using data integration/ETL software tool(s)

6.            Required:  Strong oral and written communication skills

7.            Desired:  2 years Informatica PowerCenter ETL development experience

8.            Desired: 2 years MS SQL Server and/or DB2 experience

9.            Desired:  1 year experience with Business Objects BI Tool suite or comparable BI tool suite

 

 

 

 

--

  

 ------------------------

Thanks & Regards,

Tarun Vohra

Sr. Team Lead

Sage Group Consulting, Inc.

3400 Highway 35, Suite # 9, Hazlet, NJ 07730

Direct Phone: 732-479-1329

Office: 732-767-0010 EXT:210

Fax: 732-479-1329

Email    : tvohra@sagetl.com

Website : www.sageci.com

Yahoo IM : tarun.vohra

Gtalk IM : tarun.vohra84

--
You received this message because you are subscribed to the Google Groups "US Jobs: Requirements, Clients and Consultants" group.
To unsubscribe from this group and stop receiving emails from it, send an email to recruiters-r-us+unsubscribe@googlegroups.com.
To post to this group, send email to recruiters-r-us@googlegroups.com.
Visit this group at http://groups.google.com/group/recruiters-r-us.
For more options, visit https://groups.google.com/d/optout.