Informatica ETL Developer

5+ years of Data Warehouse experience
5+ years of Informatica PowerCenter / ETL Experience
5+ years of complex SQL and Performance Tuning Experience
Strong hands on experience with Informatica and Oracle PL/SQL
Excellent verbal/written communication skills, end-client facing, team collaboration, and mentoring skills
Strong organization skills and ability to set priorities and schedule work deadlines.
Adapting to the team and organizational culture
Experience with Data Warehouse technologies within the domain of ETL/data integration, Business Intelligence, relational and multi-dimensional database systems
Integrations supporting standard data warehousing objects (type-2 dimensions, aggregations, star schema, etc.)
Develop stored procedures, database triggers and SQL queries where needed.
UNIX shell scripting & PL/SQL scripting experience.
Strong skills in using Informatica Power center to build ETL mappings, sessions and workflows.( Informatica 10.X.).
Strong experience in Data Warehouse design, build , implementation and Data Migration.
Experience on migration from one database to another using Informatica
Execute production data loads and excellent troubleshooting and debugging experience on production issues in lower environments.
Full lifecycle experience in waterfall and agile development methodologies.