Job Description :
Position: Informatica Developer
Locations: Farmington, MI
Duration: 6+ Months

Minimum Work Experience: 8+ Years

Must Have Skills:
1. Designing and implementing Informatica 10.1 Power Center mappings.
2. Knowledge in DB2 and Oracle databases.
3. Knowledge in RHEL Unix
4. Performance Optimization
5. Knowledge in Informatica server and application administration

Detailed Job Description:
7 of experience in Informatica Power center tools Hands on experience in Data Loading Should have handled huge data loads from transactional database to operational data store and create interfaces for data extracts to downstream applications Requirement analysis, create source to target mappings, develop complex mappings, ability to handle difference types of source and targets, well versed with parameter files and integrate tasks to create ETL workflows. End to end testing activities to verify.

Responsibilities:
1. Extensive experience in designing, building, validating, maintaining and documenting ETL mappings using Informatica Powercenter 10.1.1 client tools.
2. Should have good understanding in UNIX shell scripting. Should be well versed with ETL scheduling process using Autosys R11.
3. Will be accountable for operational support of production jobs including the maintenance and monitoring of job schedules. Should be expert in writing and performance tuning of SQL queries and performance optimization of ETL c