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