Datawarehouse and ETL with Informatica Power Center

Mandatory Technical Skills

Skills

Informatica Power Center 8.x, 9.x

• Should have at least 8+ years of hands-on development/maintenance experience in Informatica 8.x, 9.x
• At least 5 years of experience in Architect capacity to provide end to end ETL solution using Informatica and other ETL tools
• Knowledge / Experience on using Informatica Power center and ETL using different data sources
• Should be very proficient in PL/SQL
• Very good in SQL query optimization
• Should have excellent knowledge and experience on Informatica troubleshooting
• Experience on implementing auditing and error handling
• Experience in test planning, testing and implementation support
• Experience in creating mappings using complex transformations
• Should be able to provide solutions for complex scenarios, well versed with Informatica workflow manager.
• Experience in basic admin activities, migration, architecture is required.
• Exposure to other Informatica tools like Power Exchange, B2B, BDE (Big Data Edition) is required.

Preferred

• At least 12+ years of experience in DW/BI related technologies and tools
• At least 12+ years of experience in software development life cycle.
• At least 12+ years of experience in Project life cycle activities on development and maintenance projects.
• At least 8 years of experience in Design and architecture review.
• Ability to work in team in diverse/ multiple stakeholder environment
• Experience to Financial domain
• Analytical skills
• Experience and desire to work in a Global delivery environment
• Bachelor’s degree or foreign equivalent required. Will also consider one year of relevant work experience in lieu of every year of education
• More than 12 years of overall experience.
• More than 10 years of experience with Informatica
• Should have played Architect role

Note : NO OPT, H1 for this position

Client : Infosys