Lead Informatica ETL Developer:PA:$55/hr

Lead Informatica ETL Developer

$55

1 year

Harrisburg, Pa

Web cam interview

 

The position serves as a senior/lead data warehouse developer for DW/BI solutions.  The candidate will lead DW/BI projects and initiatives related to the expansion of the enterprise data warehouse and development of new BI applications. The candidate will serve as the DW/BI team's Informatica expert, and is also expected to have very strong data warehousing experience, Oracle Pl/SQL, and data modeling skills.  Responsibilities will include Informatica architecture and technical support, Informatica ETL development and troubleshooting, dimensional modeling, SQL and PL/SQL development, Oracle performance tuning, and BI developer support. Technologies include Informatica PowerCenter 9.5, Oracle 11g, PL/SQL, and Business Objects XI.  Candidate can expect to spend 75%of their time doing hands-on development and 25% performing lead/architect duties.

 

Specific Duties:

 

1.Lead the full SDLC for DW/BI projects and initiatives, including business analysis, project leadership as well as technical design and development leadership.

2.Provide Informatica architecture and troubleshooting support, provide overall Informatica expertise, and lead Informatica ETL development efforts.

3.Oracle SQL and PL/SQL performance tuning and troubleshooting.

4.Perform data architecture duties, including leading OLAP and OLTP data modeling.

5.Intensive data analysis on source system databases.  Analysis of source system databases, identification of required data, and data profiling.

6.Support BI development using Business Objects XI tool suite (including Crystal reports, WebI, Dashboards).

 

IT experience Required 10 Years  

 

Data Warehouse experience Required 7 Years  

 

Informatica PowerCenter 8.x,9.x experience Required 5 Years  

 

Oracle development experience including writing complex SQL, writing PL/SQL, and performance tuning Required 5 Years  

 

Data modeling experience with at least 2 years doing dimensional modeling  Required 5 Years  

 

Data warehouse team lead experience. Required 2 Years  

 

Business analysis, including requirements gathering and testing Required 3 Years  

 

Excellent oral and written communication skills. Required      

 

DB2 and MS SQL Server experience Desired 3 Years  

 

Experience with Business Objects XI or similar BI tool Desired 2 Years  

 

Erwin 7.x or later Desired 3 Years

 

Thanks and Regards

Shweta Ojha

Technical Recruiter | Sage Group Consulting

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

Direct: 732-784-6492 | Email: sojha@sagetl.com

Gtalk: sojha1290|Ymail: ojha1290

 

 

--
You received this message because you are subscribed to the Google Groups "Entry level IT Jobs in US + H1B visa sponsor" group.
To unsubscribe from this group and stop receiving emails from it, send an email to entry-level-it-jobs-in-us-h1b-visa-sponsor+unsubscribe@googlegroups.com.
To post to this group, send email to entry-level-it-jobs-in-us-h1b-visa-sponsor@googlegroups.com.
Visit this group at http://groups.google.com/group/entry-level-it-jobs-in-us-h1b-visa-sponsor.
For more options, visit https://groups.google.com/d/optout.

0 comments:

Post a Comment

 
College & Education © 2012 | Designed by